Reference 360

Back Next

Export value mappings at a point in time to CSV format

Exports the value mappings in a crosswalk at a point in time to the CSV format.

POST request

To export value mappings in a crosswalk, submit a POST request with the following URI:

/rdm-service/external/v3/export

In the request header, you must specify the

attribute to

application/octet-stream

Use the following parameters in the request body to specify the crosswalk to export:

Field	Type	Description
delimiter	String	Optional. Delimiter used to separate values. Value must be ASTERISK , CIRCUMFLEX , COLON , COMMA , PIPE , SECTION , SEMICOLON , SPACE or TAB . Default is COMMA .
codepage	String	Optional. Code page used for the export file. Value must be UTF8 or MS_WINDOWS . Default is UTF8 .
decimalSeparator	String	Optional. Decimal separator used for numbers. Value must be COMMA or DOT . Default is DOT .
thousandSeparator	String	Optional. Grouping separator used for numbers. Value must be COMMA , DOT , SPACE , SINGLEQUOTE or NONE . Default is NONE .
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_HYPHEN . For mm-dd-yyyy format. US_SLASH . For mm/dd/yyyy format.
filename	String	File name for the exported file. Value must end with the .csv file extension.
containerType	String	Type of asset that contains code values. Value must be crosswalk .
containerId	String	ID of the crosswalk. You can find the ID of assets in Reference 360 or use REST APIs to retrieve the IDs. For more information, see Asset IDs.
pageSize	Number	Optional. Number of records to display on each page. The maximum value is 10000 . Default is 10000 .
page	Number	Optional. Page number to display. Default is 0 .
pit	String	Date to retrieve the point in time information about the crosswalk. Use the ISO format: yyyy-mm-dd.
repeatHeaders	Boolean	Indicates whether to populate headers in the CSV response.

POST response

The response is in the CSV format.

POST example

To export the value mappings in a crosswalk at a point in time, you might use the following request:

POST https://use4-mdm.dm-us.informaticacloud.com/rdm-service/external/v3/export HTTP/1.1
Content-Type: application/json
Accept: application/octet-stream
IDS-SESSION-ID: XXXXXXXXXXXXXXXXXXXXXX
Content-Length: 338

{
  "delimiter" : "SEMICOLON",
  "codepage" : "UTF8",
  "decimalSeparator" : "COMMA",
  "thousandSeparator" : "DOT",
  "dateFormat" : "ISO",
  "filename" : "testdata.csv",
  "containerType" : "crosswalk",
  "containerId" : "2029dbbcd5596d905d15fa83",
  "pageSize" : 10000,
  "page" : 0,
  "pit" : "2021-06-11",
  "repeatHeaders" : false
}

The following sample response shows the exported data in the CSV format:

HTTP/1.1 200 OK
Content-Disposition: attachment;filename=testdata.csv
Content-Type: application/octet-stream
RDM-PAGE: 0
RDM-TOTAL-NUMBER-OF-ELEMENTS: 10
RDM-NUMBER-OF-ELEMENTS: 10
RDM-PAGE-SIZE: 10000
RDM-FIRST-PAGE: true
RDM-LAST-PAGE: true
Content-Length: 578

sourcePKey,_from.id.sourcePKey,_to.id.sourcePKey
sourcePKey,_from.id.sourcePKey,_to.id.sourcePKey
sourceCode0_targetCode0,sourceCode0,targetCode0
sourceCode1_targetCode1,sourceCode1,targetCode1
sourceCode2_targetCode2,sourceCode2,targetCode2
sourceCode3_targetCode3,sourceCode3,targetCode3
sourceCode4_targetCode4,sourceCode4,targetCode4
sourceCode5_targetCode5,sourceCode5,targetCode5
sourceCode6_targetCode6,sourceCode6,targetCode6
sourceCode7_targetCode7,sourceCode7,targetCode7
sourceCode8_targetCode8,sourceCode8,targetCode8
sourceCode9_targetCode9,sourceCode9,targetCode9

export version 3

Download Guide

Watch

Comments

Reference 360 Homepage

Communities

Knowledge Base

Success Portal