Question

Proper DateTime DataService Syntax

22:45 Oct 05, 2022

Hello,

I am trying to send some data through DataService to Creatio.

Here is my snippit of the DateTime part,

"CreatedOn": {
				"expressionType": 2,
				"parameter": {
					"dataValueType": 7,
					"value": "2014-01-05 02:03:00.000"
				}
			}

This however does not work, what is the proper format for the value property?

Thanks,

5 comments

keith schmitt

00:04 Oct 06, 2022

"items": {
            "CreatedOn": {
                "expressionType": 2,
                "parameter": {
                    "dataValueType": 8,
                    "value": "\"2022-03-03\""
                }
            }
        }

Tyler Rainey

00:06 Oct 06, 2022

keith schmitt,

{
    "responseStatus": {
        "ErrorCode": "JsonReaderException",
        "Message": "Input string '2022-03-03' is not a valid number. Path '', line 1, position 10.",
        "Errors": []
    },
    "rowsAffected": -1,
    "nextPrcElReady": false,
    "success": false
}

This is the response when that is sent.

keith schmitt

00:49 Oct 06, 2022

Tyler Rainey,

I am not sure what you are using, but in python I have to escape the \

Phase: {
                        "expressionType": 2,
                        "parameter": {
                        "dataValueType": 8,
                        "value": "\""+ date +"\""
                        }
                    }
                    }

keith schmitt

01:04 Oct 06, 2022

If I look at the console when I do an update via browser it looks like this

"items":{"NextActualizationDate":{
"expressionType":2,
"parameter":{
"dataValueType":7,
"value":"\"2022-10-05T18:03:27.020\""

Oleg Drobina

13:02 Oct 06, 2022

Hi,

It's easy to test: go to the section or detail that has the DateTime column and try adding or updating data in this column. In my case I was updating the start date and time of an activity:

We need to go to the request payload and see its source:

You can copy the content and go to any JSON beautify service online (like this) to get the readable JSON:

So as we can see the proper DateTime value is:

"StartDate": {
        "expressionType": 2,
        "parameter": {
          "dataValueType": 7,
          "value": "\"2022-10-05T21:00:00.000\""
        }
      },

So you need to specify it in the same way in your DataService request.

Show all comments