Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-28-2024 08:32 AM
Cheryl - Please find the below script to retrieve the issue.
import requests
import json
workspace_url = 'XXXX'
uri = f"https://{workspace_url}/api/2.0/sql/history/queries"
print(uri)
headers_auth = {"Authorization": "Bearer XXXX"}
start_ts_ms = 1711577103226
end_ts_ms = 1711577179912
request_string = {
"filter_by": {
"query_start_time_range": {
"end_time_ms": end_ts_ms,
"start_time_ms": start_ts_ms
},
"statuses": [
"FINISHED", "CANCELED"
],
"warehouse_ids": "XXXX"
},
"include_metrics": "true",
"max_results": "1000"
}
v = json.dumps(request_string)
endp_resp = requests.get(uri, data=v, headers=headers_auth).json()
beautified_resp = json.dumps(endp_resp, indent=4)
print(beautified_resp)