POST request

/rdm-service/external/v1/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 ASTERISK , CIRCUMFLEX , COLON , COMMA , PIPE , SECTION , 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 export file. Value must be UTF8 .
hierarchyId	String	ID of the hierarchy to which you want to import relationships. You can find the ID of assets in Reference 360 or use REST APIs to retrieve the IDs. For more information, see Asset IDs.
parentCodeListId	String	ID of the parent code list. If you import top-level code values, you do not need to provide this attribute.
childCodeListId	String	ID of the child code list.
startingRow	String	Line number from which to start importing data. By default, all rows are imported.

POST response

POST example

POST https://use4-mdm.dm-us.informaticacloud.com/rdm-service/external/v1/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":"c79ab91c19b13b11d8d43770",
  "childCodeListId":"96f06071e4aaea81ff203abe",
  "parentCodeListId":"9b300f793470882ca23e6091"
}
--6o2knFse3p53ty9dmcQvWAIx1zInP11uCfbm--

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

POST https://use4-mdm.dm-us.informaticacloud.com/rdm-service/external/v1/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":"c79ab91c19b13b11d8d43770",
  "childCodeListId":"96f06071e4aaea81ff203abe"
}
--6o2knFse3p53ty9dmcQvWAIx1zInP11uCfbm--

Code
P1
P2
P3

{
  "jobId":"73580d323feb170be5ec0fd5",
  "state":"INPROGRESS",
  "startTime":1603092643055,
  "numOfRecordsProcessed":100,
  "numOfRecordsFailed":25,
  "numOfRecordsSucceeded":75
}