Datasets API

Get all columns for a dataset

GET /api/datasets/:dataset_id/columns

Parameters

Name Description
dataset_id The id of a dataset
page The selected page number of a paginated list of elements. Default is 1.
per_page The number of elements to return per page. Default is 50.

Request

Headers

Host: example.org
Cookie: _session_id=QWkvYktabU40YVIrMDhTajE1MHhzbEZkQTJKOU5wazhTdmpRVG5XOTQvK0kxR2NqQS9EVkJtYm5wVHhSTlUwTENwNU1tSDdIL1RKSlVwQ2tIWTR2ZC94L052R2piaThCZHBUaHJ6NW9Xd2lTVllzQ2RGQzNKN1h6ZHg5Ni9ock5MNTNlRnVwQVRINzVQMnlBOE42Tjk3NzBXOWVXU3UzZkp0SHJManpaQ0JzUlVuOVhtTTFiZTZBc3p1YXhOM01pc2hDQ2cyREluaGZqWE90TFdBcXQ4eWxPaDhFMm5vVWZOcElxK0wyMXhTVXhZQUMvZlBVRXh6bkVFTEZoUnAzekZ6OHNlMnBTQTF5RW8vNmdNNkVUV0w1V3ZDRjVWSFJxbWptdVc4VG8yM3ArWXBZdXJqMnBpOWdscWVRZ3Z3MG9sd3VCS0w4aE51bDAzWDNWbUZiRVlVLzMwV290Q2ZneCtrSFc4d0ZIQjdLczFwUXNLUEVLZ2JPTmJPSjB2M05SRjExUHhuS1BYK2NBeXdEQmphbUwvRzZoZlhRbThvYUZhd0NyNlNPazNHVT0tLXNxZ3JjamliM3Q1OVhCSDZaek1wK3c9PQ%3D%3D--7c91ca2864b7d4131948d20ef900bc59c7166e0a

Route

GET /api/datasets/1000005/columns

Response

Headers

X-Frame-Options: SAMEORIGIN
X-XSS-Protection: 1; mode=block
X-Content-Type-Options: nosniff
Content-Type: application/json; charset=utf-8
ETag: W/"ecce579f52f4683f333c50bbc0fcea04"
Cache-Control: max-age=0, private, must-revalidate
Set-Cookie: _session_id=TW9hRGl2WXNiUVFjNExvR2dVU0dKTk9ISFBPTXRzTXBSb1VWdmtxRDlqUk9wVlRJTEl2QW53VVE1eFlRR2Y3eCs3QVRsWDA0WVovd29KL0htK2ZJUzl6OHpBVGhpL24vSlV4aE4xazJKamxpQjNCY0tKWFVEWlVMNk1KV1QxazdNVkJCSmdQSmw0aWp4SFEzY2ZBT3ZXR200WlVWZWNNVHpHdDJuNDR0dHJKMmhMUUZuWlMzWjV5SWFGZ1hvMzJoNWVSRHFidGFwMjVpOU1BTEM2L0J2aUc4alN5dWlRVnBSRTM2dTdlRzNLajRuaDEvRm9rSXZNM3dPcHBZUGhUS0pZL2NweklGckdvRGFkUmE4Qy92TEFuUFFsNTljRnBCN3k3aWl1YXJZbWhUYnk5RExQTXFacDZhNUFVRmtOS3dlODU2aEg3UFR1OWY5alpIOGpvTlZPMFN6cU1tMzlxSTMvZVA2VFE3N0NzZmVVS0VldGlSMHNvbVJKT3VyYk5ZTVZIbGxxUWh6aFN6NmJqRUJGM2gwdDlycmtwWE9lZ0tIeEVaUXlYd3EwZTVZcnFkYTBuc2VzQWxRNVdCSytHdC0tV0xLajYxR04yUmR5TFpkbGdEa2RWdz09--9b6d9e3902f406c994631d9a2f94fcc8dfa368af; path=/; HttpOnly
X-Request-Id: 13a5bfd4-1da2-4829-8b1f-502642744045
X-Runtime: 0.053344
Content-Length: 442

Status

200 OK

Body

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
 
{
  "response": [
    {
      "name": "column1",
      "data_type": "text",
      "type_category": "LONG_STRING",
      "description": "A nice gpdb column description",
      "statistics": {},
      "entity_type": "database_column",
      "complete_json": true
    },
    {
      "name": "column2",
      "data_type": "text",
      "type_category": "LONG_STRING",
      "description": "A nice gpdb column description",
      "statistics": {},
      "entity_type": "database_column",
      "complete_json": true
    }
  ],
  "pagination": {
    "page": 1,
    "per_page": 50,
    "records": 2,
    "total": 1
  }
}