What is the Cosmos SQL rest API size limit for sending data in request body and how to process a large size API payload for Cosmos?

Question

We are using Cosmos SQL REST APIs to insert/update data in Cosmos db over RBAC. I saw MS documentations that max allowed limit is 2 MB.
]1

How to store a data more than 2MB in cosmos DB using SQL APIs?
FYI, our API call is having all details in msg body and there is no attachment.

Thanks

Answer 1

Hi, @Amit Kumar Thanks for posting your question in the Microsoft Q&A forum.
For SQL API Cosmos DB. 2 MB limit cannot be increased. Only Mongo DB can access the 16 MB Doc support, currently in Preview
I can think of two options

1. recommended to split the document into multiple sub-documents and create a new field to link them together. When retrieving, you would use a query to retrieve all documents that are linked together.

Alternatively, you can use 'attachment' options as well for documents larger than 2 MB. however, this is something you don't want to go with as you mentioned there are no attachments.

However, I am checking with the internal product team to provide you with more details.
Regards
Geetha