Deleting rows via Smartsheet API 2.0

Amy A.

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

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.

 

Thanks,

Joseph