2

Smartsheet.Api.InvalidRequestException: 'The value for cell in column 324579127256964, 19/04/2018, did not conform to the strict requirements for type DATE.'

I'm receiving the above error trying to insert 19/04/2018 into a column programmatically using C#.

As the error states it's not conforming to the the strict requirements. What are the requirements?

luigivampa
  • 377
  • 7
  • 22

1 Answers1

5

If you want to follow the requirements refer to the api docs (http://smartsheet-platform.github.io/api-docs/#cell-reference)

The cell value representation of a date is according to the ISO 8601 format (https://en.wikipedia.org/wiki/ISO_8601): DATE cell value format For example, 2018-04-19 instead of 19/04/2018 should work

If you want to disable the strict requirement checking for a cell include "strict": false in the Cell object in your request body.

Lennart
  • 752
  • 1
  • 5
  • 18