How to write to a Smartsheet "Restrict to date only" cell using API?

Devi

Hello All! Need your help. With Python using Smartsheet API, I am trying to write to a date only column. I am getting the below error.

v1=datetime.datetime.utcnow().date()
new_cell = ss_client.models.Cell({'column_id': 123456789,
                              'object_value': v1,
                              'strict': False})

{"result": {"errorCode": 1012, "message": "Required object attribute(s) are missing from your request: cell.value.", "name": "ApiError", "recommendation": "Do not retry without fixing the problem. ","statusCode": 400}}


new_cell = ss_client.models.Cell({'column_id': 123456789,
                              'object_value': "2019-10-13",
                              'strict': False})

"errorCode": 5536, "message": "The value \"2019-10-13\" could not be saved in column \"col3\". This column is restricted to DATE values only."

Genevieve P.

Hi @Devi

Are you getting a new error, or is it the same message?

I'm not that familiar with Python however I don't believe you need an 'object_value' parameter, it should just be Value. Try:

v1 = datetime.datetime.now().isoformat()   #v1 = 2022-10-25T08:48:45.736949                      
new_cell = ss_client.models.Cell({'column_id': column_map[k1],
                                  'value': v1,})

https://smartsheet.redoc.ly/#operation/update-rows

Cheers!

Genevieve

Genevieve P.

Hi @Devi

When you input a date via the API, you'll need to write it in ISO-8601 format, that is, YYYY-MM-DDTHH:MM:SSZ.

Here's the documentation on this: Dates and Times - Smartsheet API Documentation

Cheers,

Genevieve

Devi

Hi @Genevieve P. Thank You for the reply. I did try converting the date to ISO-8601 format, but still the script failed to write to the date restricted column. I even tried to convert the input date value(v1) from str object to date object/tried to write date only, but no luck. What is the type/format required (for 'object_value' parameter) to write to a date restricted cell?

v1 = datetime.datetime.now().isoformat()   #v1 = 2022-10-25T08:48:45.736949                      
new_cell = ss_client.models.Cell({'column_id': column_map[k1],
                                  'object_value': v1,
                                  'strict': False})

Thank You in advance!

Genevieve P.

Hi @Devi

Are you getting a new error, or is it the same message?

I'm not that familiar with Python however I don't believe you need an 'object_value' parameter, it should just be Value. Try:

v1 = datetime.datetime.now().isoformat()   #v1 = 2022-10-25T08:48:45.736949                      
new_cell = ss_client.models.Cell({'column_id': column_map[k1],
                                  'value': v1,})

https://smartsheet.redoc.ly/#operation/update-rows

Cheers!

Genevieve

Devi

Thanks a lot Genevieve! It's working now after replacing 'object_value' with 'value'.

Genevieve P.

Awesome, glad to hear it! 🙂