How To Get a List of Your SSDS Account’s Authorities
It might seem obvious, but it wasn’t to either me or SSDS guru Mike Amundsen. The syntax to query for a list of SQL Server Data Services (SSDS) authorities for your account is the default address
https://data.beta.mssds.com/v1/
followed by the default Query
from e in entities select e
which translates to
GET https://data.beta.mssds.com/v1/?q='from e in entities select e' HTTP/1.1
Here’s SSDS showing the request (Address and lower text boxes) and the response (upper text box) for the current OakLeaf authority oakleaf1:
(Microsoft limits SSDS beta testers to a single authority.) See comment by the SSDS team’s Stan Kitsis of 9/17/2008.
The inability to obtain a list authorities with
https://data.beta.mssds.com/v1/?q=
is due to a bug, according to a post by Stan Kitsis in the same thread.
Here’s a list of the containers uploaded to the oakleaf1 authority by the latest version of my updated SSDS Test Harness:
You can obtain a list of containers with a pseudo-LINQ query (above) or by executing
https://oakleaf1.data.beta.mssds.com/v1/?q=
(Click either image for the full-size capture.)
Note: Help for SSDS Explorer is at http://msdn.microsoft.com/en-us/library/cc752965.aspx.
2 comments:
Hey Roger,
The following statement isn't true: "Microsoft limits SSDS beta testers to a single authority."
You should be able to create multiple authorities. If for some reason you can't, let me know - it's a bug.
Stan Kitsis
Stan,
I'll take your word for it and run a test later.
I wasn't able to create more than one authority early in the beta.
Post a Comment