Datasets API

Get a dataset

GET /api/datasets/:id

Parameters

Name Description
id The id of a dataset

Request

Headers

Host: example.org
Cookie: _session_id=ckpBNDlVWCsvakdnNFJuZ2lwZThwNytUY0czT0FVN1c1TXA1N1ZkclplUm1namFFMEdyck5IOTJyRWJyUnd5aWV0VVVlb3lRSWN2UWhSSTZZcmVkODYrZk9NMTZhNWVMZHFXdmVLdkNQU2dLL0hEcGJ6SHJDalNjSjJaNHY4R0xrRlNjTnMzb0hKeXNBK1Z4VDRXK0R6ZHB5S252Q2orUklGN2xoMnNoMk5iSUtDTnhQdTJGTTJ2Q2M0RW5iMlBVcGZIQm4ycllSNjRMSnBRREdCWUxDNGNXdHh2MmhSQU5IckdmcWczQlpqTU5nTmlWcEhvQm9sQVQzNjNaN1FQMTVpU0loY21ZRlZOeVF1SXFMZjNlVCtKaFZMMldZNnBMSEZJaUNuL3FNczE3c2s5eDBha2JtRDR0MjE5ckd6RjJsbFd4MnhndVc3SnU1N3lHUHVRdnZKOUx4UmRpems4YUtuLzRLSlVRdktFWi83eXdzZVBXYVdPV2UzdVJUM3Q2U012eDZXY2NZakFRS29JMWZVTHpoYnVCQ25HZnZiOEZnTkdDUC9ETldZTT0tLUh3LzMybWhEZjErN0huVVpwQVRFTFE9PQ%3D%3D--9a658e7154027521b85c3ed105cc47543a6e688b

Route

GET /api/datasets/1000005

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/"45af8b726e56ee0fc067a9889d77524c"
Cache-Control: max-age=0, private, must-revalidate
Set-Cookie: _session_id=cGZSbGN5VzNjSU40dzJ5MHJTbHArQVFxZW1LWWsvYlBDckVRVWVFWEVpRDFRdU5zeDRzajRkazAzZHdIK2NHWFZiMWFlR3F3KzZvbUlRNU10MGxYNU42OW03OHJzb2k2TGhqVFFLVXRZWnFBbUVXZ2hxZklzVmpCeEFmSFBadkFUb2VaSFM4TE04eFFlc0RSU285WncwMXN4SncrQ3BGc0oxTkRIY0V0WUhYSVozcFErK1dUTWo2WDRRSkhhMHh5SUppYXZSTkNoZjd0NWlsdnVMZXNCdFljakdGUUFUTkdCUTR0QkZYQTZvZ1RYcGJpb2dqSEhRd0VOTVpDSFJITEYybEtFamN2QmFrNkxzSW5IUlVQQmE1WXZudmhwanRuems0Z29PZlpsaVB6MlMvQkQyZng4OUJPeC9VcmpZay9wVGkydmxnQU9vNFZMM2ZwS2Qrb20vd21MZGxkWmNMOGpQdGV5RXB1L3BzcXBQMHdlZE4vQSsySzJEUjVSMU9TeXJ6NzE1YUVOSHJ5QzRTN2U0dXpUcWN3S3daYjZwbTQwc1BmM0lYcjhZWjM5MGdDeFVSN25zT2NNdTNiWllEZC0teXF6NEt1SE02a0x0ZHdqTkNlQlFtQT09--03e3931b122d86e10868dd68d3f3a19d0b299387; path=/; HttpOnly
X-Request-Id: aab08c8d-617c-4f6b-9521-77f7774f9b14
X-Runtime: 0.127693
Content-Length: 1407

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
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
 
{
  "response": {
    "recent_comments": [
      {
        "body": "Note on workspace dataset",
        "author": {
          "id": 1000006,
          "username": "owner",
          "first_name": "searchquery",
          "last_name": "User_1",
          "image": {
            "original": "/paperclip/users/images/001/000/006/original/User.png?1554329366",
            "icon": "/paperclip/users/images/001/000/006/icon/User.png?1554329366",
            "entity_type": "image",
            "complete_json": true
          },
          "is_deleted": null,
          "auth_method": "internal",
          "ldap_group_id": null,
          "user_type": "analytics_developer",
          "entity_type": "user",
          "using_default_image": false,
          "active_license": true,
          "is_siteadmin": false,
          "roles": [
            "data_admin"
          ]
        },
        "timestamp": "2019-04-03T22:09:44Z",
        "complete_json": true
      }
    ],
    "comment_count": 2,
    "id": 1000005,
    "object_name": "default_table",
    "schema": {
      "id": 1000006,
      "name": "default",
      "dataset_count": 0,
      "refreshed_at": "2019-04-03T22:09:24Z",
      "entity_type": "gpdb_schema",
      "is_deleted": null,
      "stale": false,
      "database": {
        "id": 1000001,
        "name": "default",
        "data_source": {
          "id": 1000002,
          "name": "Owners",
          "entity_type": "gpdb_data_source",
          "is_deleted": null,
          "shared": false,
          "owner_id": 1000006,
          "version": "9.1.2 - FactoryVersion",
          "is_hawq": null,
          "state": "online",
          "public": false
        },
        "entity_type": "gpdb_database",
        "complete_json": true
      },
      "complete_json": true
    },
    "entity_type": "dataset",
    "entity_subtype": "SOURCE_TABLE",
    "stale": false,
    "stale_at": null,
    "is_deleted": null,
    "associated_workspaces": [],
    "has_credentials": true,
    "tableau_workbooks": [],
    "tags": [],
    "object_type": "TABLE",
    "complete_json": true
  }
}