Table of Contents

Search

  1. Preface
  2. Introducing Reference 360
  3. Getting started with Reference 360
  4. Manage system reference data
  5. Manage reference data sets
  6. Manage code lists
  7. Manage code values
  8. Manage crosswalks
  9. Import data
  10. Manage hierarchies
  11. Manage attributes
  12. Manage workflows
  13. Manage jobs
  14. Reference 360 REST API
  15. Glossary

Reference 360

Reference 360

Export value mappings to JSON format

Export value mappings to JSON format

Exports the value mappings in a crosswalk to the JSON format.

POST request

To export value mappings in a crosswalk, submit a POST request with the following URI:
/rdm-service/external/v2/export
In the request header, you must specify the
Accept
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
The 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.

POST response

The response is in JSON format.

POST example

To export the value mappings in a crosswalk, you might use the following request:
POST https://use4-mdm.dm-us.informaticacloud.com/rdm-service/external/v2/export HTTP/1.1 Content-Type: application/json Accept: application/json IDS-SESSION-ID: XXXXXXXXXXXXXXXXXXXXXX { "dateFormat" : "ISO", "containerType" : "crosswalk", "containerId" : "1c03a6555058fdd134f7f417" }
The following sample response shows the exported data:
HTTP/1.1 200 OK Content-Type: application/json;charset=UTF-8 Content-Length: 234 { "content":[ { "fields":{ "toCode":"DEU", "fromCode":"DE" }, "sourcePKey":"DE_DEU" }, { "fields":{ "toCode":"AFG", "fromCode":"AF" }, "sourcePKey":"AF_AFG" } ] }

Back to Top

0 COMMENTS

We’d like to hear from you!