Delete a Sent Update Request
Since Smartsheet doesn't have the option to resend update requests that haven't been completed, I wrote a script to pull all sent update requests, filter on pending requests, generate+send new requests, and delete the original request. The problem I'm having is that the delete update request call fails every time. It fails with an "Internal Server Error / Status Code 500" so I can't figure out exactly what's going wrong. I've made the call on several update request IDs, both through Python and HTTPS.
I have a ticket open for this issue, but haven't heard anything back and am wondering if others have had the same problem. I appreciate any input!
Best Answer
-
Hi @Ryan Kramer,
I don't have a request body, for deleting sent update requests there is no request body required. However, I just figured it out while I was looking at the syntax more closely. I was issuing the Delete Update Request command, when in fact I needed to issue the Delete Sent Update Request command. I needed to delete a request that had been sent but was still pending, not a future scheduled update request. I've done a few tests and it is working now.
I apologize for the confusion, and thank you very much for getting back to me!
Sheanon
Answers
-
I can help. When you are calling the API to delete the entries that have been sent, what is the format of your request?
Ryan
-
Hi @Ryan Kramer,
Thanks for the reply. When I construct the request via Python, I issue the call as follows (per https://smartsheet-platform.github.io/api-docs/?python#delete-update-request):
client.Sheets.delete_update_request(sheet_id, req_id)
Here is a snapshot of what I get in return after issuing it on three different request update IDs:
I also tried to issue one of the delete requests via HTTPS (using Postman), but got the same result:
I appreciate any help, thanks!
Sheanon
-
This is the response. I am looking for the Body of the request. Its the field to the right of Headers on your screen shot.
Ryan
-
Hi @Ryan Kramer,
I don't have a request body, for deleting sent update requests there is no request body required. However, I just figured it out while I was looking at the syntax more closely. I was issuing the Delete Update Request command, when in fact I needed to issue the Delete Sent Update Request command. I needed to delete a request that had been sent but was still pending, not a future scheduled update request. I've done a few tests and it is working now.
I apologize for the confusion, and thank you very much for getting back to me!
Sheanon
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives