Mappings

Transformation Mappings

To get the transformation mappings, one can call the following endpoint using cURL:

curl --location '<baseUrl>/api/public/api/v1/mappings/transformation-mappings' \
--header 'Authorization: Bearer <APIKey>'

From this, the response returned will be a list of all transformation mappings that exist for the entity that belongs to the user:

[{
        "_id": "644692fb0b97a81e4b78a247",
        "entity": "5db9a359bd58de49c5eadf2d",
        "fieldName": "ADDR1_DATA-COUNTRY",
        "mapping": "0110",
        "sourceExpressionRaw": "<Corporate_Address_Country>",
        "sourceOfTruth": "spreadsheet",
        "characterLimit": 0,
        "comment": "Created by loader",
        "createdAt": "2023-04-24T14:32:27.917Z",
        "createdBy": "5d8aec25c25758d37debdc7a",
        "deleted": false,
        "sourceExpression": {
            "key": "Corporate_Address_Country"
        },
        "updatedAt": "2023-04-24T14:32:27.917Z",
        "updatedBy": "5d8aec25c25758d37debdc7a"
    },
    {
        "_id": "644692fc0b97a81e4b78a25e",
        "entity": "5db9a359bd58de49c5eadf2d",
        "fieldName": "ADDR1_DATA-CITY1",
        "mapping": "0110",
        "sourceExpressionRaw": "<Corporate_Address_City>",
        "sourceOfTruth": "spreadsheet",
        "characterLimit": 0,
        "comment": "Created by loader",
        "createdAt": "2023-04-24T14:32:27.999Z",
        "createdBy": "5d8aec25c25758d37debdc7a",
        "deleted": false,
        "sourceExpression": {
            "key": "Corporate_Address_City"
        },
        "updatedAt": "2023-04-24T14:32:27.999Z",
        "updatedBy": "5d8aec25c25758d37debdc7a"
}]

The transformation mapping data objects returned include metadata such updatedBy, which will hold the date the mapping was last modified.