How to map a google sheet resource to a database query

Queries and Resources
,
1

Hi there, I'm trying to map a column (Addresses_invited) from a google sheet in the query of a database resource that I have. I have tried mapping different ways including:

{{getDestinationAddress.data.map(row=>row.Addresses_Invited)}}

Any tips?

image
image2000×412 68.1 KB

2

Hi @mmondragon! What is your aim here?

Base on your SQL query, you are using equality and it only accepts individual/exact value and what you are returning from that curly bracket is an array of addresses. You might want to use IN instead of equality there.

But then again, I am not sure your aim here and just surmising from your screenshot

3

Hi Jocen, thanks for replying

I am wanting to take the "Addresses_Invited" field from the google sheet resource (getDestinationAddress) and find all of those addresses in the getWalletID resource. I will try using "IN" and "ANY"