Cosmos DB with Partition Key

General
1

I am trying to use Node-Red with Azure Cosmos DB through the node-red-contrib-azure-documentdb - Documents v0.0.3 node. I had this working, but created a new Cosmos container in the Azure Portal. Azure now require all containers to include a partition key. I set the workCenterID as my partition key, but the msg.payload below no longer works in the Documents node. The error message is at the bottom.

Can you help me with the correct syntax for referencing a partition key?

msg.paylaod:

{
    "dbname":"{{global.databaseName}}",
    "collName":"{{global.tableName}}",
    "action":"C",
    "doc":  {
        "databaseName": "{{global.databaseName}}",
        "tableName": "{{global.tableName}}",
        "workCenter": "{{global.workCenter}}",
        "workCenterID": "{{global.workCenterID}}",
        "filename": "{{global.filename}}",
        "imageURL": "{{global.imageURL}}",
        "date": "{{global.date}}",
        "timestamp": "{{global.timestamp}}",
    }
}

Error Message:
Completed with error {"code":400,"body":"{\"code\":\"BadRequest\",\"message\":\"Message: {\\\"Errors\\\":[\\\"The partition key supplied in x-ms-partitionkey header has fewer components than defined in the the collection.\\\"]}\\r\\nActivityId: 06690861-f3103f4609, Request URI: /apps/9a97ac3/services/cd2935-4427c0a/partitions/cc395d-6f-61ff/replicas/132011p/, RequestStats: \\r\\nRequestStartTime: 2019-07-09T16:18:29.4513848Z, RequestEndTime: 2019-07-09T16:18:29.4814065Z, Number of regions attempted: 1\\r\\nResponseTime: 2019-07-09T16:18:29.4814065Z, StoreResult: StorePhysicalAddress: rntbd://xxxxx-docdb-1.documents.azure.com:1xxx1/apps/9a95be2d-9ac3/services/cd235-6e800a/partitions/cc39ff-1c1ff/replicas/132071p/, LSN: 2, GlobalCommittedLsn: 2, PartitionKeyRangeId: 0, IsValid: True, StatusCode: 400,...

2

I was able to solve this problem by creating the Cosmos DB from within Node-Red with the node-red-contrib-azure-documentdb v0.0.3 nodes.

Create%20a%20Cosmos%20DB
Create a Cosmos DB.png717×316 25.5 KB 

[{"id":"a72580db.46b77","type":"debug","z":"b686ef61.8e599","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"true","targetType":"full","x":750,"y":240,"wires":[]},{"id":"db2ba201.dc2c5","type":"inject","z":"b686ef61.8e599","name":"Create a document with data","topic":"","payload":"{\"dbname\":\"myDb\",\"collName\":\"myCollection\",\"action\":\"C\",\"doc\":{\"name\":\"John\",\"lastname\":\"Doe\",\"company\":\"ACME\"}}","payloadType":"json","repeat":"","crontab":"","once":false,"onceDelay":0.1,"x":200,"y":340,"wires":[["73c9920d.f38a8c"]]},{"id":"6206d201.75a64c","type":"inject","z":"b686ef61.8e599","name":"Create myDb","topic":"","payload":"{\"dbname\":\"myDb\",\"action\":\"C\"}","payloadType":"json","repeat":"","crontab":"","once":false,"onceDelay":0.1,"x":150,"y":100,"wires":[["5c278535.e0bf0c"]]},{"id":"b1428b2.1327578","type":"inject","z":"b686ef61.8e599","name":"List all databases","topic":"","payload":"{\"action\":\"L\"}","payloadType":"json","repeat":"","crontab":"","once":false,"onceDelay":0.1,"x":160,"y":160,"wires":[["5c278535.e0bf0c"]]},{"id":"5fcd06fa.081a88","type":"inject","z":"b686ef61.8e599","name":"Create myCollection","topic":"","payload":"{\"dbname\":\"myDb\",\"collName\":\"myCollection\",\"action\":\"C\"}","payloadType":"json","repeat":"","crontab":"","once":false,"onceDelay":0.1,"x":170,"y":220,"wires":[["4feb1637.158eb8"]]},{"id":"9f945bd0.c7c158","type":"inject","z":"b686ef61.8e599","name":"List all collections","topic":"","payload":"{\"dbname\":\"myDb\",\"action\":\"L\"}","payloadType":"json","repeat":"","crontab":"","once":false,"onceDelay":0.1,"x":160,"y":280,"wires":[["4feb1637.158eb8"]]},{"id":"413bdd25.63cbd4","type":"inject","z":"b686ef61.8e599","name":"Query all documents","topic":"","payload":"{\"dbname\":\"myDb\",\"collName\":\"myCollection\",\"action\":\"Q\",\"query\":\"SELECT * FROM c\"}","payloadType":"json","repeat":"","crontab":"","once":false,"onceDelay":0.1,"x":170,"y":400,"wires":[["73c9920d.f38a8c"]]},{"id":"4feb1637.158eb8","type":"Collections","z":"b686ef61.8e599","name":"Azure Document DB - Collections","x":520,"y":240,"wires":[["a72580db.46b77"]]},{"id":"5c278535.e0bf0c","type":"Database","z":"b686ef61.8e599","name":"Azure Document DB - Database","x":510,"y":120,"wires":[["91233850.c71c48"]]},{"id":"91233850.c71c48","type":"debug","z":"b686ef61.8e599","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"true","targetType":"full","x":750,"y":120,"wires":[]},{"id":"73c9920d.f38a8c","type":"Documents","z":"b686ef61.8e599","name":"Azure Document DB - Documents","x":520,"y":360,"wires":[["afe31872.7b1af8"]]},{"id":"afe31872.7b1af8","type":"debug","z":"b686ef61.8e599","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"true","targetType":"full","x":750,"y":360,"wires":[]}]