I'm trying to use the results of an API call, which returns an array of emails, in a PostGres query. I'm trying the following but this is returning no results. SELECT * FROM users as U LEFT JOIN user_communication_preferences as UCP on U.id = UCP.user_id where email in ({{GET_unsubscribe_new…

Got it OK so {{GET_unsubscribe_newsletter.data}} is what you want to use against your own db. Your query then should go against YOUR db Resource (Dev Database) and that is what is NOT working when using IN. So try using ANY like so: SELECT * FROM users as U LEFT JOIN user_communication_prefe…

Using API array result in Query

💬 Queries and Resources

ScottR October 18, 2022, 11:55am 2

Check out this post

Topic		Replies	Views
Azure SQL IN list returns empty results 💬 Queries and Resources sql	12	1004	August 2, 2023
Not In clause with two resources 💬 Queries and Resources query-json-with-sql	5	1219	August 3, 2023
Query JSON with SQL returns nothing 💬 App Building	16	1283	February 28, 2024
SELECT statement expands {{Multiselect.value}} to a string as opposed to an array of integers 💬 Queries and Resources javascript , sql , component	4	1533	August 30, 2023
Trying to query a JSON array with multiple values 💬 App Building pool-party	6	1150	July 25, 2024

Using API array result in Query

Related topics