Hi, hope that someone can help. Been bashing my head against the wall on this for a while. I had this functionality working but it seems to be failing in a different scenario.
I am getting data from Wrike and it’s coming in with the data collections nested under customFields which are not named but identified by ID.
Looks like this:
I need to filter when the ID ‘IEAFIXHMJUAIMLMR’ has a value of ‘New_Workstream’
This is my previous configuration of the filter which I think worked previously:
Any help would be hugely appreciated.
Hi @Paul_Lawrence ,
Welcome to the Make community!
This is how it should look:
Explanation:
The map() function works to create an array of just the “value” fields from Wrike’s CustomFields collection, filtered to only include those where the “id” is “IEAFIXHMJUAIMLMR”. We know there will only be one value in this array, but the first() function tells Make this. And then the rest of the filter just compares that one result to the text “New_Workstream”.
Let us know how it goes. And if this solves your issue, please mark this is the Solution.
Kind regards, Terry.
1 Like
Thank you so much @Terry_Hopper, exactly what I needed. There are a number of New Workstreams so I won’t need the first but good to know about it!
