documentdb-lumenize
documentdb-lumenize copied to clipboard
ParitionKey required on sum
Hi, thanks for the nice store procedure!
One quick question. I'm using this one on a shared CosmosDB with partition key 'pk', when I query my db with the following code I get an error:
"System.Private.CoreLib: Exception while executing function: Horizontal. Microsoft.Azure.DocumentDB.Core: PartitionKey value must be supplied for this operation."
Any idea how I can fix this?
string cubeConfigString = @"{
cubeConfig: {
groupBy: 'startDateTime',
field: 'timeserie',
f: 'sum'
},
filterQuery: 'SELECT * FROM c'
}";
Object cubeConfig = JsonConvert.DeserializeObject<Object>(cubeConfigString);
var result = await client.ExecuteStoredProcedureAsync<dynamic>(uri + "/sprocs/cube", cubeConfig);
dynamic result = await this.Client.ExecuteStoredProcedureAsync<dynamic>("db", "collection", "cube", new RequestOptions() {PartitionKey = new PartitionKey("PK key vaule")}, new[] {config});