curl -X GET "https://YOUR_BASE_URL/jobs/comparison/1042/diff-details" \
-H "Authorization: Bearer <api-key>" \
-H "Workspace-Id: <workspace-id>"
{
"data": {
"primary_key_columns": ["order_id"],
"column_mapping": {
"order_id": "order_id",
"customer_id": "customer_id",
"total": "total"
},
"mismatched_columns_mapping": {
"total": {
"mismatch_count": 3,
"details": "Numeric value differences"
}
},
"diff_rows": [
{
"order_id": 10045,
"source_total": 199.99,
"target_total": 200.00
},
{
"order_id": 10078,
"source_total": 49.95,
"target_total": 49.00
}
]
},
"meta": {}
}
Get the full row-level diff for a completed comparison job.
curl -X GET "https://YOUR_BASE_URL/jobs/comparison/1042/diff-details" \
-H "Authorization: Bearer <api-key>" \
-H "Workspace-Id: <workspace-id>"
{
"data": {
"primary_key_columns": ["order_id"],
"column_mapping": {
"order_id": "order_id",
"customer_id": "customer_id",
"total": "total"
},
"mismatched_columns_mapping": {
"total": {
"mismatch_count": 3,
"details": "Numeric value differences"
}
},
"diff_rows": [
{
"order_id": 10045,
"source_total": 199.99,
"target_total": 200.00
},
{
"order_id": 10078,
"source_total": 49.95,
"target_total": 49.00
}
]
},
"meta": {}
}
Bearer <api-key>Show data
curl -X GET "https://YOUR_BASE_URL/jobs/comparison/1042/diff-details" \
-H "Authorization: Bearer <api-key>" \
-H "Workspace-Id: <workspace-id>"
{
"data": {
"primary_key_columns": ["order_id"],
"column_mapping": {
"order_id": "order_id",
"customer_id": "customer_id",
"total": "total"
},
"mismatched_columns_mapping": {
"total": {
"mismatch_count": 3,
"details": "Numeric value differences"
}
},
"diff_rows": [
{
"order_id": 10045,
"source_total": 199.99,
"target_total": 200.00
},
{
"order_id": 10078,
"source_total": 49.95,
"target_total": 49.00
}
]
},
"meta": {}
}