How to pass an array of items from Python to a Cosmos DB Stored Procedure (v3 Python SDK or earlier).

pass-array-sproc.py

import uuid
import os

# v3 Python SDK - note that v4 changed the API and stored procedures now live in the azure.cosmos.scripts module.
import azure.cosmos.documents as documents
import azure.cosmos.cosmos_client as cosmos_client
import azure.cosmos.errors as errors

COSMOS_HOST = os.environ['COSMOS_HOST']
MASTER_KEY = os.environ['MASTER_KEY']
DATABASE_ID = os.environ['DATABASE_ID']
COLLECTION_ID = os.environ['COLLECTION_ID'] 
database_link = 'dbs/' + DATABASE_ID
collection_link = database_link + '/colls/' + COLLECTION_ID
# Use sample bulk SP from here: https://github.com/Azure/azure-cosmosdb-js-server/blob/master/samples/stored-procedures/BulkImport.js
sproc_link = collection_link + '/sprocs/bulkImport'

def create_cosmos_entity(jobid, test):
    
    return {
        'JobID': jobid,
        'Test': test
    }

def main():
  
  new_docs = []
  counter = 0
  while counter < 30:
    new_docs.append(create_cosmos_entity(str(uuid.uuid4()), counter))
    counter += 1
 
  if(len(new_docs) > 0 and counter < 100):
    client = cosmos_client.CosmosClient(COSMOS_HOST, {'masterKey': MASTER_KEY})
    # The key here is to include [] around 'new_docs' otherwise call fails!
    client.ExecuteStoredProcedure(sproc_link, [new_docs])
    

I got this error when i run it in my env.

AttributeError: 'CosmosClient' object has no attribute 'ExecuteStoredProcedure'

azure-core-1.1.1 azure-cosmos-4.0.0b6 are installed

The v4 Cosmos DB Python SDK changed a bunch of APIs. Stored Procedures now live in the azure.cosmos.scripts module - see the docs for more information. https://azuresdkdocs.blob.core.windows.net/$web/python/azure-cosmos/4.0.0/azure.cosmos.html#azure.cosmos.scripts.ScriptsProxy.execute_stored_procedure

Hey @sjwaight, good post.
I'm trying to replicate because I need to do the same bulk Import.
I'm receiving the same error that @yanshen1982 used to have, but my partition key value is an attribute or the JSON.

What can be a good workaround for this?

Thanks!

Recommend having a read through this Stack Overflow question and the accepted answer: https://stackoverflow.com/questions/48798523/azure-cosmos-db-asking-for-partition-key-for-stored-procedure