How to get published sheet's readOnlyFullUrl
Hey Smartsheet Community!
I'd like to get Publish Link from a published sheet by Python.
Thanks
Roy
Best Answer
-
Hey Sean, after I poste this question to Stackoverflow, I actually got an answer.
"When troubleshooting property names in situations like this, it's often helpful to look at the SDK source code on GitHub. In this case, the sheet_publish.py model that's defined in the SDK source code shows that the correct syntax for this property name is:
read_only_full_url
(notreadOnlyFullUrl
)."It works like a charm.
Thank you for your input.
Roy
Answers
-
Hello @Roy Yue ,
After reviewing our API Documentation, I was able to find the following that should help you obtain a Sheets Published URL:
When using GET /sheets/{sheetId}/publish, it should provide:
"readOnlyLiteEnabled": false, "readOnlyFullEnabled": true, "readWriteEnabled": false, "icalEnabled": false, "readOnlyFullAccessibleBy": "ALL", "readOnlyFullUrl": "https://publish.smartsheet.com/6d35fa6c99334d4892f9591cf6065"
See more on this here: https://smartsheet-platform.github.io/api-docs/?python#publish-sheet
Please let me know if you have any questions!
Regards
Sean
-
Hello @Sean Morgan ,
thank you for your message, however when I try to get the url, it tells me sheetPublish object doesn't have "readOnlyFullUrl" attribute.
My codes below,
# Publish the sheet sheetToPublish = smartsheet_client.Sheets.set_publish_status( sheet.id, # sheet_id smartsheet.models.SheetPublish({ 'readOnlyFullEnabled': True }) ) get_publish_sheet = smartsheet_client.Sheets.get_publish_status( sheet.id) # sheet_id print(get_publish_sheet.readOnlyFullUrl)
This is the error message.
AttributeError: 'SheetPublish' object has no attribute 'readOnlyFullUrl'
thanks a lot!
Roy
-
Hello @Roy Yue ,
After some testing with Python, I too was unable to get a published URL, and received the same error.
With this, please can you reach out to Smartsheet Support Team here: https://www.smartsheet.com/contact
Kindest Regards
Sean
-
Hey Sean, after I poste this question to Stackoverflow, I actually got an answer.
"When troubleshooting property names in situations like this, it's often helpful to look at the SDK source code on GitHub. In this case, the sheet_publish.py model that's defined in the SDK source code shows that the correct syntax for this property name is:
read_only_full_url
(notreadOnlyFullUrl
)."It works like a charm.
Thank you for your input.
Roy
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 494 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives