API - DELETE by rowid met with an unauthorized error
Hi there,
I've developed logic/code that will delete records based on a date using the rowid. Unfortunately, the delete call does not work when executed from my bi server using Pentaho.
I am able to successfully delete when using Postman (from the bi server) so I can prove my authentication and call are "correct." Any ideas?
a portion of the api call below:
DELETE
https://api.smartsheet.com/2.0/sheets/2009553878443908/rows?ids=5312693350754180
met with error code on when pentaho:
"You are not authorized to perform this action"
Answers
-
Since the call works from Postman but not Pentaho, then it sounds like the issue is with your setup in Pentaho versus something with the Smartsheet API.
The error message would seem to indicate that either your authentication is not setup correctly in Pentaho or the account you're using for authentication in Pentaho doesn't have the right permission level to delete a row in Smartsheet (for example, Viewer permissions on the sheet, or no access to the sheet at all).
If this hasn't helped, you may want to post in the Pentaho Community instead.
Cheers,
Genevieve
-
Thanks @Genevieve P
The odd thing is I can add records from Pentaho using the Smartsheet API, so it seems like deletion is exclusively the problem here. I'll follow up with that community.
-
That is odd; are you able to update rows?
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.1K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 444 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 450 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 290 Events
- 35 Webinars
- 7.3K Forum Archives