I’m working at an applications and need to import data from the following reports GET_FBA_FULFILLMENT_CUSTOMER_RETURNS_DATA, GET_FBA_FULFILLMENT_REMOVAL_ORDER_DETAIL_DATA, 'GET_FBA_REIMBURSEMENTS_DATA

That’s already done, but my client wants the following: all the data should be imported (no missing rows), there are no duplicates and that I preserve the local keys/ids (he want to modify the report data locally)

There is already a third party application that requests reports on his account (and I have no control on that), so I sometimes have issues with my reports being cancelled. So making sure that I always request unique time intervals and also making sure that I don’t miss any period didn’t quite work for me.

My solution was to request the reports for the last 30 days, delete the data for those 30 days and reinsert it. It solves the problem with getting all the data and not having duplicates, but I can’t preserve my local keys.

Want I need is a way to only insert the missing data. So it would be greatly appreciated if anybody could tell me a column or a combination of columns that is unique for each of those reports. Or if there are any resources where I can read more about that.

I don’t think that there is any other information you can leverage to preserve your local keys. Unfortunately when you have a quantity > 1 you will have some ambiguity on which item received which unique local key