Solutions · Joomla and WordPress

How do I show data from a JSON API as a table?

Use the JSON File / API data source: give it the endpoint's address, tell it where in the response the rows are, and name the properties you want as columns. A real API response, wrappers and all, becomes a table that is refreshed whenever the page is served or the cache expires.

Step by step

1

The JSON File / API Data Source

This article explains how to configure the JSON File / API data source on Joomla and WordPress to read from REST endpoints and external APIs. It covers setting the JSON URL, Path to Rows Array for navigating wrapped responses, and Columns to Import for selecting and ordering specific properties. The article details common issues like missing path segments, empty columns, and server connectivity problems with cURL and allow_url_fopen.

Data Sources · Read the guide

2

The JSON Data Source

The JSON Data Source imports lists already published as JSON exports, endpoints, or files. It handles plain arrays of objects or arrays with no configuration needed. The article explains when to use JSON, the File path/URL, Character Encoding, and Empty results message fields, how the document should be structured, why every property becomes a column, how columns follow record order with no header row, the requirement that all records list properties identically, building steps including preview and cache options, and common issues like wrapped data, invalid JSON, allow_url_fopen requirements, missing column names, and shifted rows from incomplete records.

Data Sources · Read the guide

See it working

Have a different question?

The knowledge base covers every wizard, data source and option, and we are happy to answer anything it does not.

All solutions Contact us