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

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

{"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}}