IMPORT.JSON examples - j5 - 28.0 - Administration & Configuration - Hexagon

j5 IndustraForm Designer Reference

Language
English
Product
j5
Search by Category
Administration & Configuration
j5 Version
2019

You can import JSON data using a URL - you can use any URL where JSON data is stored, reference the URL (as described below) and the JSON data is imported.

For details on how to format your JSON URL and how to reference its parameters, refer to IMPORT.JSON.

For example:

This URL (headers.jsontest.com) returns the following data in JSON format.

1JSON url

To import the JSON data into an IndustraForm, reference the URL in an IndustraForm subsection as follows.

2JSON import config

And then the data that you want can be bound to a key from the JSON data in that subsection.

Don't bind to column numbers - JSON calls are non-deterministic.

3JSON cell config

Notice that the BOUNDCOL("Host") matches this key in the JSON data.

4JSON key

After making your IndustraForm live, you need to authorize the JSON URL so that is it considered safe to use. URLS are authorized on the Authorized URL Requests configuration page.

After the URL is authorized, the JSON data for the reference keys appear in the IndustraForm.