Need Help in removing duplicates after entries are coming from Make

[Dilip_Adiga]

Hi @Robert_Petitto ,

Thank you for your reply. Unfortunately currently the API response is not giving me any identifier.

I used combination of this solution from @Jeff_Hager

Is there a way to filter duplicates from an inline list?

This is what I would do if you wanted to keep everything within glide. First I would recommend having a RowID which will give every row a unique value. This will become important in a little bit. Then I would identify a unique value for each contact, whether it’s a name, phone number, email address, or something else that you know will be in each duplicate row, but is still unique only for that specific person. Let’s assume Name for now. Create a self relation that links the contact’s Name …

and by configuring workflow

PS

Since I had Beta access to scheduled workflow I could test it

I think the bigger issue in this would be when the table size increases and duplicates increate, each delete costs me an update, which becomes an issue.

Regards,
Dilip