Reference 360

Back Next

Export value mappings at a point in time to JSON format

Exports the value mappings in a crosswalk at a point in time to the JSON 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/json

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

Field	Type	Description
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 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.

POST response

The response is in the JSON 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/json
IDS-SESSION-ID: XXXXXXXXXXXXXXXXXXXXXX
Content-Length: 220

{
   "dateFormat":"ISO",
   "containerType":"crosswalk",
   "containerId":"c27e43cad990f4e57361ae60",
   "pageSize":10000,
   "page":0,
   "pit":"2021-05-21",
   "repeatHeaders":false
}

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

HTTP/1.1 200 OK
Content-Type: application/json;charset=UTF-8
Content-Length: 366

{
   "pageSize":2,
   "page":0,
   "totalNumberOfElements":2,
   "numberOfElements":2,
   "lastPage":true,
   "firstPage":true,
   "content":[
      {
         "fields":{
            "toCode":"DEU",
            "fromCode":"DE"
         },
         "sourcePKey":"DE_DEU"
      },
      {
         "fields":{
            "toCode":"AFG",
            "fromCode":"AF"
         },
         "sourcePKey":"AF_AFG"
      }
   ]
}

Rename Saved Search

Table of Contents

Reference 360

Reference 360

Export value mappings at a point in time to JSON format

Export value mappings at a point in time to JSON format

POST request

POST response

POST example