Dynamically load data from external source

  • Resolved markc

    (@markc)


    3 years, 11 months ago

    Curious to know if it’s easy, or even possible at all, to dynamically load data into a table from a external PHP program that can return JSON data? I don’t mean to manually upload a static JSON file but call out to an external source on page load and perhaps even page through up to 10,000 rows 20 or 50 at a time?

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author TobiasBg

    (@tobiasbg)

    Hi,

    thanks for your post, and sorry for the trouble.

    No, sorry, that’s not directly possible. You would use the TablePress Extension from https://tablepress.org/extensions/table-auto-import/ but that would only work if the returned JSON data is a two-dimensional array. Also, it would not be live updates of the API data.

    A better approach might therefore be to use a custom solution that retrieves (and caches!) the API data, and renders an HTML table from it (a few PHP for loops). Then, you can add the JavaScript functions of the external DataTables JS library from https://datatables.net/ to get the pagination and other features.

    Regards,
    Tobias

    Hi There

    I’d love to see this feature added – e.g. the ability to dynamically load data from an external source; any simple source like CSV or jSON, etc.

    This would truly make this a product that could easily be updated ??

    Plugin Author TobiasBg

    (@tobiasbg)

    Hi,

    I don’t have plans for that beyond the options from above. Sorry.

    Regards,
    Tobias

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Dynamically load data from external source’ is closed to new replies.