Crosswalk
Map every source row to its golden record as JSON or CSV, single-source records included, ordered by golden name, source and source id, via /v1/master-records.
The crosswalk lists every source row with the golden record it belongs to. Unlike the overview, it includes the records that have only one member, so it is the complete mapping from a source system's id to the golden key and name. Rows are ordered by golden name, source and source id. Use it to translate ids from one ERP into the shared golden key, or to load the mapping into another system.
GET
/v1/master-records/{domain}/crosswalkResponse fields
domainstringvendors, customers or materials.
rows[].golden_key / golden_namestringThe golden record.
rows[].source / source_idstringThe source label and the row's id in that system.
rows[].statusstringauto, review, accepted or split.
cURL: The vendor crosswalk
curl "https://api.talonic.com/v1/master-records/vendors/crosswalk" \
-H "Authorization: Bearer $TALONIC_API_KEY"Response: Crosswalk (abridged)
{
"domain": "vendors",
"rows": [
{ "golden_key": "3a7f9d1c5e2b8046a1d3c7f09b4e6a28d5c1f390", "golden_name": "Acme Industrial GmbH", "source": "ERP-A", "source_id": "100234", "status": "review" },
{ "golden_key": "3a7f9d1c5e2b8046a1d3c7f09b4e6a28d5c1f390", "golden_name": "Acme Industrial GmbH", "source": "ERP-B", "source_id": "V-8812", "status": "review" }
]
}GET
/v1/master-records/{domain}/crosswalk.csvcURL: Download the crosswalk as CSV
curl -o vendors-crosswalk.csv "https://api.talonic.com/v1/master-records/vendors/crosswalk.csv" \
-H "Authorization: Bearer $TALONIC_API_KEY"The crosswalk reflects the latest run of the domain. After a run or a decision, a golden key can change if the membership of a record changed, so key a long-lived downstream table on the pair of
source and source_id and refresh the golden key from the crosswalk.Frequently asked questions
How is the crosswalk different from the overview?+
The overview lists only records with two or more members, paged and ordered for review. The crosswalk lists every source row, single-source records included, with no paging, ordered by golden name, source and source id.
What are the CSV columns?+
golden_key, golden_name, source, source_id and status, one line per source row. The CSV and the JSON carry the same rows.
Can golden keys change between runs?+
Yes. The key is a hash of the sorted member keys, so a change in the membership gives a new key. Source ids do not change; use them as the stable side of the mapping.