Query JSON with SQL on API data returns no results

[stefancvrkotic]

Hey dhretool,

Instead of {{ formatDataAsObject([table_mozenda_data.data]['0'])['Product Code'] }} you can use key of the column you are searching by.
Example code:

SELECT *
FROM {{table1.data}}
WHERE product_code={{numberInput1.value}}

Hope this example helps!