Execute Stored procedure in azure server

Question

How to execute an sample stored procedure in azure server.

I am using cosmos db emulator and whenever i try to execute a sample sp i get this error

Requests originating from scripts cannot reference partition keys other than the one for which client request was submitted.

Stored procedure

function createToDoItem(itemToCreate) {
    var context = getContext();
    var container = context.getCollection();
    console.log("success");
    var itemToCreate={
        "Id": null,
        "UserAccountID": "1742",
        "FirstName": "Sanjeev",
        "LastName": "S",
        "Phone": "12345678",
        "Location": "",
        "StreetAddress": "vcbgvbvc",
       };

itemToCreate.partitionKey = "UserAccountID";

    var accepted = container.createDocument(container.getSelfLink(),
        itemToCreate,
        function (err, itemCreated) {
            if (err) throw new Error('Error test' + err.message);
            context.getResponse().setBody(itemCreated.id)
        });
    if (!accepted) return;
}

the sample stored procedure also fails to get the desired results. linking the question here

When you're executing the stored procedure, what's the value of PartitionKey you're passing? — Gaurav Mantri
If you look at the document you're trying to create above, which attribute in that document is the PartitionKey attribute? Is it UserAccountID? — Gaurav Mantri

Jay Gong Jay Gong · Accepted Answer · 2019-04-22T07:20:57

Sanjeev S,based on the issue message:

Requests originating from scripts cannot reference partition keys other than the one for which client request was submitted.

It claims that your partition key in your document needs to match the partition key setting of your collection.

For example,your collection's partition key is /name,

Then you need to exclude the name property in your inserted document and provide the partition key like this when you execute the SP.

Output:

Execute Stored procedure in azure server

Stored procedure

2 Answers