smartsheet / smartsheet-python-sdk

Library that uses Python to connect to Smartsheet services (using API 2.0).
Apache License 2.0
45 stars 22 forks source link

Large numeric values can no longer be used as cell values #42

Closed sjherrick closed 9 months ago

sjherrick commented 9 months ago

Describe the bug As of the morning of 1/11, trying to assign a cell value a large number returns error code 1148.

To Reproduce Steps to reproduce the behavior: Assign cell value of a 16+ digit value and update the row

x = sheet.rows[0].id
y = smart.models.Cell()
y.strict = False
y.column_id = column_dict['test']
y.value = '89014104273400552827'
z = smart.models.Row()
z.id = x
z.cells.append(y)
print(smart.Sheets.update_rows_with_partial_success(SHEET_ID, z))
{"failedItems": [{"error": {"code": 1148, "errorCode": 1148, "message": "", "refId": <ref_id>, "index": 0, "rowId": <row_id>}], "message": "PARTIAL_SUCCESS", "resultCode": 3}

Expected behavior Prior to the morning of 1/11, the above code ran without issues.

Screenshots If applicable, add screenshots to help explain your problem. Reminder: do not include your API access token or confidential information with any screenshots

Environment (please complete the following information):

The documentation says this about the error code: "NOTE: The Smartsheet application only supports numeric values in the range -9007199254740992 to 9007199254740992. If using strict parsing, any numeric value outside that range results in error code 1148. If using lenient parsing, the value is silently converted to text."

But setting the cell object's strict property to 'False' does not work either.

sjherrick commented 9 months ago

This was an (unreported) issue with smartsheet's REST API, not the SDK. closing ticket