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.

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-854-7156
configuration/entityTypes/HCP configuration/sources/HMS Ma Layous 203-564-1543
configuration/entityTypes/HCP configuration/sources/HMS Ba Rantanen 203-564-1543