Any requirements imposed for the DATE type columns?
Hello, Is there any recent update or modification in Smartsheet that imposes new requirements for the DATE type columns, even when restricted date-only is not selected? My script, which previously (till yesterday) ran successfully without converting date strings to ISO format, is now encountering an error code 5536, stating that the value for a cell in a DATE type column does not conform to strict requirements.
Answers
-
Hey @Devi
I don't believe anything has changed, however if you are specifying a date and time you should send that information in ISO-8601 format.
Here's more information: https://smartsheet.redoc.ly/#section/API-Basics/Dates-and-Times
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 495 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives