Need Help: Dynamically finding duplicates from my API call in Glide table and not send it to glide

How To
1

Hi Guys,

I have a requirement, Where I am using a scenario where I query an API and get response every day morning at 10 o clock.

I get one important data which is text message Every day when the API is queried I get this result and It should write to glide table. Write now even existing Text Messages are getting written again.

How can I create a scenario where It check my glide table for text message and then only writes the entries into my glide table that are not exisisting?

PS Every day it queries API and sends out List of text message

Here is how my scenario is currently.

Screenshot 2024-12-11 at 10.08.42 AM
Screenshot 2024-12-11 at 10.08.42 AM3022×500 125 KB

Thank you guys in advance for your help.

Regards,
Dilip

2

Hi Guys,

The other alternative I have is write all values to glide, Which will just increase my rows. Is there any way I can avoid this?

Regards,
Dilip

3

Hi Guys,

I have made one modification where I first find all rows in my glide, And then check Api response for same text.

Iterating through each elements in both and comparing them does not work as they might have different values when comparing. How can we skim through entire data and decide this?

What operator can I use for doing this checking scenario?

Here is a screenshot of my scenario

Uploading: Screenshot 2024-12-11 at 3.03.57 PM.png…

but its still not working as expected. Its still sending me duplicate entries

Regards,
Dilip

4

Hi Guys,

Couldn’t figure out how to do it in Make, Figured out a way to make it work in glide.

Regards,
Dilip

1 Like