I'm querying a database from an API-Endpoint trigger and want to return the result as JSON.So far nothing out of the ordinary, and it works for other usecases.The data i do get back from the database though already contains a JSON string in one colum...
Tanks, that works great!I had to modify just a tiny bit:return {rows: parsed}; as otherwise it would just return an array (although in the job history UI of course it looks like an Object with an "Output: " array property) and I'm not sure how to map...
Thanks for the reply!I tried List/Object as String doesn't work either.I (just like mlamotte) am not trying to pass a single value (equipment_id, article_number, ..) - but the whole rows-result-set. I don't think i can define that its a single "strin...
Our question is why it's not possible to pass the "entire query result" / the rows of an SQL query into a python/ruby action.neither for list nor object inputs the "rows" pill is selectable.
I have the very same question. Passing an entire query result as input to Python/Ruby doesn't seem possible out of the box?@gary1- any idea how that could be solved?
