searchJson.txt

{"query":{"searchTerms":"name:=OrdersSample","startIndex":1,"startPage":1,"count":10,"id":"7cc379bd-f7ed-4cb9-96f9-f4e51cb57e88"},"id":"7cc379bd-f7ed-4cb9-96f9-f4e51cb57e88","totalResults":1,"startIndex":1,"itemsPerPage":10,"links":[],"facets":[],"results":[{"content":{"__type":"Microsoft.DataSource.Table.0","__creatorId":"SQL Server","name":"OrdersSample","dsl":{"protocol":"tds","address":{"server":"MyServer.contoso.com","database":"Northwind","schema":"dbo","object":"OrdersSample"},"authentication":"windows"},"dataSource":{"sourceType":"SQL Server","objectType":"Table","formatType":"Structured"},"modifiedTime":"2015-05-15T03:48:39.2425547Z","lastRegisteredBy":{"upn":"user1@contoso.com","firstName":"User1FirstName","lastName":"User1LastName"},"lastRegisteredTime":"2015-05-15T03:48:39.2425547Z","__id":"tables/8c853701-4e0f-ab1c-2178-6837da2d1183","schemas":[{"__type":"Microsoft.DataSource.Schema.0","__creatorId":"SQL Server","columns":[{"name":"OrderID","type":"int","maxLength":4,"precision":10,"isNullable":false},{"name":"CustomerID","type":"nchar","maxLength":10,"precision":0,"isNullable":true},{"name":"OrderDate","type":"datetime","maxLength":8,"precision":23,"isNullable":true}],"modifiedTime":"2015-05-15T03:48:39.2425547Z","__id":"tables/8c853701-4e0f-ab1c-2178-6837da2d1183/schemas/af5c1cea-8eb2-abee-16cc-bda261968874","__roles":[{"role":"Contributor","members":[{"objectId":"daa6b2b9-9e66-4b96-a692-994e96fdba40"}]}],"__effectiveRights":["Read","Update","Delete","ViewRoles"]}],"__roles":[{"role":"Contributor","members":[{"objectId":"daa6b2b9-9e66-4b96-a692-994e96fdba40"}]}],"__effectiveRights":["Read","Update","Delete","TakeOwnership","ChangeOwnership","ViewRoles","ViewPermissions"]},"hitProperties":[]}]}