Hello,

Thank you for reaching out to us.

Please provide me a temporary WP-admin (administrator) user for your site where this happens, so we could log in and take a look ‘from the inside’ as that’s the most efficient way to see and resolve the issue. 

We do not interfere with any data or anything else except for the plugin (in case that’s a production version of the site), and of course, we do not provide login data to third parties. 

You can write credentials here just check PRIVATE Reply so nobody can see them except us.

Hi,

thank you for the video and the initial screenshot.

1. We can tell you firstly,  from the initial screenshot, you tried to make an SQL Query out of this JSON data,

that is not possible - that is why you got the original error :

2.

But, in the video we see you have then tried to link the JSON data to a JSON linked table;

and you got the "Table in the data source has no headers" error;

We are not able to reproduce this on our Demo Site;

You can try it yourself if you wish -  here is our Sandbox Site;

We used https://shamanu.co.il/wp-json/data/gamel  for the JSON input, and we got no errors on our Demo.

Here is our video as well  https://watch.screencastify.com/v/wwYGsZ38yzCzG50CfVR3

I will reach out to ask our senior 2nd level Team,  to see what else we can try to help you isolate what the issue on your site is,

without having access to the site itself;

and we will report back right away as soon as they advise.

We will be as quick as possible.

-

I am just wondering since you're not able to allow us access to Wp-Admin, 

would you perhaps be able to make a Staging/Testing version of this site,

and you can strip down any sensitive data - we just wish to investigate the error with our plugin on your site.

Would you be able to provide us with a staging site, along with WP-admin (Administrator) user, FTP, and the database, so our developers can debug the plugin, and see what's going on?

If you're not able to provide us with a staging site, can you clone your website?

If yes - I'll ask you to install the Duplicator plugin. It will generate a couple of files that you can send me (along with the log-in credentials), and then I can create an exact copy of your website, see what the issue is and try to resolve it.

The Duplicator plugin can export only up to 500MB of data, so if your site is bigger than that, please use the All-in-One WP Migration plugin.

Please note that the files will be too large to attach to the ticket, so you can upload them via wetransfer.com and just send me the link.

-

Also, please check if this JSON file is sensitive data - in that case we can make this ticket as Private if needed?

Because at the moment the ticket is public, so anyone can see the JSON link;

and if you send us any credentials or a duplicator - please make sure to mark the reply as Private.

Thank you

Hello again,

i got advised by our senior 2nd level Team about this, they helped me take a closer look.

- 

Something like this is not possible in the way you are configuring it at the moment.

1. If you link the table to JSON file, this file has to have structure as we pointed out on this documentation. I will copy the important part here :

 Currently, wpDataTables accepts this, and only this format of JSON (see example on the docs page): 

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.

-

2. If your JSON file has multiple levels, then you will have to try the NESTED JSON method.

3. If you wish to use API, and to pull data from it,  then you will have to adapt it to PHP Array, and make a table linked to PHP Array.

-

Let me know if anything is unclear. Thank you