• 2 min read

Azure DocumentDB – edit and query documents in the Azure portal

We’ve released a number of great enhancements to further improve the DocumentDB management experience. Our October 23rd portal update lights up several new capabilities!

We’ve released a number of great enhancements to further improve the DocumentDB management experience.  Our October 23rd portal update lights up the following new capabilities through https://portal.azure.com:

  • Document CRUD operations – create, edit and delete documents
  • Document filtering and refresh – filter and refresh results within Document Explorer
  • Query Explorer – author and run DocumentDB SQL queries

  Keep reading for some additional information on each of these new features!  

Document CRUD operations

Document Explorer has been enhanced such that you can create, edit and delete documents.  To create a document, simply click the Create Document command and a minimal JSON snippet will be provided: 1-new Note that if you choose to not provide an id, Document Explorer will automatically generate a GUID as the id value. Click save and the blade title is updated to reflect the supplied (or generated) id: 2-new To edit an existing document, simply select it in Document Explorer, edit the document as you see fit, and click the Save command: 3 Likewise, you can delete a document by selecting it, clicking the Delete command and then confirming the delete (after confirming, the document will immediately be removed from the Document Explorer list): 4 Note that Document Explorer will validate that the document contains valid JSON: 5 And will also prevent you from saving a document with invalid JSON content: 6

Document Explorer Filter and Refresh Support

Document Explorer now supports filtering the currently loaded set of documents by the id property.  Simply type in the filter box and the current results in the grid will be filtered based on your criteria: 7-new

Query Explorer

We’re very happy to introduce a new Query Explorer experience which allows you author and run DocumentDB SQL queries. You can launch Query Explorer from any of the DocumentDB Account, Database, or Collection blades.  A default query of SELECT * FROM c is provided in the Query Editor.  You can accept the default query or construct your own and then click the Run command to view the results: 8-new2 By default, Query Explorer will return results in sets of 100.  If your query produces more than 100 results, simply use the Next page and Previous page commands to navigate through the result set: 9-new As always, we’d love to hear from you about the DocumentDB features and experiences you would find most valuable within the Azure portal.  Please submit your suggestions on the Microsoft Azure DocumentDB feedback forum.  If you haven’t tried DocumentDB yet, then get started here. Enjoy!