Smartsheet API Delete Row Function Error

Wdjameh

Hi, 

When I run a code to delete multiple columns in a sheet >500. It run successfully once, the second try  gave an error :

 Response: { status: 414 Request-URI Too Large content: { << text/html; charset=iso-8859-1 content type suppressed >> }

 

JSONDecodeError: Expecting value: line 1 column 1 (char 0)

 

The code below reads a sheet and deletes data below the 13th row.

 

def delete_data():

    row_ids = [row.id for row in sheet.rows]

    row_ids = row_ids[13:]

    ss_client.Sheets.delete_rows(

        sheet_id,

        row_ids

    )

Do you have any ideas what went wrong and how do I fix it.

Shaine Greenwood

Hello—

I'm wondering if this is an issue with the JSON decoder you're using?

If you're using the python, try updating to the latest version or at least try a 3.7.x build.

You might also make sure you're not using something like pycurl and just stick to the json library that's built into python OR try a library like requests.

If the above doesn't fix the issue, please contact our Support team and we'll troubleshoot the issue with you.