Add JSON to tablepress

Hi,

thanks for your post, and sorry for the trouble.

Yes, you will need to write a custom JSON format converted. TablePress can only import JSON arrays of arrays, i.e.

[["row 1, col 1","row 1, col 2","row 1, col 3","row 1, col 4"],["row 2, col 1","row 2, col 2","row 2, col 3","row 2, col 4"],["row 3, col 1","row 3, col 2","row 3, col 3","row 3, col 4"]]

but not other structures (from APIs etc.)

Regards,
Tobias

Hi,

if you develop some sort of intermediate interface that maps from your API’s JSON format to a table structure JSON format (like above), you can use TablePress to display that data.

Regards,
Tobias

Hi Craig,

how often would you want to import from Google Docs? That’s the question. And of course the size of your table will play a role.

It might therefore be better to directly write e.g. a PHP script on your server that regularly fetches the data from your API and displays it.

Regards,
Tobias

Hi,

with a daily import of 30 rows you will not run into problems. The Google Docs solution could work then.

The PHP script would be separate. It would be the intermediate actor that TablePress would “call” for an import, and it would then retrieve and re-format the data from the API.

Regards,
Tobias

Hi,

no problem! Always happy to help!

Best wishes,
Tobias