Using Query JSON with SQL to grab Google Sheet Data

[Danielle_Reycer]

Hi there! I'm trying to call upon a google sheets query but the data isn't showing up appropriately. My goal will be to edit this query to join it with data I have in another query, but I can't get it to work without figuring out this step! (At least I couldn't get it to work and thought I'd need to come back to this step first. I've tried formatDataAsArray but it returned no rows (second screenshot).

Here's the google query:

I'd like to eventually do something like this:

Any help is greatly appreciated!

[stefancvrkotic]

Hey Danielle!

In your case you would need something like this:

SELECT *
FROM {{bundle_expander_by_sku.data}}
WHERE component_sku=ANY({{ops_query.data.sku}})

Does this work?

[Danielle_Reycer]

It just says "No rows to display."

I can see, however, that there should be matches:

From oos_query:

From bundle_expander_by_sku:

I keep coming back to the way the data displays in the query without the "where" clause and maybe if I fix that I'd be able to move forward?

Thank you so much for the reply and any other help!

[stefancvrkotic]

Perhaps it's due to it being case sensitive so if your query outputs COMPONENT_SKU it should be the same within the Query JSON with SQL.

SELECT *
FROM {{bundle_expander_by_sku.data}}
WHERE COMPONENT_SKU=ANY({{ops_query.data.sku}})

Does that change anything?

[Danielle_Reycer]

Something close to your suggestion ended up working with an adjustment so it only shows those bundles affected when the sku is selected in the table! Thanks again for the help!

FROM {{bundle_expander_by_sku.data}}
WHERE COMPONENT_SKU={{OOSProductsTable.selectedRow.data.sku}}