Unsure how to get the right filter conditions

Hi there,

New to Make and the forum, so go easy on me!

I’m setting up a scenario with two HTTP GET requests and a router with two branches, however I can’t get the branch filters right. Essentially I want to compare a list from request 1 with items from request 2: if List X contains item Y, update. If not, create.

Whichever route I take I end up with an error somewhere down the line. Here’s my scenario:

From the first request, I’m using an ItemID and a programID. From the second I need the program IDs to compare with the ones from the first request, to decide whether to update or create. In case of update, I need to target the right item with ItemID.

I can create an array from ProgramID but it prevents me from using the ItemID later on. I tried several other things but none worked. I’m assuming my lack of knowledge is the reason I’m stuck and not a lack of options.

Anyone up for some advice? Or do I need to be more specific?

Thanks!

Hello @KND, can you share the inputs of the filters

Thanks for checking in! I think I found a solution:

It filters through a string and checks if it contains/not contains the first programId. Seems to do the trick!

1 Like

Hi @KND
Try setting first iterator as the source module in the Text aggregator module.

Best regards,
Msquare Automation
Platinum Partner of Make
@Msquare_Automation

1 Like

Hi @KND
See the setup below to know how to set the source module

Best regards,
Msquare Automation
Platinum Partner of Make
@Msquare_Automation

2 Likes

Hi @Msquare_Automation, thanks for the reply! I think I already set it up the way you proposed:

1 Like

The source module you set is the second iterator , see the module . it should be 34 in your case instead of 36th module.

Best regards,
Msquare Automation
Platinum Partner of Make
@Msquare_Automation

2 Likes

And place the text aggregator behind 34 as well? If I just change the source module I lose access to data I need to filter

1 Like

If you could share the blueprint we could further assist you

Best regards,
Msquare Automation
Platinum Partner of Make
@Msquare_Automation

2 Likes