Returns the list of all fields of the given database table

GET

api/databases/{dbid}/metadata/tables/{table}/fields

This request is used for getting the list of all fields of the given database table. For example, in the list of database table fields there is a mandatory field 'ID' (Id)

Request:

Argument	Type	Description
dbid	GUID	The ID of the database
table	String	The name of the database table

Query parameter	Required	Default	Options	Description
all		0	1/0	Returns full metadata

Response:

Content

Type name	Description
Object

Request:

GET api/databases/ec5a34c2-7062-4be7-ade9-c15acefcdbb8/metadata/tables/Notifications/fields
Accept: text/json
Accept-Encoding: deflate,deflate
Authorization: Basic YWRtaW46YWRtaW4=
Host: localhost:6496

Response:

Transfer-Encoding: chunked
Content-Encoding: 
Cache-Control: no-store
Content-Type: text/json; charset=utf-8
Date: Fri, 21 Dec 2012 15:35:14 GMT
ETag: "634916866010755264"
Last-Modified: Fri, 21 Dec 2012 09:36:41 GMT
Set-Cookie: sid=20715d87-29dc-429e-9a86-4b3c60cd8a45; path=/;
Server: Microsoft-HTTPAPI/2.0
 
[
  "Id",
  "RecipientUser",
  "DatabaseId",
  "NotificationName",
  "New",
  "Tag",
  "Urgent",
  "Tags",
  "CreatorUser",
  "EventKind",
  "Subject",
  "Description",
  "CreatedTime",
  "Read",
  "Url",
  "ModifiedStamp"
]