Hi Wellington,

I am sorry, but we are not fully understanding this use case and what you're trying to achieve exactly.

When we try loading the URL you sent, it does not load on any of our browsers, we get "This site can't be reached" error :


Now, the way you described this - It seems you are trying to send the data from a wpDataTable to an API?
If you can please confirm that part, or if you're trying something else, please try to clarify.

Thank you.

Hi Wellington,

My apologies, after re-reading everything, it seems you wish to simply use our Nested JSON method to pull data from a source API?

If that is the case :

1. For example, if you link the table to a 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, for example, some PHP adapter to return one of the formats that wpDataTables would accept.

2. Or, if your JSON file has multiple levels, then you will have to try our NESTED JSON method.

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

Please note, as we pointed out in that Documentation from the last hyperlink, when using a PHP Array as source data :

The format of the serialized array should be the following: 2D-array, where the parent level is an indexed array, and the second level is an associative array. 

Parent array entries will be parsed as rows, child array keys will be parsed as column headers, and child array values as cell values.

Let me know if that helps.