Nested binding properties not supported?

[piquet-h]

Trying to bind a cosmosDb query to an input based on a json payload from event grid
{
"data" : { "username" : "fred" }
…. rest of event grid stuff
}

Can only bind to the outer properties. This is different to the description earlier in the document that talks about using dot notation to bind to nested properties.

Needs to be clarified, or alternatively, have the bug fixed.

---

Document Details

⚠ Do not edit this section. It is required for docs.microsoft.com ➟ GitHub issue linking.

• ID: fa5bcb79-2af8-3b0e-c78c-0c89a2535e15
• Version Independent ID: 31b87687-7841-f46f-8c97-38898e7b97db
• Content: Azure Cosmos DB bindings for Functions 2.x
• Content Source: articles/azure-functions/functions-bindings-cosmosdb-v2.md
• Service: azure-functions
• GitHub Login: @craigshoemaker
• Microsoft Alias: cshoe

[piquet-h]

Hmm - seems to be the case.
Azure/azure-webjobs-sdk#1726

[msrini-MSFT]

@piquet-h , Thank you for your feedback. We will investigate and get back to you shortly.

[PramodValavala-MSFT]

@piquet-h Thanks for the feedback! I believe the underlying issue should be resolves as part of the issue that you've mentioned. In the meantime, I guess a note in the doc should help customers hitting the same issue.

If you are using C#, I believe you could use runtime binding to overcome this. This also supported for CSX functions.

We are assigning this issue to the content author for further review.

[wisesimpson]

@piquet-h Thanks for the feedback! I believe the underlying issue should be resolves as part of the issue that you've mentioned. In the meantime, I guess a note in the doc should help customers hitting the same issue.

If you are using C#, I believe you could use runtime binding to overcome this. This also supported for CSX functions.

We are assigning this issue to the content author for further review.

Instead of C#, is there a solution for javascript? Thanks

[PramodValavala-MSFT]

@wisesimpson Because of the way non-C# languages work in Azure Functions, runtime binding is not possible.

Alternatives would be

• Directly use the native SDKs as required
• Send the required data in a queue message (using the output binding) and let this message trigger another function where you can directly use the data as needed

[wisesimpson]

@PramodValavala-MSFT
If I want to build a simple page, triggered by http request and response with some data from cosmos db. Is it still possible to using the second alternative (using queue message)? I don't know if it's possible to carry the http response to the following function?

[PramodValavala-MSFT]

@wisesimpson You'd want to serve the page statically and have JavaScript make the call to fetch the data as required. You can use patterns like Async HTTP APIs to achieve something like that.

[wisesimpson]

@PramodValavala-MSFT Thanks for your reply. I follow your link and started to create durable functions. Another issue popped up but please forgive me if it's not specific to this topic. Here's the issue:
In the Orchestrator, I called context.df.callActivity("Action1", {"keywords":"test","top":2})
In the "Action1"'s function.json, I added a cosmosDB binding with sqlQuery as SELECT TOP {top} * FROM e WHERE CONTAINS(e.content,{keywords}).
I got error messages "The count value provided for a TOP clause must be an integer.".
I've searched and tried using udf like SELECT TOP udf.toInteger({top}) *...
or built-in function like SELECT TOP StringToNumber({top}) *...
None of them works. Can you help me out? Thanks

ps: The other argument keywords is well received and usable to sqlQuery.

[PramodValavala-MSFT]

@wisesimpson I believe it would be best to create a thread on MSDN or StackOverflow with your last query, so that the discussion is visible to a larger audience.

[cachai2]

#please-close please refer to linked feature request issue Azure/azure-webjobs-sdk#1726