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 0

Like

1 comments
Best reply

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
Show all comments

Hi,

I designed a business process that sends an email and creates a task.

Many outgoing emails appear on the communication panel to be processed.

Is it possible to mark all these emails as processed automatically ?

Like 0

Like

4 comments

Hello Stefano,

 

Thank you for your question!

 

The process on the screenshot will mark all emails in your system as processed once it is started:



Image.png



You can add more filter conditions in order to mark only specific emails as processed.



Else, you can achieve the same result with the SQL query if you have access to the SQL console or the database.

You will need to change the value of the IsNeedProcess column of the EmailMessage table:

 

update "EmailMessageData" set "IsNeedProcess" = false 

update "Activity" set "IsNeedProcess" = false where "TypeId" = 'e2831dec-cfc0-df11-b00f-001d60e938c6' --Type Id stands for Email

 

Best regards,

Anastasiia

Hi Anastasiia

thank you for your response.

I can see the screenshot you have attached

Stefano Bassoli,

 

Just in case - attaching the screenshot once again.

 

Stefano Bassoli,

Ah, ok

thank you very much

Show all comments

Good day community,

 

I'm having trouble with adding the correct JSON path for my request body.

 

I have to send a POST request with the following JSON below:

{
  "members": [
    {
      "@odata.type": "--TYPE HERE--",
      "user@odata.bind": "--USER 1 HERE--"
    },
    {
      "@odata.type": "--TYPE HERE--",
      "user@odata.bind": "--USER 2 HERE--"
    }
  ]
}

This is how my parameter structure looks:

Generated JSON here:

{
	"chatType": "oneOnOne",
	"members": [
		{
			"@odata": {
				"type": "--TYPE HERE--"
			},
			"user@odata": {
				"bind": "--USER 1 HERE--"
			}
		}
	]
}

The problem with this structure is that it generates a nested key for type under @odata, and for bind as well. I don't wan't this to happen if possible.

 

Is there any way to get this to work using parameters in web service? Or would my only resort be to generate the request body via script?

Like 0

Like

2 comments

Hello,

 

The body of the webservice seems to be generated properly since "members" is the array of objects "@odata" and "user@odata". The request was properly parsed and that's why you saw the result as on the screenshot. If this structure won't work in your business case then a separate script task should be created to sent the request.

 

Best regards,

Oscar 

Hi Oscar,

 

Thank you for you response.

 

In forming the json path, I would have made it as $.[members]["@odata.dataType"] or $.[members]["user@odata.bind"], but I'm guessing that this is not possible using the built-in function (nesting parameters) in Creatio?

 

I think I'll instead be resorting to creating a script task for this.

 

Thank you!

 

Lyle

Show all comments

Hi Community,

 

Suppose we have two lookup fields in WEB edit page, Opportunity and Account. Once user will select opportunity we can auto populate Account field through client side coding using esq then after getting the result we will set the value of Account. Now on Mobile how we achieve the same functionality? Any idea please?

Like 0

Like

1 comments

Hi Fulgen,

 

Have you tried the approach with a custom business rule on the mobile record page that will be triggered upon changing the column value? Something similar to the logic described here. And the data should be retrieved using, for example, the Terrasoft.store.BaseStore (as was discussed here).

 

Best regards,

Oscar

Show all comments

Hi Creatio Community

I am trying to access a detail inside of a detail on Customer Portal, but I am getting the attached errors in Console. I am neither able to create a new record nor open an existing record.

 

I have added the detail object in the "List of objects available for portal users" lookup but still unable to get inside that detail on Customer Portal.

 

Thanks.

Like 0

Like

1 comments

Hello Nisarg,

 

Thank you for your question. I am afraid it is not possible to investigate this issue without direct access. Please create a request by writing to support@creatio.com and provide us with external access. We will be glad to help you as soon as we are able to inspect the issue within the recreation and check the whole system, as there might be several breakpoints that might be the reason for this behaviour. 

Will be looking forward to your soonest request! 

 

Best Regards,

Dan

Show all comments

Dear mates,

i 'd like to modifiy a process named "ChangeOrder Société émettrice" in order to launch the process only if the order's company is changed.

In the process designer the custom column "Société émettrice" (UsrSocieteEmettrice) does not appear in the system designer:

 

