Need Expert Advice: How to configure filter for following scenario

How To
1

Hi Guys,

I have following scenario

Screenshot 2024-12-13 at 9.47.02 AM
Screenshot 2024-12-13 at 9.47.02 AM2008×230 45.1 KB

I first fetch certain data from a table in glide. → I make an HTTP request and get some text data. Which I am writing to another table in glide (Current scenario)

WHat I need help with

The API response should check wether the data is present in the glide table and only write those which are not present in glide.

PS There is no identifier to data coming in API response its plain text data.

Thank you in advance for your help.

Regards,
Dilip

2

Hey @Dilip,

What do you mean by ‘present’ in glide? Also, how would you recognize manually that the data is ‘present in glide’?

Thanks

3

Hi @DimitrisGoudis

Thank you for your reply.

My Glide Table will already have text stored from the previous API response. Every morning I query the API and get response from API. Unfortunately the api Just gives me dump of all texts. Which includes previously gotten one which I would have stored in my glide table under Text Column.

I dont want to write the Texts which are already present.

Let me know if you need more information.

Thank you.

Regards,
Dilip

4

Hey @Dilip,

If I understand the purpose correctly, you can check if the text field in glide is empty for the current record in your loop; if it is empty, then you can paste the value with text by updating it.

However, I see that your last action is not updated, but it is Add row; that’s why I am not sure if I got you correctly.

I am happy to schedule a 30-minute call with no commitment to solve that together. Here is my calendar link: Meet Dimitris | Dimitris Goudis | Cal.com

Thanks

1 Like
5

Hi @DimitrisGoudis,

I have configured the Scenario as per your guidance over the call.

The suggestion/idea to filter based on created date was really brilliant.

Here is how my updated scenario looks like.

Screenshot 2024-12-13 at 4.38.14 PM
Screenshot 2024-12-13 at 4.38.14 PM2780×1040 132 KB

Screenshot 2024-12-13 at 4.38.24 PM
Screenshot 2024-12-13 at 4.38.24 PM2834×1116 178 KB

Thank you soo much for your guidance and help @DimitrisGoudis

I will check it when it runs tomorrow or whenever new data comes to see wether it works and will get back to you.

Appreciate you helping

Regards,
Dilip

1 Like
6

Hey @Dilip,

Thanks for your feedback. Did you test the process today?
Please share any feedback, I am really curious to know that it works 100% correctly :slight_smile:

Thanks
Dimitris Goudis (3Nuggets)

7

Hi @DimitrisGoudis ,

Thank you for helping and checking in. My scheduled run will run again tomorrow. Post that I will update you. Hopefully everything goes smoothly.

Thank you again.

Regards,
Dilip