Chorus Views API

Update a Chorus View

PUT /api/chorus_views/:id

Parameters

Name	Description
id	Id of the chorus view to update
query	New SQL statement for the Chorus View, must start with SELECT or WITH

Request

Headers

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

Route

PUT /api/chorus_views/1000026

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/"8a8776f2e669a126db312662c501f8f5"
Cache-Control: max-age=0, private, must-revalidate
Set-Cookie: _session_id=T2FOVmNTWUM4TlpmNEhMcVZ0OGJFQ29TYUpwa3VkaVo3eU8zdnArZzc4NFNucUxrc3FUZWlNTEpJZFcvYjdZQ2tYNzVEZE5iWkZHODR3WFlzeFFqbC9hbzVLTkVqdC9PSVc0dExJMElxQU1NVzNQQ1FFTTBnNnpRU3NraW5PRjcyZ00ySjJBd2RLU3JlVGo1d2gxdGdnMGRqbWpza3lBUkJnQkI0V05md3lWTGxQUGtLUHp5QlJ5Zm04cER1T05jWjdXSmxNU0tkcFVFOTVDbTdQYm1KS2ZoZ2RBZ2JXWXVTc1VOQnc5V2lUY3FySVVucmFJMDNpdVFMSjZOVGhiQmVUaDVKYk9lcUs2YmtTWDVsQ1ltaDZXTHFUVDlVTWRVUGt1MExqU3ZwUUJqd3BDbU9aeHhjSnpsTDNXZFVtcWY2ZUpnT2l3ZDBJL3dxbU4xK3FOblMxRmpjdWRnODF5WnZDcFJQeEI0c2hXZ3FLWDNGZHdtYjQ1NEJmTzZJLzYxYkc2emQyaVNFOGxSRzRqUlUwRXlKa3hsVXQ2ZjVWcFltUGs2dFNaaGNhQy9KeStwTHZvU3AvdDl6Q1kvZkg4NS0tOFJwbzFPV2N0UHpvQklhVitDajJhZz09--6166aa871aa5d33fec72cb361ddb796df077ee3e; path=/; HttpOnly
X-Request-Id: 2f1b9471-938c-41a6-9af9-2c112e842743
X-Runtime: 0.272342
Content-Length: 3378

Status

200 OK

Body

{"response":{"recent_comments":[],"comment_count":0,"id":1000026,"object_name":"chorus_view","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":"CHORUS_VIEW","stale":false,"stale_at":null,"is_deleted":false,"associated_workspaces":[],"workspace":{"id":1000008,"name":"Public","is_deleted":null,"entity_type":"workspace","archived":false,"public":true,"archived_at":null,"summary":"searchquery","permission":["admin","create_workflow"],"datasets_count":11,"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":true,"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},"has_credentials":true,"tableau_workbooks":[{"id":1000000,"name":"default","url":"http:///workbooks/default"}],"tags":[],"object_type":"CHORUS_VIEW","query":"select 1;","complete_json":true}}