Use dashboard API to get data in python dataframe

The token has been removed, however do you use Bearer before the token? So "Authorization": "Bearer TOKEN"

Hey aditya ,

As mentioned by HamzaJ , it's seems that the Bearer is missing from the Authorization. 
therefore, the error message is Unauthorized.

Please find an updated Sample script including the Bearer token 

import requests

# define Variables
server = '' #format of https://my-sisense.sisense.com
token = ''
dashboard_oid = ''
widget_oid = ''

### 
headers = {
    "Authorization": f"Bearer {token}",
    "Content-Type": "application/json"
}
url = f'{server}/api/v1/dashboards/{dashboard_oid}/widgets/{widget_oid}'

# Send the request
response = requests.get(url=url, headers=headers)
print(response.status_code)

data = response.json()
print(data)

Best Regards

Hi aditya,

Thank you for reaching out. I edited your post to remove potentially sensitive information.

It looks like the authorization token is to short. Can you make sure that it is copied correctly and let us know how it goes?

Thank you.

DRay , I have intentionally not provided the token,it is usually Bearer 'token' format

Thanks!

AssafHanina ,

I also tried in the format which you shared but I'm getting same error "Unauthorised".

Thanks!

Hi aditya. Were you able to get this resolved?

Hi DRay ,Yes it is resolved.