Hello janetatkinson

Thank you for your interest in our plugin.

I am sorry to disappoint you, but unfortunately we don't have integration with WP All Import, so I cannot say if that will work or not.

You can definitely use JSON files to create tables, as you can see in our documentation.

You can also use our Query Constructor to access Custom posts, but please note that this tool is not an ultimate query generator. It simply constructs a suggestion of a query. We are constantly working to improve it, but SQL is such a complicated and flexible language that full automation for constructing queries is next to impossible. Consequently, the more complicated the query, the higher is the probability that it will not return exactly what you need. So, you will often need to play around with the resulting query.

Best regards.

Hello Janet.

If you have the JSON file somewhere (it has to be accessible via URL for wpDataTables to be able to read it, and use it), you could create a cron job which would update the contents of that JSON, sure.

You need to keep the structure and the URL to the file, though. If you add new columns, delete some columns or rearrange them, the table will break, and you will have to recreate it again.

Hi again Janet.

Unfortunately, we don't have any instructions for setting up a cron job, but you can see a detailed tutorial of how to set up cron at this link.

You can also test the plugin in our sandbox.

I hope this helps.