POST request

/rdm-service/external/v3/import/hierarchy

file

Specify a CSV file that contains the hierarchy relationships. The CSV file contains one header row with two columns: Code and ParentCode. You can list the related code values below the header.

For example, you might have the following relationships in the CSV file:

Code,ParentCode
C1,P1
C2,P2
C1,P3

If you import top-level code values, only use the Code column in the header row.

For example, you might have the following top-level code values:

Code
P1
P2
P3

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 .
hierarchyKey	String	Internal ID or alias of the hierarchy to which you want to import relationships.
parentCodeListKey	String	Internal ID or alias of the parent code list. If you import top-level code values, you do not need to provide this attribute.
childCodeListKey	String	Internal ID or alias of the child code list.
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.

POST response

POST example

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

--6o2knFse3p53ty9dmcQvWAIx1zInP11uCfbm
Content-Disposition: form-data; name=file; filename=import.csv
Content-Type: text/plain

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

{
   "delimiter":"COMMA",
   "textQualifier":"DOUBLE_QUOTE",
   "startingRow":0,
   "codepage":"UTF8",
   "hierarchyId":"eeb38899dd463330df844b8e",
   "childCodeListId":"3ebff6c89e03c41d5dd08acc",
   "parentCodeListId":"68c3ba1b4c3402a7cc18169a",
   "mappings":{
      "state":"Code",
      "country":"ParentCode"
   }
}--6o2knFse3p53ty9dmcQvWAIx1zInP11uCfbm--

Code,ParentCode
C1,P1
C2,P2
C3,P3

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

--6o2knFse3p53ty9dmcQvWAIx1zInP11uCfbm
Content-Disposition: form-data; name=file; filename=import.csv
Content-Type: text/plain

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

{
   "delimiter":"COMMA",
   "textQualifier":"DOUBLE_QUOTE",
   "startingRow":0,
   "codepage":"UTF8",
   "hierarchyId":"eeb38899dd463330df844b8e",
   "childCodeListId":"3ebff6c89e03c41d5dd08acc",
   "parentCodeListId":"68c3ba1b4c3402a7cc18169a",
   "mappings":{
      "state":"Code",
      "country":"ParentCode"
   }
}--6o2knFse3p53ty9dmcQvWAIx1zInP11uCfbm--

Code
P1
P2
P3

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