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	911	August 2, 2023
Not In clause with two resources 💬 Queries and Resources query-json-with-sql	5	1172	August 3, 2023
Query JSON with SQL returns nothing 💬 App Building	16	1117	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	1502	August 30, 2023
Trying to query a JSON array with multiple values 💬 App Building pool-party	6	985	July 25, 2024

Using API array result in Query

Related topics