Putting this solution here for others who may encounter it in the future.
I want to know if a user has already invited a friend to join a group.
- User = inviter_id (input)
- Friend = contact_set_id (variable)
- Group = group_id (input)
When I tried to query my table invites to see if any records match
I got an error implying that contact_set_id (a variable with text in it) is an array and so it can’t be used in the query:
(In my test data, “111” is the correct value for it to search. It just shouldn’t be in brackets.)
It turns out that–because I was querying all records and using the response–I was now using an array. I had to add a step to pull the element out of the array which I did using Data Manipulation > Arrays > Remove from Beginning: