POST request

/rdm-service/external/v2/import

file

Specify a CSV file that contains the code value attributes. The columns specified depend on your data model. The CSV must contain one or two header rows, followed by the data rows. If the occurrence of header row is one in the import CSV file, you must set the repeatHeaders field to false.

You can provide a single header row in the CSV file as it no longer requires two header rows.

For example, you might have the following code values:

key,from, to
key,from, to
AF_AFG,AF,AFG
AL_ALA,AL,ALA
ALB_ALB,ALB,ALB
DZ_DZA,DZ,DZA
AS_ASM,AS,ASM

importSettings

Specify the file-specific configuration and container details.

The

importSettings

includes the following attributes:

Field	Type	Description
delimiter	String	Delimiter used to separate values. Value must be COMMA , SEMICOLON , SPACE , or TAB .
textQualifier	String	Symbol used to indicate where a text begins and ends. Value must be DOUBLE_QUOTE , SINGLE_QUOTE , or NO_QUOTE .
codepage	String	Code page used for the import file. Value must be UTF8 or MS_WINDOWS .
dateFormat	String	Format used for dates. Use one of the following formats: DE . For dd.mm.yyyy format. ISO . For yyyy-mm-dd format. US . For mm/dd/yyyy format.
containerType	String	Type of asset that contains value mappings. Value must be crosswalk .
containerId	String	The ID of the crosswalk to which you want to import value mappings. You can find the ID of assets in Reference 360 or use REST APIs to retrieve the IDs. For more information, see Asset IDs.
startingRow	String	Line number from which to start importing data. By default, all rows are imported.
repeatHeaders	Boolean	Optional. Indicates whether the file has two headers. Value is true or false . Default is true .
mappings	Object	Optional. Maps the column headers in the CSV file with the target attributes of code lists in the key-value format. You can map the user-defined column name to source field name if required. You can either choose to ignore the mapping or map all the columns in an import CSV file. The key represents the header in the CSV file, and the value represents the field names in Reference 360.
approvalOptions	-	Includes details about the approval parameters.
priority	String	Optional. Defines the priority of the approval request. Value can be LOW , MEDIUM , HIGH , or CRITICAL .
dueDate	String	Use the following format: yyyy-MM-dd .
Comments	String	Comments that the requester adds to explain the changes.

POST response

POST example

POST https://use4-mdm.dm-us.informaticacloud.com/rdm-service/external/v2/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",
   "startingRow":null,
   "codepage":"UTF8",
   "dateFormat":"ISO",
   "containerType":"CROSSWALK",
   "containerId":"c31851709a749e2d53188ec0",
   "repeatHeaders":true,
   "mappings":{
      "key":"sourcePKey",
      "from":"_from.id.sourcePKey",
      "to":"_to.id.sourcePKey"
   },
   "approvalOptions":{
      "priority":"LOW",
      "dueDate":"2024-12-30",
      "comments":"Please approve the request"
   }
}
--6o2knFse3p53ty9dmcQvWAIx1zInP11uCfbm--

key,from, to
key,from, to
AF_AFG,AF,AFG
AL_ALA,AL,ALA
ALB_ALB,ALB,ALB
DZ_DZA,DZ,DZA
AS_ASM,AS,ASM

{
   "jobId":"32121c139c84a8edc8696c0c",
   "state":"INPROGRESS",
   "startTime":1631086520406,
   "numOfRecordsProcessed":100,
   "numOfRecordsFailed":25,
   "numOfRecordsSucceeded":75
}