Handling JSON array inputs

Answered

I have a list of id's being passed from my front end, and when I copy the inputs this is the format they are arriving in:
{'idList':'[4,5,6]','lessonID':'6','idListRef':'[1,2,3]'}
The result is empty, which is not right.

If I copy and past how it is received into the run and debug and remove the '' around the [], like this:
{'idList':[4,5,6],'lessonID':'6','idListRef':[1,2,3]} the response the debugger gives is what is expected.

To get the response I am performing a Query All Records from the table where:
auth.id = db.user_id
and where db.field_id in idListRef

I don't believe the issue is in the query because it works if I remove the '', but I can not figure out why this is or how to resolve this issue. I have tried passing the data several different ways but can not figure it out. Any help in the right direction would be greatly appreciated!

3 replies