Set up a mapping with Data Loader API
Learn about mapping file columns to relationship attributes and crosswalks in the Data Loader API.
When you want to load data into a tenant, create a mapping to ensure that the columns in your source file match the attributes in Reltio's data model.
Use the following endpoint:
POST {{dataloader_uri}}/dataloader/api/{{tenantId}}/_mappingConfigure the mapping as shown in this example:
{
"loadType": "RELATIONS",
"objectType": "configuration/relationTypes/Treating",
"startDate": {
"value": "=source('col.7')",
"dateFormat": "dd-MM-yyyy"
},
"endDate": {
"value": "=source('col.8')",
"dateFormat": "dd-MM-yyyy"
},
"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 loadType and objectType, map source columns to relationship attributes, and define the associated crosswalks and date fields.
For more information, see our Developer Portal.