Is it because the process is in another package which has not access to this column (the order objet is in the custom package).

Thank you !

Nicolas

Like 0

Like

1 comments

Hello Nicolas!



We have already registered the issue for our R&D team to fix this functionality in further releases. I will assign your case to this project in order to increase its priority. 

 

To solve this issue we recommend you generate the source code and compile the system.

 

Best regards, 

Anastasiia 

Show all comments

Hi Community,

 

Any idea how we can integrate yellow messenger chatbot in Creatio CRM?

Like 0

Like

1 comments

Hello Fulgen, 

 

You can integrate the following chat channels with oob tools:

  • Facebook Messenger
  • WhatsApp
  • Telegram

In case you'd like to add a new provider, it will require development. Please refer to the below article for more detailed information:

https://academy.creatio.com/docs/node/2238

 

Best regards,

Anastasiia

Show all comments

Greetings!

I want to show only the contacts that are assigned to a specific role in a contact lookup field for selection.

Like 0

Like

2 comments

Hello,

Such functionality cannot be achieved with a help of basic system tools, but will require development. 

We do not have specific ready to use examples of such implementation from our side but you can refer to the below article on our academy:

https://academy.creatio.com/documents/technic-sdk/7-13/using-filtration…

Also, I would like to suggest to check similar questions on the Community, such as the below posts:

https://community.creatio.com/questions/how-filter-contact-lookup-show-…

https://community.creatio.com/questions/role-base-filtration-contacts-l…

https://community.creatio.com/questions/role-based-filtration

Best regards,

Anastasiia

Hello Janhavi,

I have an article on this exact topic. See

https://customerfx.com/article/filtering-a-contact-lookup-to-only-displ…

Ryan

Show all comments

I modified out Lead process and we don't use "nurturing" anymore. This works well for new leads.

When I copy a lead this new document is still placed in the "nurturing" stage. Which process do I have to modify to change this behaviour?

Like 0

Like

10 comments
Best reply

Christian Waidner,

 

You can check here,

 

Thanks,

Sourav

Hello Christian,

 

Could you please clarify what you mean under "new document" and what actions are you doing before the Lead came to the "nurturing" stage?

 

Thank you in advance!

Hello Anastasiia!

 

Workflow:

Click on an existing lead in list view

Click "copy"

A new lead document ("new document") is being creating

This new document is in stage "nurturing" and I want it to be in a different stage.

Christian Waidner,

Anastasiia Stepanova,

Do you need any more explanation? Is there anything i can do to change the starting phase of a copied document?

Anastasiia Stepanova,

Reminder - are you still on it?

Christian Waidner,

 

If I understand correctly, you do not want to copy the DCM stage while copying the existing record, then you can try the following with the lookup used for DCM in the Object itself,

 

Thanks,

Sourav Kumar Samal

Sourav Kumar Samal,

The checkbox is unchecked for my field and I do not think that this will fix my problem.

 

This is the situation, I click on "copy" on an existing lead.

 

The resulting lead stage looks like this:

 

 

I do not have a "nurturing" stage in my lead stage anymore.

Christian Waidner,

 

Could you check what is the default value of the lookup value set in the object ?

 

Thanks,

Sourav

Sourav Kumar Samal,

If you can give me a hint how to find this in the system .... sure

Christian Waidner,

 

You can check here,

 

Thanks,

Sourav

Show all comments

Hi Team,

 

Currently in Creatio in Order to create the system user with correct roles there is two step process : 

1. Create the Contact

2. Create the System user and assign the role

 

Is there any possibility that we can make it a one step process because for our customers the system is new and they want it to be a one step process.

 

Is it possible to make it a one step process ? Any custom solution ? Does LDAP Synchronization provide any help in this matter? 

 

Regards !

 

 

 

Like 0

Like

1 comments

Hello, 



Due to system logic there is no tool which would allow to simplify the user creation inside of Creatio. 

However, you can import and sync your users with LDAP:

https://academy.creatio.com/docs/user/setup_and_administration/user_and…

Or if you use SSO, you can set up JIT provisioning:

https://academy.creatio.com/docs/user/setup_and_administration/user_and…



If none of the proposed options are suitable for you you still can import contacts with an excel and create system users after that in order to simplify task a bit. 



Kind regards,

Roman

Show all comments