|
<< Click to Display Table of Contents >> Navigation: EDP > EQuIS Link > Data Sources > Generic JSON Data Source for EQuIS Link |
The "Generic JSON" data source option allows users to load JSON data into any EQuIS format using EQuIS Link. For more information about the JSON formats, see this JSON Intro article.
To successfully map data from a JSON file to an EQuIS format with EQuIS Link, users must understand the structure of both the JSON file and the tables/fields of the EQuIS format to which the data are being mapped. Once understood, use the formula builder and normal data mapping processes to load the JSON data to the format.
Example 1 |
{ "Data": { "subData": [ { "Element1": "E1", "Element2": "E2" }, { "Element1": "E1", "Element2": "E2" } ] } }
EQuIS Link reads: •2 Tables = Data and subData Data is the root object property; others are tables. •4 Fields = Data, subData, Element1, and Element2 |
The JSON file must have a root object with one object property, Link will automatically format from JSON files meet this requirement. If the root element is an array Link will automatically add an outer root object with a single object property "data" and add an "array" object for the array (Example 2). If the root object has multiple properties Link will automatically add a parent property using "data" as the key (Example 3). If the root objects property is an array Link will automatically add a parent property using "data" as the key (Example 4).
Example 2 |
{ "data": { "array": [ { "Element1": "E1" }, { "Element2": "E2" }, { "Element3": "E3" } ] } }
EQuIS Link reads: •2 Tables = data and array •5 Fields = data, array, Element1, Element2, and Element3 |
Example 3 |
{ "data": { "Element1": "E1", "Element2": "E2", "Element3": "E3" } }
EQuIS Link reads: •1 Tables = data •4 Fields = data, Element1, Element2, and Element3 |
Example 4 |
{ "data": { "Array": [ {"Element1": "E1", "Element2": "E2"}, {"Element1": "E1", "Element2": "E2"}, {"Element1": "E1", "Element2": "E2"} ] } }
EQuIS Link reads: •2 Tables = data and Array •4 Fields = data, Array, Element1, and Element2 |
JSON files are converted to XML in memory before processing, and support XML attributes. To include XML attributes, prefix the attributes with '@' and set the node text with '#text'.
Example 5 |
{ "Data": { "subData": { "@Attribute1": "Sub1", "Element1": [ { "@ID": "1", "#text": "E1" }, { "@ID": "2", "#text": "EE1" } ], "Element2": [ { "@ID": "1", "#text": "E2" }, { "@ID": "2", "#text": "EE2" } ] } } }
EQuIS Link reads: •4 Tables = Data, subData, Element1, and Element2 •7 Fields = Data, subData, subData_Attribute1, Element1, Element1_ID, Element2, and Element2_ID (includes the XML attributes) |
Copyright © 2026 EarthSoft, Inc. • Modified: 03 Dec 2025