Has anyone been successful using the CreatioSDK in sending date updates via either InsertQuery or UpdateQuery?
I've tried sending dates in all the following formats but all result in an error:
yyyy-MM-dd
yyyy-MM-ddTHH:mm:ss
yyyy-MM-ddTHH:mm:ss.fff
yyyy-MM-ddTHH:mm:ss.fffffffZ
M/d/yyyy
d/M/yyyy
dd/MM/yyyy
The dates I'm trying to send are defined as DataValueType.Date and I've tried specifying that in the Update/InsertQuery and in desperation also tried specifying as DataValueType.DateTime.
If I omit dates from the Insert/Update queries the updates are successful.
I can successfully enter dates in the records I'm trying to update via the Creatio UI.
Here's an example of a stripped down InsertQuery request, including the DueDate column causes an error 500, if excluded the insert is successful:
{
"QueryId": null,
"QueryKind": 0,
"ColumnValues": {
"Items": {
"Title": {
"ExpressionType": 2,
"IsBlock": false,
"ColumnPath": null,
"Parameter": {
"DataValueType": 1,
"Value": "Test SDK Three",
"ArrayValue": null,
"ShouldSkipConvertion": false
},
"FunctionType": 0,
"MacrosType": 0,
"FunctionArgument": null,
"FunctionArguments": null,
"DateDiffInterval": 0,
"DatePartType": 0,
"AggregationType": 0,
"AggregationEvalType": 0,
"SubFilters": null,
"ArithmeticOperation": 0,
"LeftArithmeticOperand": null,
"RightArithmeticOperand": null
},
"Contact": {
"ExpressionType": 2,
"IsBlock": false,
"ColumnPath": null,
"Parameter": {
"DataValueType": 0,
"Value": "fede06a3-1270-4464-8049-c7afb144a018",
"ArrayValue": null,
"ShouldSkipConvertion": false
},
"FunctionType": 0,
"MacrosType": 0,
"FunctionArgument": null,
"FunctionArguments": null,
"DateDiffInterval": 0,
"DatePartType": 0,
"AggregationType": 0,
"AggregationEvalType": 0,
"SubFilters": null,
"ArithmeticOperation": 0,
"LeftArithmeticOperand": null,
"RightArithmeticOperand": null
},
"DueDate": {
"ExpressionType": 2,
"IsBlock": false,
"ColumnPath": null,
"Parameter": {
"DataValueType": 8,
"Value": "2022-05-28",
"ArrayValue": null,
"ShouldSkipConvertion": false
},
"FunctionType": 0,
"MacrosType": 0,
"FunctionArgument": null,
"FunctionArguments": null,
"DateDiffInterval": 0,
"DatePartType": 0,
"AggregationType": 0,
"AggregationEvalType": 0,
"SubFilters": null,
"ArithmeticOperation": 0,
"LeftArithmeticOperand": null,
"RightArithmeticOperand": null
},
"Amount": {
"ExpressionType": 2,
"IsBlock": false,
"ColumnPath": null,
"Parameter": {
"DataValueType": 5,
"Value": 6718.35,
"ArrayValue": null,
"ShouldSkipConvertion": false
},
"FunctionType": 0,
"MacrosType": 0,
"FunctionArgument": null,
"FunctionArguments": null,
"DateDiffInterval": 0,
"DatePartType": 0,
"AggregationType": 0,
"AggregationEvalType": 0,
"SubFilters": null,
"ArithmeticOperation": 0,
"LeftArithmeticOperand": null,
"RightArithmeticOperand": null
},
"Budget": {
"ExpressionType": 2,
"IsBlock": false,
"ColumnPath": null,
"Parameter": {
"DataValueType": 5,
"Value": 0.0,
"ArrayValue": null,
"ShouldSkipConvertion": false
},
"FunctionType": 0,
"MacrosType": 0,
"FunctionArgument": null,
"FunctionArguments": null,
"DateDiffInterval": 0,
"DatePartType": 0,
"AggregationType": 0,
"AggregationEvalType": 0,
"SubFilters": null,
"ArithmeticOperation": 0,
"LeftArithmeticOperand": null,
"RightArithmeticOperand": null
}
}
},
"RootSchemaName": "Opportunity",
"IncludeProcessExecutionData": false
}
Like
Hello Jerry,
Please try to pass Date into Creatio with the following format in UTC time:
"dataValueType":8,
"value":"\"2000-01-01T00:00:00.000\""
Kind regards,
Roman
Hello Jerry,
Please try to pass Date into Creatio with the following format in UTC time:
"dataValueType":8,
"value":"\"2000-01-01T00:00:00.000\""
Kind regards,
Roman