Hi all, I have a question regarding `Primary key` ...
# replication-troubleshooting
s
Hi all, I have a question regarding
Primary 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
Copy code
{
   "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?
a
you can't define primary key for child table duplicate row issue is already reported, please check this issue
s
Gotcha. Thanks
n
Thanks for your help, Akilesh!