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

Get job details of a crosswalk cleanser job

Get job details of a crosswalk cleanser job

Retrieves job details of a crosswalk cleanser job.

GET request

To get the job details of a crosswalk cleanser job, submit a GET request with the following URI:
/rdm-service/external/v1/crosswalks/{crosswalkIdentifier}/mappings/duplicates/status

GET response

The response contains the details of the crosswalk cleanser job, such as the status of the crosswalk cleanser job, number of records processed for import, and the error details.
The following table describes the attributes in the response:
Field
Type
Description
crosswalkId
String
Identifier of the crosswalk for which the crosswalk cleanser job was triggered.
createdBy
String
User name of the user who triggered the crosswalk cleanser job.
createdDate
String
Date when the crosswalk cleanser job was triggered.
status
String
Status of the crosswalk cleanser job.
jobDetails
Object
Details of the crosswalk cleanser job.
initialNumberOfMappings
Number
Number of existing crosswalk mappings.
invalidSourcePKeyReport
Object
Details of invalid mappings.
numberOfRecords
Number
Number of invalid records.
numberOfSuccessRecords
Number
Number of invalid records that were successfully deleted.
numberOfFailedRecords
Number
Number of invalid records that were not deleted.
errors
Array
Details of the errors.
errorCode
String
Error code for the error type.
errorSummary
String
Message that explains why the invalid records are not deleted.
errorParameter
Object
Error parameter.

GET example

To get the job details of a crosswalk cleanser job, you might use the following request:
GET https://use4-mdm.dm-us.informaticacloud.com/rdm-service/external/v1/crosswalks/12102ba6924d0279d40bf5b1/mappings/duplicates/status HTTP/1.1 Accept: application/json
The following sample response shows the job details of a crosswalk cleanser job:
HTTP/1.1 200 OK Content-Type: application/json;charset=UTF-8 Content-Length: 555 { "crosswalkId":"12102ba6924d0279d40bf5b1", "createdBy":"12bb7c6b10e23be958e8b270", "createdDate":"2021-12-10T11:29:34.174+00:00", "status":"RUNNING", "jobDetails":{ "initialNumberOfMappings":10, "invalidSourcePKeyReport":{ "numberOfRecords":5, "numberOfSuccessRecords":4, "numberOfFailedRecords":1 } }, "errors":[ { "errorCode":"RDM.0010000", "errorSummary":"Unable to fix the sourcePkey", "errorParameter":{ "sourcePkey":"619cd13b57eb9948fa585d65" } } ] }

Known limitation

If the crosswalk cleanser job fails to remove duplicate mappings of a crosswalk, the API response returns the
RDM.0010269
error code.
To avoid duplicate mappings in the crosswalk when the crosswalk cleanser job fails, perform the following actions:
  1. In
    Reference 360
    , open the specific crosswalk.
  2. Click
    Export mappings
    to export the value mappings of the crosswalk.
  3. Delete the crosswalk.
  4. Create another crosswalk between the same source and target code lists.
  5. Open the crosswalk and click
    Import Mappings
    to import the exported CSV file to the crosswalk.

0 COMMENTS

We’d like to hear from you!