DI Overview: Difference between revisions

From Apps for Creatio
No edit summary
No edit summary
 
(2 intermediate revisions by the same user not shown)
Line 1: Line 1:
Data Islands and Creatio allows you to quickly and easily build robust custom Integrations.
You can:


* Export Creatio data for use in a datawarehouse/mart and feed other systems from Creatio
* Import data into Creatio from ERP or any data located anywhere.


* Note that this requires a specific license. Contact us for details.
Syntax:
>addserver creatio "<ALIAS>" "<URL>" "<USERNAME>" "<PASSWORD>"
EG
>addserver creatio "live2026" "https://live2026.creatio.com" "Supervisor" "********"
----
Filter strings and comparrison commands
eq - equals/=
ne - not equals/!=/<>
ge - greater than or equals/=
le - less than or equals/=
contains - a string contains a value
----Strings
contains(Name,'a')
----
----


Dates
There are 2 modes you can use for Data Islands.
 
Date values must be in ISO format
 
filter=StartDate ge ${from} and StartDate le ${to}
 
Example ISO format
 
          2025-05-08T10:24:01.564Z
 
----


Id fields (typically defined as GUID types) expect the Id value of the lookup table if used in a comparison
1. Command line


EG
2. JINT (Javascript)


$filter=Owner/Id eq 410006e1-ca4e-4502-a9ec-e54d922d2c00 and
For more complex data flows you would use JINT especially in Creatio as you need to get either an Id of a collection based on a Name or the Name based on the collection Id.
stage/id ne a9aafdfe-2242-4f42-8cd5-2ae3b9556d79

Latest revision as of 06:44, 9 May 2025

Data Islands and Creatio allows you to quickly and easily build robust custom Integrations. You can:

  • Export Creatio data for use in a datawarehouse/mart and feed other systems from Creatio
  • Import data into Creatio from ERP or any data located anywhere.

There are 2 modes you can use for Data Islands.

1. Command line

2. JINT (Javascript)

For more complex data flows you would use JINT especially in Creatio as you need to get either an Id of a collection based on a Name or the Name based on the collection Id.