I am having trouble setting the value of a KV Store collection field of type time. Does anyone know the best way to do this through the REST API?
Some additional detail,
I have a KV Store collection, created through the REST API, which contains the following fields, with these types.
Next, I do a POST to my collection, with the following data:
"notes":"Expiration date should be 6/1/2016",
Last, I check the contents of the record:
"notes": "Expiration date should be 6/1/2016"
For some reason my expiration field won't persist data. I have taken a few guesses at the format required for my time field in the POST above, but have not had any success storing a value.
You need to use a valid BSON data type and 'time' is not valid. Have a look at these two and see if either work.
I believe you'll need to convert your date to epoch time as well.
eval epoch=strptime(expiration, "%Y-%m-%dT%H:%M:%S.%3NZ")