Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Deleting rows via Smartsheet API 2.0

Amy A.
Amy A.
edited 12/09/19 in Archived 2016 Posts

I get the following error whenever I try to delete a set of rows:

com.fasterxml.jackson.core.JsonParseException: Unexpected character ('<' (code 60)): expected a valid value (number, String, array, object, 'true', 'false' or 'null')

I am passing the sheet Id, a HashSet of the specified row Ids, and "true" to the deleteRows function. I have double checked both the sheet Id and the hashset and they both seem to contain the correct values, so I have no clue as to what could be causing the error.


Any ideas?

Thank you Smile


  • Joseph Miller

    Hi Amy!


    I'm sorry to hear you're having some problems with the API. 


    As a first step, can you please provide a copy of the API request you submitted to Smartsheet? I'd like to take a look at the request that returns the error you're seeing.


    For some additional troubleshooting, I'd also suggest trying the API call either through cURL or a browser REST extension like Postman (https://www.getpostman.com). Running these tests through cURL or Postman will help to rule out any other factors (e.g., SDK syntax, code syntax, etc..) and help determine that the basic request is successful.


    You can also submit a support ticket on this if you'd prefer to go that route. Please submit a copy of your API request/response (preferably using cURL or Postman to simplify) to api@smartsheet.com and we'll get back with you as soon as possible.




This discussion has been closed.