Smartsheet api call in python.

Hi im trying to use the smart sheet API in Python with the following code.

#Establishes a connection to smart = smartsheet.Smartsheet(api_base="https://api.smartsheet.eu/2.0/sheets", access_token="MYTOKEN")

smart.assume_user("MYEMAIL")

#Establishes link to the time off requests

smartsheetsheet_id = "MYSHEETID"

sheet = smart.Sheets.get_sheet(sheet_id) print(sheet)

But I am receiving the following error.

{"response": {"statusCode": 401, "reason": "Unauthorized", "content": {"errorCode": 1030, "message": "You are unable to assume the user specified.", "refId": "knzehm"}}}
{"result": {"code": 1030, "errorCode": 1030, "message": "You are unable to assume the user specified.", "name": "ApiError", "recommendation": "Do not retry without fixing the problem. ", "refId": "knzehm", "shouldRetry": false, "statusCode": 401}}

Is this possibly due to our organisation using single sign on? In any event any help you could provide would be appreciated.

Find more posts tagged with

Accepted answers

blubblubmeow

Hi Genevieve,

I have since fixed this issue. It was a combination of the code being wrong and my account not being set up as a Developer on the EU environment the first one was fixed with the below code change.

smart = smartsheet.Smartsheet(api_base="https://api.smartsheet.eu/2.0/", access_token="MYAPIKEY")

sheet_id = "MYSHEETID"
sheet = smart.Sheets.get_sheet(sheet_id)

and the second one was just a simple request to the staff at Smartsheet, hope this can help other developers.

All comments

Genevieve P.

Hi @Kezanub

Can you clarify what user you're looking to "assume"? An admin cannot impersonate another admin, is it possible the account is an admin account? Here's more information: https://smartsheet.redoc.ly/#section/API-Basics/Assume-User

This other Community post has more examples of assume user:

https://community.smartsheet.com/discussion/comment/409154#Comment_409154

This conversation in StackOverflow may be useful to you as well: https://stackoverflow.com/questions/76623318/assume-user-not-working-in-smartsheet-api

Cheers,
Genevieve

blubblubmeow

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.