In Logic App, I am querying from CosmosDB using the following Query Documents V5 activity:
(https://i.sstatic.net/bHgOdXUr.png)
The GameID parameter is a list of strings, for example [“1″,”2″,”3”].
I want to get all of the GameID across partitions in this request however the response from CosmosDB is always empty ([]):
(https://i.sstatic.net/XoNwfVcg.png)
If I however specify only one item in the list (eg. [“1”]), then this works normally.
How can I make this query work?
Other similar threads points to using the continuation token to potentially fetch remaining results but in my case it’s null.
There were also some clues about setting EnableCrossPartitionQuery to true, but I also can’t seem to find the option to modify the request header in Logic App. It might also have been enabled by default with CosmosDB SDK V3
Hieu Ngo is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.