Unable to insert/update record in CosmosDB

I am unable to update or insert the record into cosmosDB from retool.

I have created a JS object like below

  id: "uuid",
  partition_name: "kind",
  column: "value"

I simply input this into the update/insert with curly braces.

this is the data:
Screenshot 2024-03-13 at 11.29.46 AM

But when I run the query for Insert/update, I get the error:

The 'kind' value 'MultiHash' specified in the partition key definition is invalid. Please choose 'Hash' partition type
1 Like

Hi @Waseem_Sabir, welcome to the forum! :wave:
This seems to be an issue with the partition key definition. Could you check the partition key definition for your CosmosDB container? Perhaps we can change it to Hash instead of Multihash. From looking at this Github thread, it may be a current limitation on Azure's end.

Hey @Paulo, I think the client library retool is using internally is probably some older version that does not support hierarchical partitioning, because the latest version does support hierarchical partitioning. Anyway, I'd converted the db to use Non-hierarchically container, retool interface works well with that.

Happy to hear it is working with a Non-hierarchically container. Thank you for your feedback! :slightly_smiling_face: