Currently, there is not a way to achieve the count query that has a prerequisite step of grouping crosswalks from the same source. If your tenant is connected to an Analytics Connector (BigQuery, Snowflake, etc.), you can try building the query in this layer.
If you would like to have this enhancement considered, please submit an Aha enhancement request.
Original Message:
Sent: 08-04-2025 15:27
From: Mohammed Ahmed
Subject: Data Reconciliation
Thanks Bryant, this export is a good option, just wondering if we can have a custom filtering options in the API call ? Say I want all profiles/entities where there is repeating crosswalks.src_type (example: SFDC, CRM etc) like group by entity ID having count(crosswalks.src_type)> 1 (ofcourse after applying slicefilter = equals(sourcesystem, 'SFDC') option in the request body). This will help to identify any source level duplicate records which got merged under a single entity along with their original crosswalks. Any insights are greatly appreciated.
------------------------------
Mohammed Ahmed
Publicis Sapient
NJ
Original Message:
Sent: 07-31-2025 14:29
From: Bryant Barrenechea
Subject: Data Reconciliation
Thanks for the clarification. In that case, your best option is to use the Export service with the slicedByCrosswalks option
https://docs.reltio.com/en/developer-resources/load-and-export-apis/load-and-export-apis-at-a-glance/export-service-apis/export-api-csv-output-format/generate-pivoted-view-of-crosswalks
------------------------------
Bryant Barrenechea
Solution Architect | Professional Services
Original Message:
Sent: 07-31-2025 14:12
From: Mohammed Ahmed
Subject: Data Reconciliation
Hi Bryant - This is for single entity, I want this view for all entities in the Tenant after the last run date , basically we are looking for a bulk report to generate and distribute crosswalk data back to original source systems.
------------------------------
Mohammed Ahmed
Publicis Sapient
NJ
Original Message:
Sent: 07-31-2025 13:47
From: Bryant Barrenechea
Subject: Data Reconciliation
You can use GET _slice API call to get the crosswalk view
'https://{{tenantURL}}/entities/{{entity_ID}}/_slice?crosswalkValue={{crosswalkValue}}&options=cleanEntity'
--header 'Content-Type: application/json' \
--header 'source-system: configuration/sources/{{sourceName}}' \
--header 'Authorization: Bearer {{accessToken}}'
------------------------------
Bryant Barrenechea
Solution Architect | Professional Services
Original Message:
Sent: 07-31-2025 11:29
From: Mohammed Ahmed
Subject: Data Reconciliation
Was there any resolution to this please ? I am looking for similar report/API to extract crosswalk data contributed by respective sources for reconciliation/validation purposes. Any insights is greatly appreciated.
------------------------------
Mohammed Ahmed
Publicis Sapient
NJ
Original Message:
Sent: 01-25-2022 10:36
From: Gino Fortunato
Subject: Data Reconciliation
it looks like if you want that, it will be a process to loop through the URI's to get the values....
------------------------------
Gino Fortunato
Senior Solution Engineer
Reltio
Original Message:
Sent: 01-25-2022 02:09
From: Ashish Rawat
Subject: Data Reconciliation
Hi Gino,
Thanks for your response I was interested in split API which could provide actual data contributed crosswalk vise instead of just URIs.
------------------------------
Ashish Rawat
Fresh Gravity
Bangalore
Original Message:
Sent: 01-24-2022 11:10
From: Gino Fortunato
Subject: Data Reconciliation
Hi Ashish,
Check out the documentation below, is this the API you want?
https://docs.reltio.com/mergeapis/dataapicrosswalks.html#dataapicrosswalks__getobjcrosswalks
------------------------------
Gino Fortunato
Senior Solution Engineer
Reltio
Original Message:
Sent: 01-21-2022 08:41
From: Ashish Rawat
Subject: Data Reconciliation
Hi Steve,
In the event of merge data is contributed from different crosswalk and get API exports the same. I am interested in exporting crosswalk specific data for reconciliation.
------------------------------
Ashish Rawat
Fresh Gravity
Bangalore
Original Message:
Sent: 01-20-2022 09:16
From: Steve Singleton
Subject: Data Reconciliation
Ashish,
The Get Entity API pulls all of the crosswalk information for each entity extracted. You can also use Data Export from the console to extract the data.
------------------------------
Steve Singleton
Original Message:
Sent: 01-18-2022 10:24
From: Ashish Rawat
Subject: Data Reconciliation
Do we have a way or API to extract corsswalk specific data from Reltio ?
E.g., Crosswalk1 and Crosswalk2 are merged into single entity. Now how can a user extract attribute values contributed by only crosswalk1 or only by crosswalk2.
The hard way to do it is build a custom utility and separate data based on crosswalk uris which is a complex logic, wondering if there is API or easier way to achieve it.
------------------------------
Ashish Rawat
Fresh Gravity
Bangalore
------------------------------