Set up a mapping with Data Loader API
Learn how to prepare a mapping to load data using the Data Loader API.
When you want to load data into a tenant, create a mapping to ensure that the columns in your source match the attributes in Reltio's Data Model.
Use the following endpoint: POST {{dataloader_uri}}/dataloader/api/{{tenantId}}/_mapping
The mapping can be configured as the following example: {
"loadType": "RELATIONS",
"objectType": "configuration/relationTypes/Treating",
"startDate": "=source('col.7')",
"endDate": "=source('col.8')",
"sources": [
{
"key": "col.0",
"name": "startObjectCrosswalk",
"value": "=getCols(0)"
},
{
"key": "col.1",
"name": "startObjectCrosswalkEnd",
"value": "=getCols(1)"
},
{
"key": "col.2",
"name": "endObjectCrosswalk",
"value": "=getCols(2)"
},
{
"key": "col.3",
"name": "endObjectCrosswalkEnd",
"value": "=getCols(3)"
},
{
"key": "col.4",
"name": "relationshipCrosswalk",
"value": "=getCols(4)"
},
{
"key": "col.5",
"name": "relationshipCrosswalk",
"value": "=getCols(5)"
},
{
"key": "col.6",
"name": "attribute.Title",
"value": "=getCols(6)"
},
{
"key": "col.7",
"name": "relationStartDate",
"value": "=getCols(7)"
},
{
"key": "col.8",
"name": "relationEndDate",
"value": "=getCols(8)"
}
],
"attributes": [
{
"path": "attributes.Title",
"value": "=source('col.6')"
}
],
"crosswalks": [
{
"type": "configuration/sources/HMS",
"deleteDate": "=source('col.4')",
"value": "=source('col.5')"
}
],
"startObject": {
"crosswalks": [
{
"type": "configuration/sources/AHA",
"deleteDate": "=source('col.0')",
"value": "=source('col.1')"
}
]
},
"endObject": {
"crosswalks": [
{
"type": "configuration/sources/AMA",
"deleteDate": "=source('col.2')",
"value": "=source('col.3')"
}
]
}
}
When configuring the mapping, specify the type of data to load and the objectType to load on. Map the specific attributes to columns on your source and define the corresponding crosswalks.
For more information see our Developer Portal.
