Accelerate the Value of Data

Load data from a RELTIO_JSON file

Learn about how to load a RELTIO_JSON file to the Reltio Data Loader.

To load data from a RELTIO_JSON file:
  1. Create a new project. Use the following endpoint:
    POST {{dataloader_uri}}/dataloader/api/{{tenantId}}/project
    {
        "environment": "361",
        "tenantId": "myTenantIdValue",
        "name": "My user friendly name of the Project Details",
        "loadType": "ENTITIES",
        "checkForUpdates": false
    }
  2. Set the file type for the storageDetails parameter. Use the following endpoint:
    PUT {{dataloader_uri}}/dataloader/api/{{tenantId}}/project/data/source/{{storageId}}
    {
        "fileType": "RELTIO_JSON"
    }
  3. Update the storageDetails parameter. Use the following endpoint:
    PUT {{dataloader_uri}}/dataloader/api/{{tenantId}}/project/{{projectId}}
    {
        "storageDetails": {
            "storageId": "{{storageId}}"
        }
    }
  4. Start the loading job. Use the following endpoint:
    POST {{dataloader_uri}}/dataloader/api/{{tenantId}}/project/{{projectId}}/jobs/run
    Body
    {
        "name": "My Job Details"
    }
    Response
    {
        ...
        "udl": true,
        "id": "16d05069-d426-4d24-a672-d40e81a5a01x",
        ...
        "jobStatus": "SCHEDULED",
        "dataProcessingJobId": "866943b0-8725-42b7-b4bb-bb519e6c034x",
        ...
        "projectDetails": {
            ...
            "id": "8a68c8a2-7b3d-4279-8ffc-42809c39202x",
            ...
            "storageDetails": {
                ...
                "storageId": "d6b3fdef-5eed-42d4-ad52-6a21f2ebd60x",
                ...
                "fileType": "RELTIO_JSON"
            }
        }
    }

When loading data from a RELTIO_JSON file:

  • The file must be in JSON format. The body must contain data in JSON arrays.

  • Each file loaded must not exceed 10GB, although there is no limit on the total size of a loading job. If your data exceeds 10GB, split it across multiple files.

  • The loadType values that the Data Loader allows to be loaded with a RELTIO_JSON file are ENTITIES and RELATIONS.

  • This type of data loading job doesn't requires to define the mappingDetails parameter as it doesn't use this functionality.