Workspace data source accounts API

Create workspace credentials

POST /api/workspaces/:workspace_id/data_source_account

Parameters

Name Description
workspace_id The id of a workspace
data_source_id The id of a data source
db_username User name for connection
db_password Password for connection

Request

Headers

Host: example.org
Content-Type: application/x-www-form-urlencoded
Cookie: _session_id=MzBDV283T2dvWXUzWTAwRkR4VjlmY0c1WlpvaGh0MEFIYnY3MDVDMDBWMnVySHhuaDUzeTA2SGRHOGNiSWVQNkNoOGZRR1d3akNYVkNUZHovR2pjVlQ3aFF3TjZXN0YrWWtxQi9ISjZOZS9ZM3AyM1BjVFdWWWw0bm42VElSNGV6N0lQMlVvL1oxU1hra0lMclFOSk5KQzlKbEJ6WDBQVHZqcU5GTnJMdkw1QldldVliZGd4OHVNY3ROWG1vQVlNTHNHa2NjRnZKOThTeDM4clhBMXBkcmgydndxc09oQU5xK1NERllaZzViSFRNZ0dMUUZMcGJMMmlhVVUzd1REdE4zVnRVUlIvcTRPemVLdU1yK2RVZmtCemRPQXY5Ti9BZ01VQmpHU2VKV05NTmJzWHZ2VXpTSzNLUGJpOUFmSXQ3bkx6bXZKQ2VtOXlsVXFlc0lPMzI0eURGVXJOZzhZeit3VlBvN2phR2oxWWo5YktnOUlqNW5VY0xQZ24xUVFka0JFWW9SVjE0TmVxdnAxMVZWQ2VTeUc2UzlseDhoeG12WVVzenl5bGg5Zz0tLUhPWkVibU40Z1BmcFdwd1JjVFJRcXc9PQ%3D%3D--e2ad7797bf2bf1bf38359607dbdb96d2720e8491

Route

POST /api/workspaces/1000008/data_source_account

Body

1
 
data_source_id=1000002&db_username=big&db_password=bird_long_password

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/"4ed685b53651ed8561525520a5283325"
Cache-Control: max-age=0, private, must-revalidate
Set-Cookie: _session_id=bjJiZ2NSNE8rdk1rUUlrNXk3ZHIvSktvL3JXV1lZaEVVZXhLUzlZa0wzODN0Q09iNHNuWVNpUGFkcGZkQnVYS3kxV3JFSVRZWFhRSkNuMVU4ckQ3bEJETzc3Y0I0WmlCRnljTGFnZWY1SWwrVHlpR1U2ZzZSYUJzL29JTVEvMm5oVFRUbnliNUltT1huMVRoK09LUnJBQXZyekVhTlBHZXZ2RnRIdzlMQUZSNW94cDVjQlZmbGVTTlRGNGZVYkN5RG1LaU5oenIxaWw5TG1WaDNyQk1oY1FVYWdwWnkza3JOeTZLS0pPZlVvZ3ZjT3lUSzlmWFo3N1U5QnJJeUxKa2haUnZscUtEajMxNGRjUjlYUllkNGhhZkgvRXFnYUpRbEdnYm1EcTkrT1FINWVHeWc2RUY0QlZLUW8rWHp0dXBKM1VNMTQ4OVFNWW52emVPUjNGZlRvYUZTQ1hYa093eGplZko3c0tZemFNZUw1Nmlrd1hBWW1hWXhMckY2V0ZmREtIRWM3bkNONGw3d002UmRvbU9rL2tTN3M2WE1jLzA0aUFTY0plQkxPQ3F3ZmhVQldCcU1WODVGc0t3THYvbzhhaEdDaU96aGc0eGwxNkVjYnRVVUE9PS0tUG5VUW5XejYxcUxmcHZxTW84OXlnQT09--b9606a988e07de942e2ff0710cfe830a0ea4ae92; path=/; HttpOnly
X-Request-Id: cf86f6d2-304a-48f9-a5ec-3b017d32d03b
X-Runtime: 0.102143
Content-Length: 2631

Status

201 Created

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
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
 
{
  "response": {
    "id": 1000029,
    "db_username": "big",
    "owner_id": null,
    "data_source_id": 1000002,
    "owner": null,
    "workspace": {
      "id": 1000008,
      "name": "Public",
      "is_deleted": null,
      "entity_type": "workspace",
      "archived": false,
      "public": true,
      "archived_at": null,
      "summary": "searchquery",
      "permission": [
        "read",
        "commenting"
      ],
      "datasets_count": 5,
      "members_count": 2,
      "workfiles_count": 17,
      "insights_count": 1,
      "recent_insights_count": 1,
      "recent_comments_count": 9,
      "has_recent_comments": true,
      "has_milestones": true,
      "workspace_stage": {
        "default": true,
        "id": 1000000,
        "name": "Define",
        "position": 0,
        "description_long": "Define the essential components of the project.",
        "description_short": "Define the two essential components of a machine learning project. What business problem are we solving? How should the solution change the way our business operates? Locate or acquire all necessary data.",
        "complete_json": true
      },
      "workspace_stage_id": 1000000,
      "archiver": null,
      "image": {
        "original": "",
        "icon": "",
        "entity_type": "image",
        "complete_json": true
      },
      "tags": [],
      "has_added_member": false,
      "has_added_workfile": true,
      "has_added_sandbox": true,
      "has_changed_settings": false,
      "sandbox_info": {
        "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
      },
      "show_sandbox_datasets": true,
      "owner": {
        "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"
        ],
        "email": "chorususer282295@alpinenow.com",
        "title": "Chief Data Scientist",
        "dept": "Corporation Corp., Inc.",
        "notes": "One of our top performers",
        "admin": false,
        "subscribed_to_emails": true,
        "tags": [],
        "deactivated_at": null,
        "complete_json": true
      },
      "is_member": false,
      "is_project": true,
      "project_status": "on_track",
      "project_status_reason": null,
      "milestone_count": 3,
      "milestone_completed_count": 0,
      "project_target_date": "2019-04-28T00:00:00Z",
      "complete_json": true
    },
    "entity_type": "data_source_account",
    "complete_json": true
  }
}