Hi VITGT,
Thank you for your interest in wpdatatables.

When working with JSON format please note: Currently, wpDataTables accepts this, and only this, format of JSON (see example): a one-level array of same-structured objects where each object will be parsed as a row, and each field inside of the object as a cell. If your software does not return this format, you would need to prepare, as an example some PHP adapter to return one of the formats that wpDataTables would accept.

You can read more about this in our documentation on this link.

We have Lite version of wpdatatables which you can try for free.

wpDataTables Lite is a basic version of a popular best-selling WordPress table plugin. While some premium features are reduced, wpDataTables Lite is still quite a handy tool that allows you to quickly create tables in WordPress from different sources. You can download it from this link.

You can try our sandbox site: Front-end & Back-end - you can find a fully functional version there to try out all plugin features.

Best regards.

Hi VITGT,

Unfortunately at the moment it is not possible with option Create table from JSON format.  However, it appears in requests from time to time, so we will add to our idea list and look into some possible solutions on plugin side in the future.

Best regards.

Hi scoutin,

Unfortunately not. This feature for now was not requested from users from time to time so it is not added on our TO DO list. Like I said in previous post if a lot of users request such features we will decently add it on our TO DO list in the future.

Thank you for understanding.

Best regards.

Hi cpUSA,

Thank you for your interest in wpdatatables.

When you create wpdatatables based on JSON in database in table wpdatatable wll be saved that URL in column content. That content then use wpdatatables engine  to get data over method jsonBasedConstruct in which we use CURL and you can find in file wp-content/plugins/wpdatatables/source/class.wpdatatable.php

You will need to customize method curlGetData which is helper function that returns curl data where you will set authentication header(in file wp-content/plugins/wpdatatables/source/class.wdttools.php) Please note that this function is used for other tables type so if you have only tables from JSON then that's fine, but if not then you need  to adopt for other table types as well that use this method.

Other option is to use PHP adopter option Creating Tables in WordPress based on serialized PHP arrays, where you can create your own logic to get data from  JSON API with authentication and adopt in format for wpdatatables.

We carefully follow customers requirements and try to implement most of them if they appear in requests from time to time.

We constantly strive to make our product better, and deliver the most value for our end users - so please share your feedback on what features you need in next versions on this link.

Best regards.

Hi to all,

Thank you for your interest in wpdatatables.

This will be added on our road map, but I can not tell you when it will be exactly, because there are priority features that have to be done first. Until that you can use a hook for filtering  curl options  that will be available in next update, so you will not have to replace your custom data again.

What you need to do is to replace function curlGetData in file wp-content/plugins/wpdatatables/source/class.wdttools.php around line 195 with this

/**
     * Helper function that returns curl data
     * @param $url
     * @return mixed|null
     * @throws Exception
     */
    public static function curlGetData($url)
    {
        $ch = curl_init();
        $timeout = 5;
        $agent = 'Mozilla/5.0 (Windows NT 6.2; WOW64; rv:17.0) Gecko/20100101 Firefox/17.0';
        curl_setopt($ch, CURLOPT_URL, $url);
        curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
        curl_setopt($ch, CURLOPT_CONNECTTIMEOUT, $timeout);
        curl_setopt($ch, CURLOPT_USERAGENT, $agent);
        curl_setopt($ch, CURLOPT_REFERER, site_url());
        curl_setopt($ch, CURLOPT_FOLLOWLOCATION, true);
        $data = apply_filters('wpdatatables_curl_get_data', null, $ch, $url);
        if( null === $data ) {
            $data = curl_exec($ch);
            if (curl_error($ch)) {
                $error = curl_error($ch);
                curl_close($ch);
                throw new Exception($error);
            }
            if (strpos($data, '<title>Moved Temporarily</title>')) {
                throw new Exception(__('wpDataTables was unable to read your Google Spreadsheet, probably it is not published correctly. <br> You can publish it by going to <b>File -> Publish to the web</b> ', 'wpdatatables'));
            }
            $info = curl_getinfo($ch);
            curl_close($ch);
            if ($info['http_code'] === 404) {
                return NULL;
            }
        }
        return $data;
    }

and then in functions.php of your theme or child theme to insert your custom code

function filterCURLOptions($data, $ch, $url){
    //
    // $data (null) is set to null if there are available filter
    //
    // $ch cURL handle returned by curl_init().
    //
    // $url (string) is URL of existing source(JSON, Google Sheet or PHP serialized array)
    //
    // Here you will insert your logic, because there are different JSON authentication
    // https://www.php.net/manual/en/function.curl-setopt.php
    //
    // Please note that this function is used for creating tables from JSON,Google sheets and PHP serialezed array
    // So you will need to filter it with some if statement based on $url parametar
    // 
    // Useful links
    //
    // https://stackoverflow.com/questions/30426047/correct-way-to-set-bearer-token-with-curl
    // https://stackoverflow.com/questions/60183353/php-how-to-make-a-get-request-with-http-basic-authentication
    // https://stackoverflow.com/questions/44331346/php-api-call-with-curl-and-authentication/44332142
    // https://stackoverflow.com/questions/2140419/how-do-i-make-a-request-using-http-basic-authentication-with-php-curl
    
    // Your code....
   
    return $data;
}
add_filter('wpdatatables_curl_get_data','filterCURLOptions', 10, 3);

Best regards.

Hello scoutin and Puru991.

I just checked with our lead developer, and he said that this should be included in one of our next updates.

Our team is busy preparing a big update, so we're not sure if they'll be able to squeeze this in, but if not - it is definitely planned for one of the following updates.

Sorry for the delay.

Hello Marty

We're still working on JSON authentication. It's almost ready, but I can't promise that it will be included in the next update. It should be, but if something goes wrong during the testing phase, it will be postponed.

Hello Rhianna

It's still in the testing phase. As soon as it's ready, it will be released. We hope it will be in the next update, but we can't make any promises. We are doing our best to test all use-cases so there aren't any bugs when this is released. Thank you for your patience.

Hello Frank.

JSON Authentication and Nested JSON has been released in wpDataTables 5.0, released in late September.

Feel free to check out the documentation and let me know if you have any further questions.