Getting APiERROR

Shikha Bhagat

INFO - {"request": {"command": "POST https://api.smartsheet.com/2.0/sheets/7024241635446660/rows"}}

ERROR - {"response": {"statusCode": 400, "reason": "Bad Request", "content": {"errorCode": 5536, "message": "The value for cell in column 8477412257124228, did not conform to the strict requirements for type DATE.", "refId": "a4ceb5b7-94d8-400b-a19c-a1aa9c6f01d4"}}}

- ERROR - Error processing CSV data in batches: {"result": {"code": 5536, "errorCode": 5536, "message": "The value for cell in column 8477412257124228, did not conform to the strict requirements for type DATE.", "name": "ApiError", "recommendation": "Do not retry without fixing the problem. ", "refId": "a4ceb5b7-94d8-400b-a19c-a1aa9c6f01d4", "shouldRetry": false, "statusCode": 400}}

,464 - ERROR - Failed to batch process CSV data: {"result": {"code": 5536, "errorCode": 5536, "message": "The value for cell in column 8477412257124228, did not conform to the strict requirements for type DATE.", "name": "ApiError", "recommendation": "Do not retry without fixing the problem. ", "refId": "a4ceb5b7-94d8-400b-a19c-a1aa9c6f01d4", "shouldRetry": false, "statusCode": 400}}PS

Alex Argumedo

• Verify the date is ISO format, if it is a date only column, then do not send the time