DocumentDB and client side javascript API for querying a collection

Question

I'm playing with DocumentDB's client side javascript API. I want to be able to query a collection. I'd like to use a collection URL, something like: "https://mydocumentdb.documents.azure.com:9443/dbs/my_db/colls/my_users" but there appears to be no API function for me to query a documentdb collection without first having the database "self link" and then in turn getting the collections "self link". The only way to get these self links appears to be to first iterate through all my DB's and then pull the right self link, then iterate through my collections, get the collection, finally, use my self link that I got from the service to query the collection.

Really???

Andrew Liu · Accepted Answer · 2014-09-22 22:53:02Z

1

Not exactly.

You're correct in that you have to query for a collection's self-link prior to querying the collection. (I know... this can be quite annoying, and is being looked in to by the DocDB team).

However, there is no need to iterate through all of your DB/collections to retrieve self-links as they are indexed server-side.

It is better to query directly for the particular DB/collection you're looking for, which looks something like: client.queryCollections(database._self, 'SELECT * FROM collections c WHERE c.id="' + collectionId + '"'), where collectionId is an identifier you assign.

edited Sep 22, 2014 at 22:53

answered Sep 22, 2014 at 20:24

Andrew Liu

8,12940 silver badges47 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

DocumentDB and client side javascript API for querying a collection

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related