Cosmos DB – Deleting a document

by

The DocumentDB API’s SQL is specifically for querying. That is, it only provides SELECT, not UPDATE or DELETE.

Those operations are fully supported, but require REST (or SDK) calls. For example, with .net, you’d call DeleteDocumentAsync() or ReplaceDocumentAsync(), and in node.js, this would be a call to deleteDocument() or replaceDocument().

In your particular scenario, you could run your SELECT to identify documents for deletion, then make “delete” calls, one per document (or, for efficiency and transactionality, pass an array of documents to delete, into a stored procedure).

More Related Contents:

  1. cosmos db sql query with non alphanumeric field name
  2. How is cosmosDB RU throughput enforced
  3. What is the difference between an Azure Web Site and an Azure Web Role
  4. How can I delete a leased blob in Microsoft Azure storage
  5. AzureStorage Blob Server failed to authenticate the request. Make sure the value of Authorization header is formed correctly including the signature
  6. Publish Multiple Projects to Different Locations on Azure Website
  7. Is there a way to persist chat history in MS Bot Framework Web Chat after a page reload/navigation to another page?
  8. Rewriting a URL in an Azure web app
  9. How do I pause an Azure App Service Plan?
  10. How do I use Binder to perform dynamic bindings in my C# Function?
  11. Azure Webjobs vs Azure Functions : How to choose
  12. How to create a sub container in azure storage location
  13. What’s the difference between Azure AD B2C tenant and normal Azure AD tenant?
  14. Change Azure website app settings from code
  15. How to debug “You do not have permission to view this directory or page”? [closed]
  16. Why is “Application permissions” disabled in Azure AD’s “Request API permissions”?
  17. Retrieve the host keys from an azure function app
  18. Is it better to have many small Azure storage blob containers (each with some blobs) or one really large container with tons of blobs?
  19. Differences between Azure Block Blob and Page Blob?
  20. Is it possible to have a link to raw content of file in Azure DevOps
  21. Blue/Green Deployments with Azure ServiceFabric
  22. How to Run Karate API tests on Azure pipelines
  23. Sending proactive messages from an outside process to organizational users via Teams chat bot
  24. “Use a tenant-specific endpoint or configure the application to be multi-tenant” when signing into my Azure website
  25. Azure App Service Memory Usage. Where to see full breakdown?
  26. Azure Function and storage queue, what to do if function fails
  27. MSAL or ADAL library for use with Azure AD B2C and Xamarin
  28. What versions of .NET are supported on Azure Web Sites?
  29. Can a “User Assigned Managed Identity” be used locally?
  30. How does Microsoft Azure handle Session State?

Leave a Comment