Unify and manage your data

Developer resources

Developer resources Contents

About developer resources

Entity Management APIs

Relation Management APIs

Interaction Management APIs

Reference Data Management APIs

Load and Export APIs

Load and Export APIs at a glance

Export Service APIs

Data Loader API

Data Loader API upload requirements

JSON file loading example

Load data from a RELTIO_JSON file

Order of data loading jobs

Data Integration APIs

Workflow APIs

System Administration APIs

JSON file loading example

Learn about how the Reltio Data Loader transforms JSON file objects to a flat file when you load a JSON file.

Transform process

The Data Loader runs a transformation process on the data in the JSON file to transform it into a flat table. The flat table format makes the data available for the software to ingest. The Data Loader transform process works the same way to ingest the data in CSV or Excel files.

Note: You may use RELTIO_JSON files which don't need to go through the table transformation. For more details, see topic Load data from a RELTIO_JSON file.

Example

Check out this example of how the Data Loader transforms the JSON data into a flat table:

JSON file to be transformed.

[
  {
    "crosswalks": [
      {
        "value": "609-854-7156",
        "type": "configuration/sources/HMS"
      }
    ],
    "attributes": {
      "LastName": [
        {
          "value": "Fritz"
        }
      ],
      "FirstName": [
        {
          "value": "An"
        }
      ]
    },
    "type": "configuration/entityTypes/HCP"
  },
  {
    "crosswalks": [
      {
        "value": "203-564-1543",
        "type": "configuration/sources/HMS"
      }
    ],
    "attributes": {
      "LastName": [
        {
          "value": "Layous"
        }
      ],
      "FirstName": [
        {
          "value": "Ma"
        }
      ]
    },
    "type": "configuration/entityTypes/HCP"
  },
  {
    "crosswalks": [
      {
        "value": "203-564-1543",
        "type": "configuration/sources/HMS"
      }
    ],
    "attributes": {
      "LastName": [
        {
          "value": "Rantanen"
        }
      ],
      "FirstName": [
        {
          "value": "Ba"
        }
      ]
    },
    "type": "configuration/entityTypes/HCP"
  }
]

Resulting flat table

The transform results in a digestible flat table of data, which contains three data rows and five columns. The column headings correlate to the objects in the JSON file.


type_	type_crosswalks_1	value_FirstName_attributes_1	value_LastName_attributes_1	value_crosswalks_1
configuration/entityTypes/HCP	configuration/sources/HMS	An	Fritz	609-555-0197
configuration/entityTypes/HCP	configuration/sources/HMS	Ma	Layous	203-555-0543
configuration/entityTypes/HCP	configuration/sources/HMS	Ba	Rantanen	203-555-0543