Azure Function App HTTP Trigger CosmosDB input query from the request's body

Question

I have created an Azure Function that gets triggered with an HTTP POST request.
The request has a body like the following:

{
    "start": '2018-07-25T08:47:16.094Z',
    "end": '2018-07-25T08:47:24.686Z'
}

index.js

module.exports = async function (context, req) {
    context.log('JavaScript HTTP trigger function processed a request.');

    var inputDocument = context.bindings.inputDocument;
    context.log("INPUT DOCUMENT: " + JSON.stringify(inputDocument));
    context.res = {
            status: 200,
            body: "OK",
        };
};

function.json

{
  "bindings": [
    {
      "authLevel": "function",
      "type": "httpTrigger",
      "direction": "in",
      "name": "req",
      "methods": [
        "post"
      ]
    },
    {
      "type": "http",
      "direction": "out",
      "name": "res"
    },
    {
      "type": "cosmosDB",
      "name": "inputDocument",
      "databaseName": "Messages",
      "collectionName": "Collection1",
      "sqlQuery": "SELECT * FROM Collection1 c WHERE c.message.timestamp>={start} AND c.message.timestamp<={end}",
      "connectionStringSetting": "cosmosdbaccount_DOCUMENTDB",
      "direction": "in"
    }
  ]
}

I would like to query a CosmosDB instance with these two parameters like this:

"sqlQuery": "SELECT * FROM Collection1 c WHERE c.message.timestamp>={start} AND c.message.timestamp<={end}",

Doing it like I show here results in the CosmosDB's inputBinding beeing undefined.

2018-12-13T08:19:54.332 [Information] Executing 'Functions.Function1' (Reason='This function was programmatically called via the host APIs.', Id=af8090a4-5fab-4fbd-b26f-a045d8900d9b)
2018-12-13T08:19:56.704 [Information] JavaScript HTTP trigger function processed a request.
2018-12-13T08:19:56.711 [Information] INPUT DOCUMENT: []
2018-12-13T08:19:56.755 [Information] Executed 'Functions.Function1' (Succeeded, Id=af8090a4-5fab-4fbd-b26f-a045d8900d9b)

If I run the same exact query replacing start and end with the correct ISO timestamps in the CosmosDB Data Explorer it returns all four documents.

Am I missing something? I really didn't find anything about this topic online so I hope someone has already stumbled upon it.

Thanks a lot in advance!

Jerry Liu · Accepted Answer · 2018-12-13 08:37:12Z

3

The empty result seems expected for now. In CosmosDB bingding, sqlQuery has difficulty handling nested token(start and end are properties of request body), related issue here.

Here are three workarounds to try.

Simply put start and end in query string, like https://functionUrl?start=<timeA>&end=<timeB>.
In function.json, set route parameter start and end, i.e. add "route": "{start}/{end}", in httpTrigger binding. Then put time in url to visit.
Get request body and query CosmosDB on our own.

answered Dec 13, 2018 at 8:37

Jerry Liu

17.9k4 gold badges47 silver badges66 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Eugenio Over a year ago

Thank you a lot! Very detailed but concise, I will probably go for the third option since it's the most flexible but the other two are very good too, thanks again!

Collectives™ on Stack Overflow

Azure Function App HTTP Trigger CosmosDB input query from the request's body

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related