Azure Function POST Request Parameter returns incorrect syntax with IN SQL query

Andreas Ellerbrock 6 Reputation points
2022-08-02T19:10:59.63+00:00

I'm currently executing an HTTP POST request to communicate with an Azure Function.

Given a table of test results, the query should return the results of all the users with a given email address. It's currently an array of emails.

227385-image.png

This is my query in the Azure Functions portal

227333-image.png

227348-image.png

What am I doing wrong? How can I format the HTTP params properly?

Thanks

Azure Functions
Azure Functions
An Azure service that provides an event-driven serverless compute platform.
{count} vote

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.