Reference 360

Back Next

Importing value mappings

You can import value mappings into a crosswalk. After you start an import job, you can check the status of the import job. If the import job fails, you can retrieve an error report.

Before you begin, you must get a session ID and identify the asset ID. The session ID authenticates your requests. The asset ID is the ID of the crosswalk to which you want to import value mappings. For more information, see Session IDs and Asset IDs.

To import value mappings into a crosswalk, use the Import value mappings REST API.

For more information about the Import value mappings REST API, see Import value mappings.

For example, the following request imports value mappings:

POST https://use4-mdm.dm-us.informaticacloud.com/rdm-service/external/v1/import HTTP/1.1
Content-Type: multipart/form-data; boundary=6o2knFse3p53ty9dmcQvWAIx1zInP11uCfbm
IDS-SESSION-ID: XXXXXXXXXXXXXXXXXXXXXX

--6o2knFse3p53ty9dmcQvWAIx1zInP11uCfbm
Content-Disposition: form-data; name=file; filename=import-value-mappings.csv

--6o2knFse3p53ty9dmcQvWAIx1zInP11uCfbm
Content-Disposition: form-data; name=importSettings
Content-Type: application/json;charset=UTF-8

{ 
  "delimiter":"COMMA",
  "textQualifier":"DOUBLE_QUOTE",
  "codepage":"UTF8",
  "dateFormat":"ISO",
  "containerType":"CROSSWALK",
  "containerId":"9ab3201990a54dcdc86f53AB",
  "startingRow":null
}
--6o2knFse3p53ty9dmcQvWAIx1zInP11uCfbm--

The CSV file might contain the following header rows and data rows:

sourcePKey,_from.id.sourcePKey,_to.id.sourcePKey
sourcePKey,_from.id.sourcePKey,_to.id.sourcePKey
AF_AFG,AF,AFG
AL_ALA,AL,ALA
ALB_ALB,ALB,ALB
DZ_DZA,DZ,DZA
AS_ASM,AS,ASM

The

containerId

attribute is the ID of the code list to which you want to import value mappings.

For example, the Import value mappings REST API returns the following job ID and import job information:

{ 
  "jobId":"dd1b2018cb47cef99f8d0f43",
  "state":"INPROGRESS",
  "startTime":1561367377428,
  "numOfRecordsProcessed":100,
  "numOfRecordsFailed":25,
  "numOfRecordsSucceeded":75
}

You use the job ID to check the status of an import job.

To check the status of an import job, use the Get import job status REST API.

For more information about the Get import job status REST API, see Get import job status.

For example, the following request retrieves the status of an import job:

GET https://use4-mdm.dm-us.informaticacloud.com/rdm-service/external/v1/import/job/dd1b2018cb47cef99f8d0f43 HTTP/1.1
IDS-SESSION-ID: XXXXXXXXXXXXXXXXXXXXXX

For example, the Get import job status REST API returns the following status of the import job:

HTTP/1.1 200 OK
Content-Type: application/json;charset=UTF-8
Content-Length: 193
{ 
  "jobId":"dd1b2018cb47cef99f8d0f43",
  "state":"INPROGRESS",
  "startTime":1561367376330,
  "numOfRecordsProcessed":100,
  "numOfRecordsFailed":25,
  "numOfRecordsSucceeded":75
}

To retrieve an error report for a failed import job, use the Get error report for failed import job REST API.

For more information about the Get failed import job report REST API, see Get failed import job report.

For example, the following request retrieves the error report for a failed import job:

GET https://use4-mdm.dm-us.informaticacloud.com/rdm-service/external/v1/import/job/dd1b2018cb47cef99f8d0f43/errorDetails HTTP/1.1
IDS-SESSION-ID: XXXXXXXXXXXXXXXXXXXXXX

For example, the Get error report for failed import job REST API returns the following error report:

HTTP/1.1 200 OK
Content-Type: application/json;charset=UTF-8
Content-Length: 354

{ 
  "jobId":"dd1b2018cb47cef99f8d0f43",
  "entityType":"Relationship",
  "fileName":"import.csv",
  "entityName":"rdm.crosswalk.rel.21ffd6b5f92d10c744acc27c.fc66c441288cf898c6fe5023",
  "errorDetails":[ 
    { 
      "lineNumber":1,
      "entitySourcePkey":"AF_AFG",
      "reasons":[ 
        "The requested resource with ID 'AFG' does not exist."
      ]
    }
  ]
}

Using REST APIs to import and export

Download Guide

Watch

Comments

Reference 360 Homepage

Communities

Knowledge Base

Success Portal