Send date from Excel to Smartsheet
Hi, I found a way to send cell value from Excel to Smartsheet, however the date cell value always has error when sending to Smartsheet.
The CRD column is Cargo Ready Date, which is set as Date property.
In my Excel, I also have CRD date entered as date format.
When I send Excel row to Smartsheet, it says "{"response": {"statusCode": 400, "reason": "Bad Request", "content": {"detail": {"index": 0}, "errorCode": 1012, "message": "Required object attribute(s) are missing from your request: cell.value.", "refId": "e4xqzk1c1u1i"}}}"
I think the date format creates issue when sending date to Smartsheet.
Thank you!
Best Answer
-
Hi Roy,
A list of all the 400 error codes can be found in our API docs (click here). You're receiving 400 / 1012, "A required object attribute is missing from your request: {0}." It's saying that you haven't got the right cell.value specified for that part of the request.
Are you using the "Add Row" request? (See here) If so, are you specifying that the column type for your CRD column (after the column ID in the request) is a Date type?
The Smartsheet API returns all dates and times in the UTC time zone in ISO-8601 format, that is, YYYY-MM-DDTHH:MM:SSZ. Try adjusting your dates in the Excel to be this format and see if it will recognize the data then.
https://smartsheet-platform.github.io/api-docs/?python#dates-and-times
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now
Answers
-
Hi Roy,
A list of all the 400 error codes can be found in our API docs (click here). You're receiving 400 / 1012, "A required object attribute is missing from your request: {0}." It's saying that you haven't got the right cell.value specified for that part of the request.
Are you using the "Add Row" request? (See here) If so, are you specifying that the column type for your CRD column (after the column ID in the request) is a Date type?
The Smartsheet API returns all dates and times in the UTC time zone in ISO-8601 format, that is, YYYY-MM-DDTHH:MM:SSZ. Try adjusting your dates in the Excel to be this format and see if it will recognize the data then.
https://smartsheet-platform.github.io/api-docs/?python#dates-and-times
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now -
Thanks again genius.
-
Hahaha any time!
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now -
I had the same issue, except was using Workato to automatically update a Smartsheet using Google Sheets data. I changed the google sheet format to YYYY-MM-DD and it pulled it in correctly.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.5K Get Help
- 367 Global Discussions
- 202 Industry Talk
- 432 Announcements
- 4.4K Ideas & Feature Requests
- 137 Brandfolder
- 129 Just for fun
- 128 Community Job Board
- 447 Show & Tell
- 29 Member Spotlight
- 1 SmartStories
- 285 Events
- 36 Webinars
- 7.3K Forum Archives