Reference 360

Back Next

Step 3. Import hierarchy relationships

You can import top-level code values and parent-child relationships into a hierarchy. For example, in a locations hierarchy, you might define the North America code value as a top-level code value. Then you define a relationship from the North America code value to the United States code value. You might also define a relationship from the North America code value to the Canada code value.

To import top-level code values into a hierarchy, use the Import hierarchy relationships REST API to specify the CSV file that contains the code values.

For more information about the Import hierarchy relationships REST API, see Step 3. Import hierarchy relationships.

For example, the following request imports top-level code values:

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--

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

Code
P1
P2
P3

For example, the Import hierarchy relationships REST API returns the following response:

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

To import relationships, use the Import hierarchy relationships REST API to specify the CSV file that contains the relationships.

For more information about the Import hierarchy relationships REST API, see Step 3. Import hierarchy relationships.

For example, the following request imports relationships:

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--

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

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

For example, the Import hierarchy relationships REST API returns the following response:

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

Rename Saved Search

Table of Contents

Reference 360

Reference 360

Step 3. Import hierarchy relationships

Step 3. Import hierarchy relationships