Getting APiERROR
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
Answers
-
- Verify the date is ISO format, if it is a date only column, then do not send the time
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 379 Global Discussions
- 213 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives