Accessing data from a webhook request and pass along as the Retool Database resource

[Aldo_Lambruschini]

I ended up figuring this out. The Retool Database when querying and using {{}} notation should pass an array of strings inside the curly brackets. I updated my ids.strip block to return ['A','B','C'] and appended it to my Retool database query like:

SELECT * FROM table WHERE identifier = ANY ({{ids_strip.data}})

That did the trick for me.

Changing to ANY() was recommended here:

SQL Cheatsheet