JSON Files

JSON is a simple, lightweight data format. Despite its simplicity, it can represent complex structures that don't always fit neatly into a single database table. Currently, you can select one JSON node that contains an array of objects (rows). The elements within each object become the columns in your database table.

📌 To use the remote connection wizard, you must first enable our Premium Data Service on your WordPress server.

PREPARATION

Ensure your JSON file is available at a public URL before starting the remote connection wizard. Test your public URL to confirm it is accessible. (read more…)

CREATION

1. Start the Data Explorer.
2. Click the connect icon to open the remote connection wizard.
3. Select JSON file from the connection type drop-down list.
4. Enter the public URL of your data file in the file path field.
5. Define an update interval, or leave it blank if automatic updates are not required.
6. Enter the table object name (see JSON example: table object name = data).
7. Enter a table name.
8. Click the create button.

USAGE

• Tables created from JSON files can be used just like standard WordPress tables and are supported by all plugin tools.
• Read the limitations before you start.

JSON Sample

{"data": [
	{"empno": 7369, "ename": "SMITH", "job": "CLERK", "mgr": 7902, "hiredate": "1981-09-18", "sal": 1600.97, "comm": 10, "deptno": 20}, 
	{"empno": 7499, "ename": "ALLEN", "job": "SALESMAN", "mgr": 7698, "hiredate": "1981-02-21", "sal": 1680.98, "comm": 30, "deptno": 30}, 
	{"empno": 7521, "ename": "WARD", "job": "SALESMAN", "mgr": 7698, "hiredate": "1981-01-23", "sal": 1250.00, "comm": 500, "deptno": 30}, 
	{"empno": 7566, "ename": "JONES", "job": "MANAGER", "mgr": 7839, "hiredate": "1981-04-01", "sal": 2975.00, "comm": null, "deptno": 20}, 
	{"empno": 7654, "ename": "MARTIN", "job": "SALESMAN", "mgr": 7698, "hiredate": "1981-09-28", "sal": 1250.00, "comm": 1400, "deptno": 30}, 
	{"empno": 7698, "ename": "BLAKE", "job": "MANAGER", "mgr": 7839, "hiredate": "1981-05-01", "sal": 2850.00, "comm": null, "deptno": 30}, 
	{"empno": 7782, "ename": "CLARK", "job": "MANAGER", "mgr": 7839, "hiredate": "1981-06-09", "sal": 2450.00, "comm": null, "deptno": 10}, 
	{"empno": 7788, "ename": "SCOTT", "job": "ANALYST", "mgr": 7566, "hiredate": "1982-12-09", "sal": 3000.00, "comm": null, "deptno": 20}, 
	{"empno": 7839, "ename": "KING", "job": "PRESIDENT", "mgr": null, "hiredate": "1981-11-17", "sal": 5000.00, "comm": null, "deptno": 10}, 
	{"empno": 7844, "ename": "TURNER", "job": "SALESMAN", "mgr": 7698, "hiredate": "1981-09-08", "sal": 1500.00, "comm": null, "deptno": 30}, 
	{"empno": 7876, "ename": "ADAMS", "job": "CLERK", "mgr": 7788, "hiredate": "1983-01-12", "sal": 1100.00, "comm": null, "deptno": 20}, 
	{"empno": 7900, "ename": "JAMES", "job": "CLERK", "mgr": 7698, "hiredate": "1981-12-03", "sal": 950.00, "comm": null, "deptno": 30}, 
	{"empno": 7902, "ename": "FORD", "job": "ANALYST", "mgr": 7566, "hiredate": "1981-12-03", "sal": 3000.00, "comm": null, "deptno": 20}, 
	{"empno": 7934, "ename": "MILLER", "job": "CLERK", "mgr": 7782, "hiredate": "1982-01-23", "sal": 1300.00, "comm": null, "deptno": 10} 
]}