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!
Handling JSON array inputs
Answered
3 replies