Hello,
I am trying to do the following
const inputSQL = input.sql({
commandText: 'SELECT * FROM schema.user u WHERE u.email = @email',
commandType: 'Text',
parameters: '@email={email}',
connectionStringSetting: 'SqlConnectionString',
})
where the request content type is
application/x-www-form-urlencoded
and body is
email=sample%40email.com&password=supersecretpassword
As a result I get the following error
[2024-12-12T16:55:30.691Z] Executed 'Functions.belogin' (Failed, Id=96c0e3e6-4aff-4f26-b43f-22abf9944aa0, Duration=13ms)
[2024-12-12T16:55:30.695Z] System.Private.CoreLib: Exception while executing function: Functions.belogin. Microsoft.Azure.WebJobs.Host: Error while accessing 'email': property doesn't exist.
Is there some secret sauce to parameter declaration that I haven't found, or do I have write additional code in frontend to send a JSON instead?
Thanks in advance.