Can't bind comsosdb input with Http trigger

Question

Can't bind comsosdb input with Http trigger

piyush trivedi 121

I have created HTTP trigger in javascript and trying to bind with cosmos db as describe here but I keep getting below error, can someone take a look into it, thanks.

https://learn.microsoft.com/en-us/learn/modules/chain-azure-functions-data-using-bindings/5-read-data-with-input-bindings-portal-lab?pivots=javascript

Can't bind CosmosDB to type 'System.String'. Possible causes: 1) Tried binding to 'Microsoft.Azure.Documents.Client.DocumentClient, Microsoft.Azure.DocumentDB.Core, Version=2.9.2.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35' but user type assembly was 'System.String, System.Private.CoreLib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e.

0 comments

Answer accepted by question author

piyush trivedi 121

looks like some reference is missing but I found an alternative solution,

1: just go to classic way and retry configuration & save it, if this doesn't work then

2: go to cosmos DB, from there select function and then create a new function with the type of language, in my case I selected javascript and create the function, from there it will prompt you to a classic way of displaying function.
a) now verify the connection of your actual function which was not working even though everything looks okay to try to save again and then try, it will work!

Samara Soucy - MSFT 5,141 Reputation points

2020-06-12T17:06:54.397+00:00

It looks like the issue is the auto-generated input binding includes the "id" and "sqlQuery" parameters even if you don't specify any values for them. Removing the empty parameters manually allowed the function to run as expected.

I've reported the issue to the PG so they can address the problem.
piyush trivedi 121 Reputation points

2020-06-12T19:14:28.277+00:00

looks like its not the issue with Id or sqlQuery parameter because I tried removing them first to see if that is fixing the problem but it didnt however it works well if I change to classic view and still have those parameters.
Samara Soucy - MSFT 5,141 Reputation points

2020-06-16T15:16:37.133+00:00

Interesting. I'm only able to replicate the issue with the id and sqlquery parameters.

The product team has posted a fix to their canary environment if you would like to test it: aka.ms/canary

I'd appreciate it if that doesn't work if you could share the function.json from the working/non working functions to see if we can figure out what further issues you are seeing.

1 additional answer

Your answer

Samara Soucy - MSFT 5,141 Reputation points

2020-06-12T17:06:54.397+00:00

It looks like the issue is the auto-generated input binding includes the "id" and "sqlQuery" parameters even if you don't specify any values for them. Removing the empty parameters manually allowed the function to run as expected.

I've reported the issue to the PG so they can address the problem.
piyush trivedi 121 Reputation points

2020-06-12T19:14:28.277+00:00

looks like its not the issue with Id or sqlQuery parameter because I tried removing them first to see if that is fixing the problem but it didnt however it works well if I change to classic view and still have those parameters.
Samara Soucy - MSFT 5,141 Reputation points

2020-06-16T15:16:37.133+00:00

Interesting. I'm only able to replicate the issue with the id and sqlquery parameters.

The product team has posted a fix to their canary environment if you would like to test it: aka.ms/canary

I'd appreciate it if that doesn't work if you could share the function.json from the working/non working functions to see if we can figure out what further issues you are seeing.

Answer 1

Ivan P 21

The issue for me was in function.json, containing
"sqlQuery": ""

Removing the line in the file and saving it did not work. I had to go into the input edit UI, enter some text into the SQL Query field, Save it. Then, go into the function.json file remove the sqlQuery line, and safe the file.

OSPIKA Consulting 11 Reputation points

2020-07-04T08:22:32.743+00:00

This has worked for me. Thanks.
Алексей Иванов 1 Reputation point

2021-06-25T09:01:49.663+00:00

I also succeeded in following the same way. Working version.

Share via

Can't bind comsosdb input with Http trigger

1 additional answer

Your answer