Sabbiu Shah
02/06/2023, 12:50 AMPrimary key definition
I receive a nested json response from one of the square api (Orders )
And the data we receive from orders are as such
{
"uid": "abc-123" // this is setup as primary key in our source",
"line_items": [
{
"uid": "cde-234", // can we set nested value as primary key as well?
// other fields
}
],
// other data
}
And during incremental sync if we receive any changes in orders it updates the previous orders correctly, but it creates new line_items with the same id.
Can we also define primary_keys for these nested fields (somewhere)? If not, how should we approach this?Akilesh V
02/06/2023, 10:39 AMSabbiu Shah
02/06/2023, 12:57 PMNataly Merezhuk (Airbyte)
02/06/2023, 1:09 PM