DCKAP Integrator
Make changes to your profile including:
Manage your account settings such as:
Selecting Yes in the Override Project Timezones will display all the projects data and time in the selected timezone.
| | [User Groups](/user-guide/account-management/user-groups) |  | Create and Manage User Groups that you have created. More on User Groups can be found [here](/user-guide/account-management/user-groups). | | [API Keys](/user-guide/api-access-keys) |  | Create and Manage tokens to provide limited access to third party systems | | Change Password |  | Change login password | | Signout |  | Logout from application | # User Groups This is where project owners/administrators can add and maintain a User Group. User Group is a set of users who have similar access levels to any project. ## Purpose User groups simplify a Project Owner's task of managing users for his project. This gives all the users in the group the same permission and access levels to the assigned project. {% embed url="Managing Users
Choose from three options: Admin, Standard, Custom.
To learn more about permissions for each access level, click here.
| | Access Control | This shows up only for the Access Level: [***Custom***](/user-guide/account-management/user-groups#custom). Here you can customize the group's permission level for each of the project resources. | | Add User |Add users to the group by providing their email address.
An invitation is sent to the User asking for confirmation. Only after the user accepts the invitation, they are added to the group.
| {% hint style="warning" %} The group owner may remove a user from the group by clicking on the Remove button. {% endhint %} {% hint style="success" %} Non-DCKAP Integrator users may also be added to the project. An invitation will be sent out to them to sign up for a DCKAP Integrator account. {% endhint %} ### Access Levels Access levels denote the permission rights of user groups for a project. A user group may be assigned to one of the three available access levels: #### Admin Has complete access to the project except deleting and transferring the project ownership. The admin has the ability to provide project access to any user or user group. #### Standard Has standard access to the project and the ability to do all basic things. This access level is one level below the admin. The standard user has some restrictions which include: * cannot delete the project * cannot transfer the project * cannot change project settings/configuration * cannot provide project access to any other users/groups #### For step-by-step instructions on how to create user groups and also give access permissions to User groups, click below: {% content-ref url="/pages/-MCLQLk-LYniiwEd3mDi" %} [Managing User Groups](/tutorials/managing-user-groups) {% endcontent-ref %} # Account Settings Users' account configuration can be managed from here and the user can manage timezone, notifications and so on. This configuration will be applicable to all the projects the user has access to. Click on the user icon in the top right section and click on Account Settings. Under "General Settings", users can manage the below options.  ### General #### Override Project Timezones If yes, all the date and time are displayed in the chosen timezone below. #### Timezone To manage all date related information in the product in the selected timezone. #### Allow Force Login To allow DCKAP Integrator Admin to login to your account. Once the options are chosen, click on **Save** Configuration to save the settings. # Two-Factor Authentication Additional layer of security to access DCKAP Integrator The Two-Factor Authentication feature offers an additional level of security to access DCKAP Integrator. Two-Factor Authentication adds an additional layer of security to your account by requiring more than just a password to sign in. **Steps to enable the 2-factor authentication:** 1. Log in to DCKAP Integrator. 2. Click on the user's name in the top right section of the Dashboard page. 3. Click on Account Settings 4. Under "Two Factor Authentication", click on "Enable Two-Factor Authentication".  5\. Choose one of the two methods in order to enable two-factor authentication:  1. **Method 1 (Recommended): Setup using Authentication App** * Use an application on your phone to get two-factor authentication codes when prompted. * We recommend using cloud-based TOTP apps such as 1Password, Authy, LastPass Authenticator, or Microsoft Authenticator. * Click on "Setup using Authentication App" and hit Next. * A QR code will be displayed. * Use any Authenticator app on your phone to scan the QR code. * After scanning the QR code image, the app will display a 6-digit code. * Enter the code from the application in the space provided and hit "Verify". * Two-factor authentication is now enabled for your account. * Every time you log in to DCKAP Integrator, you will be prompted to enter the Authentication code sent to your Authenticator app. 2. **Method 2: Setup using Email** * DCKAP Integrator will send you an email with a two-factor authentication code when prompted. * Click on "Setup using Email" and hit Next. * DCKAP Integrator will send an Authentication code to your email address. * Enter the code in the space provided. * Two-factor authentication is now enabled for your account. * Every time you log in to DCKAP Integrator, you will be prompted to enter the Authentication code sent to your email address. {% hint style="info" %} Two-factor Authentication may be disabled from the Account Settings page if not required. {% endhint %} # Projects The Projects page is considered the epicenter of the integration process, where users can create, edit and access all the projects that they have access to.Project Settings
Systems connected in the pipe
| Displays the time at which the last sync was performed and if the sync was complete or not |
| Sync Now &
Copy URL button
|For Batch type Integration ⇒ Start the integration process by manually clicking on the Sync Now button.
For Dynamic type Integration ⇒ Copy URL and share across different systems to access data from the system
| | View Logs |  | To view Logs of this pipe | | Enable/Disable Autopilot Mode |Only for Batch type Integration. To enable or disable Autopilot mode.
For Dynamic pipe, scheduling is disabled.
| | Enable/Disable Console Logs |
, in the middle. Here, the fields are modified and transformed to a format that satisfies the underlying Mapping logic.
#### How to configure Modifiers?
1. Drag one or more Source fields and drop it to the Play Area.
2. Then one or more Modifier functions maybe added to the source fields and also the link. Select the field and then Drag and Drop the modifier functions to the Configuration area or Play Area.
3. The Group feature is used to group one or more fields. The Grouped entity can then be used as a single field for modification.
4. Use the Preview section to test the Modifier functionality. The input format of the data to be modified can be selected by clicking on the drop down list in the Preview section.
> Example: *firstname (concatenate)* *lastname*. The output of this modifier is mapped to the destination fields.
### BUILT IN FUNCTIONS
### int
**bit\_length**
Returns the number of bits necessary to represent an integer in binary, excluding the sign and leading zeros.
**conjugate**
Returns the complex conjugate of any int.
```python
Example:
1+3j.conjugate()
Result: (1-3j)
```
### **list**
**Append**
Adds an object to the end of the list.
```python
Syntax: l.append(object)
Parameters: element (required)
Example:
sample_array = [a,b,c]
element = d
sample_array.append(element)
Result: [a,b,c,d]
```
**count**
Returns the number of occurrences of a value in the list.
```python
Syntax: l.count(value)
Example:
sample_array = [a,b,c,a]
sample_array.count(a)
Result: 2
```
**extend**
Extends list by appending elements from the iterable.
```python
Syntax: l.extend(iterable)
Parameters: array_value (required)
Example:
sample_array1 = [a,b,c]
sample_array2 = [d,e,f]
sample_array1.extend(sample_array2)
Result: [a,b,c,d,e,f]
```
**index**
Returns the index of the first occurrence of the specified list item. Raises ValueError if the value is not present.
```python
Syntax: l.index(value, [start, [stop]])
Parameters:
end
index (required)
start
Example #1:
sample_array = [a,b,c,a]
sample_array.index(a,1,5)
Result: 3
Example #2:
sample_array = [a,b,c,a]
sample_array.index(a)
Result: 0
```
**insert**
Inserts an object at the specified index position.
```python
Syntax: l.insert(index, object)
Parameters:
element (required)
index (required)
Example:
sample_array = [a,b,c,a]
sample_array.insert(2,f)
Result: [a,b,f,c,a]
```
**pop**
Removes and returns an item at the specified index (The default is to return the last item in the list). "IndexError" error is raised if list is empty or index is out of range.
```python
Example:
sample_array = [a,b,c,a]
sample_array.pop(2)
Result: [a,b,a]
```
**remove**
Remove first occurrence of value. Raises ValueError if the value is not present.
```python
Syntax: l.remove(value)
Parameters: element
Example:
sample_array = [a,b,c,a]
sample_array.remove(c)
Result: [a,b,a]
```
**reverse**
Reverse \*IN PLACE\*
```python
Syntax: l.reverse()
sample_array = [a,b,c,a]
sample_array.reverse ()
Result: [a,c,b,a]
```
**sort**
Stable sort \*IN PLACE\*
```python
Syntax: l.sort(key=None, reverse=False)
Parameters:
compare
key
reverse
```
####
### **S**tr
**capitalize**
Return a capitalized version of the string, i.e. make the first character have upper case and the rest lower case.
```python
Syntax: S.capitalize() -> str
Example:
sample_string = "test"
Result: Test
```
**center**
Return S centered in a string of length width. Padding is done using the specified fill character (default is a space).
```python
Syntax: S.center(width[, fillchar]) -> str
Parameters:
fillchar
width (required)
Example:
sample_string = "test"
fillchar = -
width = 4
Result : ----test----
```
**count**
Returns the number of non-overlapping occurrences of substring sub in string.
```python
Syntax: S[start:end]
Optional arguments start and end are interpreted as in slice notation
S.count(sub[, start[, end]]) -> int
Parameters:
char (required)
end
Start
Example:
count
sample_string = "test"
char = "t"
Result : 2
```
**encode**
Encode S using the codec registered for encoding. Default encoding is 'utf-8'.
Errors may be given to set a different error handling scheme. The default value is 'strict' meaning that encoding errors raise a UnicodeEncodeError.
Other possible values are 'ignore', 'replace' and 'xmlcharrefreplace' as well as any other name registered with codecs.register\_error that can handle UnicodeEncodeErrors.
```
Syntax: S.encode(encoding, errors)
Example: S.encode(encoding='utf-8', errors='strict') -> bytes
```
**endswith**
Returns True if the String ends with the specified suffix; False otherwise. With optional start, tests the String from the beginning at that position. With optional end, stop comparing S at that position. Suffix can also be a tuple of strings to try.
```python
Syntax: S.endswith(suffix[, start[, end]]) -> bool
Parameters:
end (required)
start (required)
suffix (required)
Example:
sample_string = "test"
end
start: starting and ending index
suffix: st
Result: True
```
**expandtabs**
Return a copy of S where all tab characters are expanded using spaces. If tabsize is not given, a tab size of 8 characters is assumed.
```python
Syntax: S.expandtabs(tabsize=8) -> str
Parameters: tabsize
```
**find**
Return the lowest index in S where substring sub is found, such that sub is contained within S\[start:end]. Optional arguments start and end are interpreted as in slice notation. Return -1 on failure.
```python
Syntax: S.find(sub[, start[, end]]) -> int
Parameters:
char (required)
end
start
Example:
sample_string = "test"
char = "e"
Result: 1
```
**index**
Return the lowest index in S where substring sub is found, such that sub is contained within S\[start:end]. Optional arguments start and end are interpreted as in slice notation. Raises ValueError when the substring is not found.
```python
Syntax: S.index(sub[, start[, end]]) -> int
Parameters:
char (required)
end
start
Example:
sample_string = "test"
char = "e"
Result: 1
```
**isalnum**
Return True if all characters in S are alphanumeric and there is at least one character in S, False otherwise.
```python
Syntax: S.isalnum() -> bool
Example:
sample_string = "test12"
Result: True
```
**isalpha**
Return True if all characters in S are alphabetic and there is at least one character in S, False otherwise.
```python
Syntax: S.isalpha() -> bool
Example:
sample_string = "test"
Result: True
```
**isdigit**
Return True if all characters in S are digits and there is at least one character in S, False otherwise.
```python
Syntax: S.isdigit() -> bool
Example:
sample_string = "123"
Result: True
```
**islower**
Return True if all cased characters in S are lowercase and there is at least one cased character in S, False otherwise.
```python
Syntax: S.islower() -> bool
Example:
sample_string = "test"
Result: True
```
**isspace**
Return True if all characters in S are whitespace and there is at least one character in S, False otherwise.
```python
Syntax: S.isspace() -> bool
Example:
sample_string = " "
Result: True
```
**istitle**
Return True if S is a titlecased string and there is at least one character in S, i.e. upper- and titlecase characters may only follow uncased characters and lowercase characters only cased ones. Return False otherwise.
```python
Syntax: S.istitle() -> bool
Example:
sample_string = "Test"
Result: True
```
**isupper**
Return True if all cased characters in S are uppercase and there is at least one cased character in S, False otherwise.
```python
Syntax: S.isupper() -> bool
Example:
sample_string = "TEST"
Result: True
```
**join**
Return a string which is the concatenation of the strings in the iterable. The separator between elements is S.
```python
Syntax: S.join(iterable) -> str
Parameters: array_values (required)
Example:
sample_list = ["test", "one", "try"]
sample_string = "-"
sample_string.join(sample_list)
Result= "test-one-try"
```
**ljust**
Return S left-justified in a Unicode string of length width. Padding is done using the specified fill character (default is a space).
```python
Syntax: S.ljust(width[, fillchar]) -> str
Parameters:
fillchar
width (required)
Example:
sample_string = "test"
fillchar = -
width = 6
Result: test--
```
**lower**
Return a copy of the string S converted to lowercase.
```python
Syntax: S.lower() -> str
Example:
sample_string = "TEST"
Result: "test"
```
**lstrip**
Return a copy of the string S with leading whitespace removed. If chars is given and not None, remove characters in chars instead.
```python
Syntax: S.lstrip([chars]) -> str
Parameters: prefix
Example:
sample_string = " test"
Result: "test"
```
**partition**
Search for the separator sep in S, and return the part before it, the separator itself, and the part after it. If the separator is not found, return S and two empty strings.
```python
Syntax: S.partition(sep) -> (head, sep, tail)
Parameters: separation (required)
Example:
sample_string = "test"
sample_string.partition("s")
result: ("te", "s", "t")
```
**replace**
Return a copy of S with all occurrences of substring old replaced by new. If the optional argument count is given, only the first count occurrences are replaced.
```python
Syntax: S.replace(old, new[, count]) -> str
Parameters:
count
new (required)
old (required)
Example:
sample_string = "test"
new = w
old = t
Result = "west"
```
**rfind**
Return the highest index in S where substring sub is found, such that sub is contained within S\[start:end]. Optional arguments start and end are interpreted as in slice notation. Return -1 on failure.
```python
Syntax: S.rfind(sub[, start[, end]]) -> int
Parameters:
char (required)
end
Start
Example:
sample_string = "test"
char = "t"
Result: 3
```
**rindex**
Return the highest index in S where substring sub is found, such that sub is contained within S\[start:end]. Optional arguments start and end are interpreted as in slice notation. Raises ValueError when the substring is not found.
```python
Syntax: S.rindex(sub[, start[, end]]) -> int
Parameters:
char (required)
end
start
Example:
sample_string = "test"
char="t"
Result: 3
```
**rjust**
Return S right-justified in a string of length width. Padding is done using the specified fill character (default is a space).
```python
Syntax: S.rjust(width[, fillchar]) -> str
Parameters: fillchar
width (required)
Example:
sample_string = "test"
fillchar = -
width = 6
Result: --test
```
**rpartition**
Search for the separator sep in S, starting at the end of S, and return the part before it, the separator itself, and the part after it. If the separator is not found, return two empty strings and S.
```python
Syntax: S.rpartition(sep) -> (head, sep, tail)
Parameters: separation (required)
Example:
sample_string = "test"
sample_string.rpartition("t")
result: ("tes", "t", "")
```
**rsplit**
Return a list of the words in S, using sep as the delimiter string, starting at the end of the string and working to the front. If maxsplit is given, at most maxsplit splits are done. If sep is not specified, any whitespace string is a separator.
```python
Syntax: S.rsplit(sep=None, maxsplit=-1) -> list of strings
Parameters:
char (required)
maxsplit
Example:
sample_string = "test-try"
char= "-"
result: ["try","test"]
```
**rstrip**
Return a copy of the string S with trailing whitespace removed. If chars is given and not None, remove characters in chars instead.
```python
Syntax: S.rstrip([chars]) -> str
Parameters: chars
Example:
sample_string = "test "
Result: "test"
```
**split**
Return a list of the words in S, using sep as the delimiter string. If maxsplit is given, at most maxsplit splits are done. If sep is not specified or is None, any whitespace string is a separator and empty strings are removed from the result.
```python
Syntax: S.split(sep=None, maxsplit=-1) -> list of strings
Parameters:
char (required)
maxsplit
Example:
sample_string = "test-try"
char= "-"
result: ["test","try"]
```
**startswith**
Return True if S starts with the specified prefix, False otherwise. With optional start, test S beginning at that position. With optional end, stop comparing S at that position. prefix can also be a tuple of strings to try.
```python
Syntax: S.startswith(prefix[, start[, end]]) -> bool
Parameters:
end
prefix (required)
Start
Example:
sample_string = "test"
end
start: starting and ending index
suffix: te
Result: True
```
**strip**
Return a copy of the string S with leading and trailing whitespace removed. If chars is given and not None, remove characters in chars instead.
```python
Syntax: S.strip([chars]) -> str
Example:
sample_string = " test "
Result: "test"
```
**swapcase**
Return a copy of S with uppercase characters converted to lowercase and vice versa.
```python
Syntax: S.swapcase() -> str
Example:
sample_string = "TeSt"
Result: "tEsT"
```
**title**
Return a titlecased version of S, i.e. words start with title case characters, all remaining cased characters have lower case.
```python
Syntax: S.title() -> str
Example:
sample_string = "test"
Result: "Test"
```
**upper**
Return a copy of S converted to uppercase.
```python
Syntax: S.upper() -> str
Example:
sample_string = "test"
Result: "TEST"
```
**zfill**
Pad a numeric string S with zeros on the left, to fill a field of the specified width. The string S is never truncated.
```python
Syntax: S.zfill(width) -> str
Parameters: count (required)
Example:
sample_string = "test"
width=10
Result:"test000000"
```
### Converter
**converter**
To Modify the data with a static raw data from the user input
Eg:- Original data {country:"India"}
Requested Modification {country:"IN"} :returns: Modified JSON data
The ***Swap*** option will allow users to interchange the Key and Value data.
```python
Example:
key="India"
value="IN"
Then IN will be sent to the destination in place of India
```
{% hint style="info" %}
Example of Default value:
key= "\_\_default\_\_"
value= "US"
If the key is an empty key or any key other than IN it will take the default value "US".
{% endhint %}
###
### CUSTOM
**1. 12Hr to 24Hr Converter and 24Hr to 12Hr**
Converts Time from one format to the other (12Hr clock to 24Hr clock and vice versa).
```
Format to enter data
12Hr: 3:00PM
24Hr: 15:00
```
**2. Array Extender**
Used to Concatenate two or more strings and then convert the output of the concatenation into a single string.
Applicable Only To Lists.
```python
Example:
first_name=John
last_name=Smith
Marks=[23, 45, 54, 10, 34]
Result: [John,Smith,23,45,54,10,34]
```
**3. Array or String Slicing**
To slice values from the string/array
```python
Parameters:
start_index
step
stop_index
```
```python
Example 1:
start = 0 or None,
stop = 2,
step = 1
sample = "slicingoperation"
Returns "sl"
Example 2:
start = -4,
stop = None,
step = 1
sample = "slicingoperation"
Returns "tion"
Example 3:
start = None,
stop=None,
step=-1
sample = "slicingoperation"
Returns "noitarepognicils" (Reversed Value)
```
All the above examples applies to arrays as well:
* param start\_index: Index of the element from where you want to start the slicing operation
* param stop\_index: Index of the element where you want to stop the slicing operation
* param step: Specifies the steps that you want to make during the slicing operation
**4. Array To String**
To convert any datatype to string if its dict. Applies json dumps if its list, set, tuple. Joins the iterable elements using join function.
```python
Parameters: join_characters
Example:
sample_array = [a,b,c,d]
join_characters = ","
Result: "a,b,c,d"
```
**5. Concatenate**
Used to Concatenate two or more strings and, convert the output of the concatenation into a single string.
```python
Parameters: join_chars
Example:
str1 = "test"
str2 = "try"
Result: "testtry"
```
#### 6. Convert Non-ASCII characters to ASCII Characters
```
Example:
Input1 : char_a = "Škoda"
Output1 : Skoda (Converted string from Non-ASCII to ASCII)
```
#### 7. Converter
To Modify the data with a static raw data from the user input
Eg:- Original data {country:"India"}
Requested Modification {country:"IN"} :returns: Modified JSON data
The ***Swap*** option will allow users to interchange the Key and Value data.
*The Converter modifier in the CUSTOM modifier section can be used in conjunction with other Modifiers.*
```python
Example:
key="India"
value="IN"
Then IN will be sent to the destination in place of India
```
{% hint style="info" %}
Example of Default value:
key= "\_\_default\_\_"
value= "US"
If the key is an empty key or any key other than IN it will take the default value "US".
{% endhint %}
###
**8. Current Datetime**
Used to display the current date and time in the project timezone.
**9. Datatype Converter**
To convert the the source value to requested datatype
1. string
2. integer
3. dict (requires tuple of key and value pairs)
4. list
5. float
```python
Parameters: Datatype (required)
Example:
sample_value = "1"
Datatype = "integer"
Result: 1 (converted string to integer)
```
**10. DateTime Formatter**
To convert the date\_value to the requested format from current format.
```python
Parameters:
date_value: Date String
requested_format (required): Date format of the return value
Example:
date_value = 2020-05-18 06:25:03.737Z
requested_format = YYYY-MM-DD
Result: 2020-05-18
```
#### Complete list of format codes:
| Format Codes | Description | Example |
| ------------ | -------------------------------------------------------- | ------------------------------ |
| %d | Day of the month as a zero-padded decimal number | 01, 02, 03, 04 …, 31 |
| %a | Weekday as abbreviated name | Sun, Mon, …, Sat |
| %A | Weekday as full name | Sunday, Monday, …, Saturday |
| %m | Month as a zero-padded decimal number | 01, 02, 03, 04 …, 12 |
| %b | Month as abbreviated name | Jan, Feb, …, Dec |
| %B | Month as full name | January, February, …, December |
| %y | Year without century as a zero-padded decimal number | 00, 01, …, 99 |
| %Y | Year with century as a decimal number | 0001, …, 2018, …, 9999 |
| %H | Hour (24-hour clock) as a zero-padded decimal number | 01, 02, 03, 04 …, 23 |
| %M | Minute as a zero-padded decimal number | 01, 02, 03, 04 …, 59 |
| %S | Second as a zero-padded decimal number | 01, 02, 03, 04 …, 59 |
| %f | Microsecond as a decimal number, zero-padded on the left | 000000, 000001, …, 999999 |
| %I | Hour (12-hour clock) as a zero-padded decimal number | 01, 02, 03, 04 …, 12 |
| %p | Locale’s equivalent of either AM or PM | AM , PM |
| %j | Day of the year as a zero-padded decimal number | 01, 02, 03, 04 …, 366 |
#### 11. Datetime to Timestamp Modifier
This Modifier is used to provide the timestamp starting from \menu = \["chocolates","biscuits"]
new\_items = \["cakes","ice creams"]
| ARRAY\_EXTEND(menu,element=new\_items) | \["chocolates","biscuits","cakes","ice creams"] | |menu="chocolates"
new\_items =\["cakes","ice creams"]
| ARRAY\_EXTEND(menu,new\_items) | \["chocolates","cakes","ice creams"] | ### **ARRAY\_INSERT** **DESCRIPTION** Adds an element at the specified index of the list. If the index is not mentioned, the element is added at the zeroth index. **SYNTAX** ``` ARRAY_INSERT(source*,element*,index) ``` **PARAMETER** | **Name** | **Type** | **Description** | | -------- | -------- | ---------------------------------------------------------------------------- | | source | list | Source field - array in which element has to be inserted | | element | any | Element to be inserted in the list | | index | integer |Index at which the element has to be inserted.
Default value: 0
| **EXAMPLES** | **Source Data** | **Expression** | **Output** | | --------------------------------- | ----------------------------- | ---------------------------------- | | menu = \["chocolates","biscuits"] | ARRAY\_INSERT(menu,"cakes",1) | \["chocolates","cakes","biscuits"] | | menu = \["chocolates","biscuits"] | ARRAY\_INSERT(menu,"cakes") | \["cakes","chocolates","biscuits"] | ### **ARRAY\_PUSH** **DESCRIPTION** Returns a list containing the input. Note: ignore\_none must be used only as a keyword argument **SYNTAX** ``` ARRAY_PUSH(args*,ignore_none) ``` **PARAMETER** | **Name** | **Type** | **Description** | | ------------ | -------- | --------------------------------------------------------------- | | args | any |n source fields (n>=1)
Data to be pushed into list
| | ignore\_none | boolean | Indicates whether None should be taken into account or not | **EXAMPLES** | **Source Data** | **Expression** | **Output** | | ------------------------------------------------- | ----------------------------------------------------- | ----------------------------------------- | | company="DCKAP" | ARRAY\_PUSH(company) | \["DCKAP"] | |company="DCKAP"
product="INTEGRATOR"
| ARRAY\_PUSH(company,product) | \["DCKAP","INTEGRATOR"] | |company="DCKAP"
product="INTEGRATOR"
| ARRAY\_PUSH(company,product,sample) | \["DCKAP","INTEGRATOR","NOT\_IN\_SOURCE"] | |company="DCKAP"
product="INTEGRATOR"
| ARRAY\_PUSH(company,product,sample,ignore\_none=True) | \["DCKAP","INTEGRATOR"] | ### **ARRAY\_REMOVE** **DESCRIPTION** Returns the list after removing the element if the element is mentioned. (i) If index is only mentioned, * Returns the list after removing the element at the specified index if it is a valid index. * Returns source if the index is out of range. (ii) If element is only mentioned, * Returns the list after removing the element mentioned if the element is present in the list. * Returns source if the element is not in the list. (iii) If both element and index are mentioned, * Returns the list after removing the specified element if present (ignoring the index). * Returns source if the specified element is not in the list. (iv) If both element and index are not mentioned, * Returns the list after removing the element at zeroth index. (v) If source is not a list, * Returns source. **SYNTAX** ``` ARRAY_REMOVE(source*,element,index) ``` **PARAMETER** | **Name** | **Type** | **Description** | | -------- | -------- | --------------------------------------------------------- | | source | list | Source field - array from which element has to be removed | | element | any | Element to be removed | | index | int | Index of the element to be removed | **EXAMPLES** | **Source Data** | **Expression** | **Output** | | -------------------------------- | -------------------------------- | ---------------------- | | item\_ids=\[1001,1002,1003,1004] | ARRAY\_REMOVE(item\_ids,1003) | \[1001,1002,1004] | | item\_ids=\[1001,1002,1003,1004] | ARRAY\_REMOVE(item\_ids,index=2) | \[1001,1002,1004] | | item\_ids=\[1001,1002,1003,1004] | ARRAY\_REMOVE(item\_ids,2) | \[1001,1002,1003,1004] | | item\_ids=\[1001,1002,1003,1004] | ARRAY\_REMOVE(item\_ids) | \[1002,1003,1004] | | item\_ids=\[1001,1002,1003,1004] | ARRAY\_REMOVE(item\_ids,1001,3) | \[1002,1003,1004] | | item\_ids=\[1001,1002,1003,1004] | ARRAY\_REMOVE(item\_ids,1005) | \[1001,1002,1003,1004] | ### **CAPITALIZE** **DESCRIPTION** Returns string with the first character of the string converted to capital (uppercase) letter while making all other characters in the string as lowercase letters. *Note: Returns source if source is not a string* **SYNTAX** ``` CAPITALIZE(source*) ``` **PARAMETER** | **Name** | **Type** | **Description** | | -------- | -------- | --------------------------------- | | source | string | Source field - data to capitalize | **EXAMPLE** | **Source Data** | **Expression** | **Output** | | --------------- | ---------------- | ---------- | | name="ironman" | CAPITALIZE(name) | "Ironman" | ### **CONCATENATE** **DESCRIPTION** Returns a string by joining the user inputs (with the mentioned join character, if any). Note: join\_chars must be used only as keyword argument **SYNTAX** ``` CONCATENATE(args*,join_chars) ``` **PARAMETER** | **Name** | **Type** | **Description** | | ----------- | -------- | -------------------------------------------------------------------------------------------------------------- | | args\* | string |n source fields (n>=1)
Fields to be joined
| | join\_chars | string |The string that must appear between the sources when the source fields are joined.
Default Value: ''
name="integrator"
connector="@"
domain ="dckap.com"
| CONCATENATE(name,connector,domain) | "first\_name="Iron"
last\_name="Man"
| CONCATENATE(first\_name,last\_name,join\_chars=" ") | "Iron Man" | ### **CONVERT\_TIME** **DESCRIPTION** Converts time from 12 hrs format to 24 hrs format and vice versa **SYNTAX** ``` CONVERT_TIME(source*) ``` **PARAMETER** | **Name** | **Type** | **Description** | | -------- | -------- | ----------------------------------- | | source | string | Source Field - time to be converted | **EXAMPLES** | **Source Data** | **Expression** | **Output** | | ------------------------- | -------------------------- | ------------- | | created\_at='11:37:00 pm' | CONVERT\_TIME(created\_at) | "23:37:00" | | created\_at='23:37:00' | CONVERT\_TIME(created\_at) | "11:37:00 PM" | ### **CONVERTER** **DESCRIPTION** Looks for source in keys of converters dictionary and returns the corresponding value. **SYNTAX** ``` CONVERTER(source*,converters*) ``` **PARAMETER** | **Name** | **Type** | **Description** | | ----------------------------------------- | ---------- | ----------------------------------------------------------------------------------- | | source | string | Source field - key which needs to be replaced with value from converters dictionary | | converters (editable key-value pair icon) | dictionary | Reference dictionary from which the value of source is to be retrieved | **EXAMPLES** | **Source Data** | **Converters** | **Expression** | **Output** | | ------------------------ | --------------------------------------------------------------------------- | ----------------------------- | -------------------- | | country="United States" | {"India":"+91","United States":"+1"} | CONVERTER(country,converters) | "+1" | | country="United Kingdom" | {"India":"+91","United States":"+1"} | CONVERTER(country,converters) | "NOT\_IN\_SOURCE" | | country="United Kingdom" | {"India":"+91","United States":"+1","\_\_default\_\_":"Data Not Available"} | CONVERTER(country,converters) | "Data Not Available" | ### **COUNT** **DESCRIPTION** Returns the length of source; Returns zero, if the source is of invalid datatype. **SYNTAX** ``` COUNT(source*) ``` **PARAMETER** | **Name** | **Type** | **Description** | | -------- | ---------------------- | -------------------------------------------------- | | source | string/list/dictionary | Source field for which length has to be calculated | **EXAMPLES** | **Source Data** | **Expression** | **Output** | | --------------------------------------------------- | --------------------- | ---------- | | items=\[100,200,300] | COUNT(items) | 3 | | country\_codes={"India":"+91","United States":"+1"} | COUNT(country\_codes) | 2 | ### **DATATYPE\_CONVERTER** **DESCRIPTION** Converts the input to requested datatype **SYNTAX** ``` DATATYPE_CONVERTER(source*,datatype) ``` **PARAMETER** | **Name** | **Type** | **Description** | | -------- | --------------------------- | ------------------------------------------------------------------------------------- | | source | any | Source field which has to be converted | | datatype | int,float,boolean,list,dict | Datatype to which source has to be converted. Can be provided with quotes like 'int'. | **EXAMPLES** | **Source Data** | **Expression** | **Output** | | --------------------------------------------------- | ------------------------------------------ | -------------------------- | | country\_codes={"India":"+91","United States":"+1"} | DATATYPE\_CONVERTER(country\_codes,’list’) | \["India","United States"] | | price=100.123 | DATATYPE\_CONVERTER(price,int) | 100 | ### **DATETIME\_FORMATTER** **DESCRIPTION** Formats the datetime (object or string) to user specified string date format. **SYNTAX** ``` DATETIME_FORMATTER(source*,requested_format,default) ``` **PARAMETER** | **Name** | **Type** | **Description** | | ----------------- | ----------------------- | ------------------------------------------------------ | | source | Datetime object/ string | Source field to be converted into the requested format | | requested\_format | string | Desired format of time | | default | | | **EXAMPLE** | **Source Data** | **Expression** | **Output** | | --------------------------------------------- | ------------------------------------------------------- | ------------------------ | | created\_at='Sat, 27 Jan 2018 17:16:55 +0000' | DATETIME\_FORMATTER(created\_at,'%Y-%m-%d %I:%M:%S %p') | '2018-01-27 05:16:55 PM' | ### **DECODE** **DESCRIPTION** Decodes the encoded string (codec registry) **SYNTAX** ``` DECODE(source*) ``` **PARAMETER** | **Name** | **Type** | **Description** | | -------- | -------- | --------------------------------------- | | source | bytes | Source field - bytes data to be decoded | **EXAMPLE** | **Source Data** | **Expression** | **Output** | | ---------------------- | -------------- | ---------- | | secret=b'St\xc3\xa5le' | DECODE(secret) | 'Ståle' | ### **EMAIL\_VALIDATOR** **DESCRIPTION** Returns the email address if valid, else default **SYNTAX** ``` EMAIL_VALIDATOR(source*,default) ``` **PARAMETER** | **Name** | **Type** | **Description** | | -------- | -------- | ---------------------------------------------------------------------------------- | | source | string | Source field - email to be validated | | default | string |Value to display if email is invalid
Default value: "NOT\_IN\_SOURCE"
| **EXAMPLES** | **Source Data** | **Expression** | **Output** | | -------------------------------------- | ------------------------------------------------ | ------------------------ | | contact\_mail="String to display in absence of find\_key or result\_key or a different check\_value
Default Value: "NOT\_IN\_SOURCE"
| **EXAMPLES** | **Source Data** | **Expression** | **Output** | | ----------------------------------------------------- | --------------------------------------------------------------------------- | -------------------- | | signatures= {"Subject":"Request", "Sign":"Sincerely"} | FIND\_AND\_MATCH(signatures,"Subject",'Request','Sign') | "Sincerely" | | signatures= {"Subject":"Request", "Sign":"Sincerely"} | FIND\_AND\_MATCH(signatures,"Subject",'Friend','Sign','Data not available') | "Data not available" | ### **IFELSE** **DESCRIPTION** If the condition is satisfied, it executes on\_success, else runs on\_fail. **SYNTAX** ``` IFELSE(condition,on_success,on_fail) ``` **PARAMETER** | **Name** | **Type** | **Description** | | ----------- | ------------------------ | -------------------------------------------------------- | | condition | field/another expression | Field or expression to be checked for some value | | on\_success | field/another expression | If value exists, field/expression to be returned | | on\_fail | field/another expression | If value does not exist, field/expression to be returned | **EXAMPLES** | **Source Data** | **Expression** | **Output** | | ------------------------------------------------ | --------------------------------------------------------------------------------------- | ---------- | | company\_name='DCKAP' | IFELSE(company\_name,company\_name,'INTEGRATOR') | "DCKAP" | |first\_name="Iron"
last\_name="Man"
| IFELSE(company\_name,company\_name,CONCATENATE(first\_name,last\_name),join\_chars=" ") | "Iron Man" | {% hint style="info" %} IFELSE supports additional capabilities to check conditions with the operators <, <=, >, >=, ==, != ***Examples:*** IFELSE(AGE>=18,"Yes","No") IFELSE(COUNT('ABC')>=COUNT(LSTRIP(" ABC")),UPPER(first\_name),"No Name") {% endhint %} ### **IGNORE\_ASCII** **DESCRIPTION** Returns string after removing Unicode characters. Returns source if the source is not a string. **SYNTAX** ``` IGNORE_ASCII(source*) ``` **PARAMETER** | **Name** | **Type** | **Description** | | -------- | -------- | ------------------------------------------------------------ | | source | string | Source field from which Unicode characters are to be removed | **EXAMPLE** | **Source Data** | **Expression** | **Output** | | --------------- | ------------------- | ---------- | | name='Škoda' | IGNORE\_ASCII(name) | 'koda' | ### **ISLOWER** **DESCRIPTION** For string, returns true if all the alphabets are lowercase(a-z) else returns false. Note: If source is not a string, return false. **SYNTAX** ``` ISLOWER(source*) ``` **PARAMETER** | **Name** | **Type** | **Description** | | -------- | -------- | ----------------------------------- | | source | string | Source field which is to be checked | **EXAMPLE** | **Source Data** | **Expression** | **Output** | | -------------------- | ----------------- | ---------- | | category="chocolate" | ISLOWER(category) | true | ### **ISUPPER** **DESCRIPTION** For string, returns true if all the alphabets are uppercase(A-Z) else returns false. If source is not a string, it returns false. **SYNTAX** ``` ISUPPER(source*) ``` **PARAMETER** | **Name** | **Type** | **Description** | | -------- | -------- | ----------------------------------- | | source | string | Source field which is to be checked | **EXAMPLE** | **Source Data** | **Expression** | **Output** | | -------------------- | ----------------- | ---------- | | category="chocolate" | ISUPPER(category) | false | ### **LJUST** **DESCRIPTION** Left aligns the string, using a specified character (space is default) as the fill character for making the length of the output string as the mentioned width. Note: Returns source, if source is not a string. **SYNTAX** ``` LJUST(source*,width*,fillchar) ``` **PARAMETER** | **Name** | **Type** | **Description** | | -------- | -------- | ---------------------------------------------------------------------------------------------- | | source | string | Source Field | | width | integer | Length of the output | | fillchar | string |String to make the text to the desired width and left justified
Default value:' '
| **EXAMPLES** | **Source Data** | **Expression** | **Output** | | --------------- | --------------------- | ------------ | | message='hello' | LJUST(message,10) | 'hello ' | | message='hello' | LJUST(message,10,'-') | 'hello-----' | ### **LOWER** **DESCRIPTION** Converts all uppercase characters in the string to lowercase **SYNTAX** ``` LOWER(source*) ``` **PARAMETER** | **Name** | **Type** | **Description** | | -------- | -------- | ------------------------------------------- | | source | string | Source field to be converted into lowercase | **EXAMPLES** | **Source Data** | **Expression** | **Output** | | --------------- | -------------- | ---------- | | gender='Male' | LOWER(gender) | 'male' | ### **LSTRIP** **DESCRIPTION** Returns a copy of string with leading prefix characters removed. If no prefix is passed, it removes leading spaces. Note: If source is not a string, returns source. **SYNTAX** ``` LSTRIP(source*,prefix) ``` **PARAMETER** | **Name** | **Type** | **Description** | | -------- | -------- | --------------------- | | source | string | Source field | | prefix | string | String to be stripped | **EXAMPLES** | **Source Data** | **Expression** | **Output** | | ------------------ | ---------------- | ---------- | | city=' Chennai' | LSTRIP(city) | 'Chennai' | | city='XXXXChennai' | LSTRIP(city,'X') | 'Chennai' | ### **MATH** **DESCRIPTION** Performs arithmetic operations and returns the result. Note: operator must be used only as keyword argument **SYNTAX** ``` MATH(args*,operator*) ``` **PARAMETER** | **Name** | **Type** | **Description** | | -------- | -------------------------------- | ---------------------------------------- | | args | int/float | Two Source fields to be given (operands) | | operator | '+','-','\*','/','\*\*','%','//' | Operation to be performed | **EXAMPLES** | **Source Data** | **Expression** | **Output** | | ---------------------------------- | ---------------------------------- | ---------- | | | MATH(10,3,operator='\*\*') | 1000 | |price=100,
quantity=5
| MATH(price,quantity,operator='\*') | 500 | ### **NOW** **DESCRIPTION** Current datetime will be returned based on timezone. **SYNTAX** ``` NOW() ``` **EXAMPLE** | **Source Data** | **Expression** | **Output** | | --------------- | -------------- | -------------------------- | | | NOW() | 2022-02-04 09:26:59.624294 | ### **PARTITION** **DESCRIPTION** Splits the string at the first occurrence of the separator and returns a tuple containing the part before the separator, separator, and the part after the separator. Note: If the input is not a string, returns string. **SYNTAX** ``` PARTITION(source*,separation*) ``` **PARAMETER** | **Name** | **Type** | **Description** | | ---------- | -------- | ---------------------------------------- | | source | string | Source Field | | separation | string | String at which partition has to be made | **EXAMPLES** | **Source Data** | **Expression** | **Output** | | ---------------------- | ---------------------- | --------------------- | | message= 'Hello world' | PARTITION(message,'l') | 'He', 'l', 'lo world' | ### **RAW\_VALUE** **DESCRIPTION** If consider\_source is set to True, returns value from source (if source exists and is not None) else returns value. **SYNTAX** ``` RAW_VALUE(source*,value*,consider_source) ``` **PARAMETER** | **Name** | **Type** | **Description** | | ---------------- | -------- | ------------------------------------------------------ | | source | any | Source field | | value | any | Value to be returned if source doesn’t exist | | consider\_source | boolean | Whether to take source value into consideration or not | **EXAMPLES** | **Source Data** | **Expression** | **Output** | | -------------------- | -------------------------------- | ------------ | | product='INTEGRATOR' | RAW\_VALUE(product,'DCKAP') | 'DCKAP' | | product='INTEGRATOR' | RAW\_VALUE(product,'DCKAP',True) | 'INTEGRATOR' | ### **REMOVE\_SPECIAL\_CHARACTERS** **DESCRIPTION** Removes special characters from the string. Selective special characters can be alone removed by using the parameter selections. Selective special characters can be alone retained by using the parameter exceptions. **SYNTAX** ``` REMOVE_SPECIAL_CHARACTERS(source*,selections,exceptions) ``` **PARAMETER** | **Name** | **Type** | **Description** | | ---------- | -------- | ---------------------------- | | source | string | Source field | | selections | string | Special characters to remove | | exceptions | string | Special characters to retain | **EXAMPLES** | **Source Data** | **Expression** | **Output** | | ----------------------------- | ------------------------------------------------- | ------------------- | | email='String to make the text to the desired width and right justified
Default value:' '
| **EXAMPLES** | **Source Data** | **Expression** | **Output** | | --------------- | --------------------- | ------------ | | message='hello' | RJUST(message,10) | ' hello' | | message='hello' | RJUST(message,10,'-') | '-----hello' | ### **ROUND** **DESCRIPTION** Rounds off the input number. **SYNTAX** ``` ROUND(source*,digits) ``` **PARAMETER** | **Name** | **Type** | **Description** | | -------- | -------- | ------------------------------------------------------------------------ | | source | float | Source field | | digits | integer | Number of values to be considered after decimal point while rounding off | **EXAMPLES** | **Source Data** | **Expression** | **Output** | | --------------- | -------------- | ---------- | | price=10.68 | ROUND(price,1) | 11.0 | ### **RSPLIT** **DESCRIPTION** Returns a list of strings by breaking the input string from the right side by the specified separator **SYNTAX** ``` RSPLIT(source*,char,maxsplit) ``` **PARAMETER** | **Name** | **Type** | **Description** | | -------- | -------- | ------------------------------------ | | source | string | Source field | | char | string | String at which split has to be made | | maxsplit | integer | Maximum number of split points | **EXAMPLES** | **Source Data** | **Expression** | **Output** | | ------------------- | ---------------------------- | -------------------- | | | RSPLIT('Great Day',char='a') | \['Gre', 't D', 'y'] | | message='Great Day' | RSPLIT(message,'a',1) | \['Great D', 'y'] | ### **RSTRIP** **DESCRIPTION** Returns string with trailing suffix characters removed. If no argument is passed, it removes trailing spaces. Note: If source is not a string, returns source **SYNTAX** ``` RSTRIP(source*,chars) ``` **PARAMETER** | **Name** | **Type** | **Description** | | -------- | -------- | ----------------------------------------------------- | | source | string | Source field | | chars | string |String to be stripped
Default Value: " "
| **EXAMPLES** | **Source Data** | **Expression** | **Output** | | ------------------ | ---------------- | ---------- | | city='Chennai ' | RSTRIP(city) | 'Chennai' | | city='ChennaiXXXX' | RSTRIP(city,'X') | 'Chennai' | ### **SEARCH** **DESCRIPTION** Gets the element at the specified index in list/string for valid index else returns default. Note: Returns source if the source is of datatype other than list/string/tuple. **SYNTAX** ``` SEARCH(source*,index*,default_value) ``` **PARAMETER** | **Name** | **Type** | **Description** | | -------------- | ----------- | -------------------------------- | | source | list/string | Source field | | index | integer | Index value to be checked | | default\_value | string | Default Value: "NOT\_IN\_SOURCE" | **EXAMPLES** | **Source Data** | **Expression** | **Output** | | --------------------- | ------------------------------------- | ------------------- | | item\_ids=\[10,20,30] | SEARCH(items\_ids,2) | 30 | | message='Hello' | SEARCH(message,6,'No data available') | 'No data available' | ### **SLICE** **DESCRIPTION** Slices values from string/array **SYNTAX** ``` SLICE(source*, step, start_index, stop_index) ``` **PARAMETER** | **Name** | **Type** | **Description** | | ------------ | -------- | ----------------------- | | source | string | Source field | | step | integer | Step value | | start\_index | integer | Starting index to slice | | stop\_index | integer | Ending index to slice | **EXAMPLES** | **Source Data** | **Expression** | **Output** | | ------------------------------- | ----------------------------- | ---------- | | item\_ids=\[10, 20, 30, 40, 50] | SLICE(item\_ids, 2,1,5) | \[20, 40] | | message= 'hello world' | SLICE(message,start\_index=5) | ' world' | ### **SPLIT** **DESCRIPTION** Returns a list of strings by breaking the input string from the left side by the specified separator Note: If source is not a string, returns source. **SYNTAX** ``` SPLIT(source*,char,maxsplit) ``` **PARAMETER** | **Name** | **Type** | **Description** | | -------- | -------- | ------------------------------------ | | source | string | Source field | | char | string | String at which split has to be made | | maxsplit | integer | Maximum number of split points | **EXAMPLES** | **Source Data** | **Expression** | **Output** | | ------------------- | -------------------- | ----------------- | | | SPLIT('Great Day') | \["Great", "Day"] | | message='Great Day' | SPLIT(message,'a',1) | \['Gre', 't Day'] | ### **STARTSWITH** **DESCRIPTION** Returns True if the string starts with the mentioned prefix in the specified index range else False. Note: If source is not a string, returns source. **SYNTAX** ``` STARTSWITH(source*,prefix,start,end) ``` **PARAMETER** | **Name** | **Type** | **Description** | | -------- | -------- | ------------------------------------------------------------ | | source | string | Source field | | prefix | string | Prefix string with which the check on source has to be made. | | start | integer | Start index of the string | | end | integer | End index of the string | **EXAMPLES** | **Source Data** | **Expression** | **Output** | | ------------------- | --------------------------- | ---------- | | message="Great Day" | STARTSWITH(message,"ay") | false | | message="Great Day" | STARTSWITH(message,"r",1,5) | true | ### **STRIP** **DESCRIPTION** Returns string with mentioned characters removed. If no argument is passed, it removes spaces. Note: Returns source if source is not a string. **SYNTAX** ``` STRIP(source*,chars) ``` **PARAMETER** | **Name** | **Type** | **Description** | | -------- | -------- | ----------------------------------------------------- | | source | string | Source field | | chars | string |String to be stripped
Default Value: " "
| **EXAMPLES** | **Source Data** | **Expression** | **Output** | | ------------------- | --------------- | ---------- | | city=' Chennai ' | STRIP(city) | 'Chennai' | | city='XChennaiXXXX' | STRIP(city,'X') | 'Chennai' | ### **TITLE** **DESCRIPTION** Returns title cased string (first character in upper case, rest in lower). Note: Returns source if source is not a string. **SYNTAX** ``` TITLE(source*) ``` **PARAMETER** | **Name** | **Type** | **Description** | | -------- | -------- | ------------------------------------------ | | source | string | Source field to be changed into title case | **EXAMPLES** | **Source Data** | **Expression** | **Output** | | --------------------- | -------------- | ------------- | | message='hello worlD' | TITLE(message) | 'Hello World' | ### **TO\_ARRAY** **DESCRIPTION** Returns an array containing the input strings **SYNTAX** ``` TO_ARRAY(*args) ``` **PARAMETER** | **Name** | **Type** | **Description** | | -------- | -------- | ------------------------------------------------------------- | | args | string |source fields (n>=1)
Data to be pushed into list
| **EXAMPLES** | **Source Data** | **Expression** | **Output** | | ------------------------------------------------ | --------------------------------- | --------------- | |first\_name='Iron'
last\_name='man'
| TO\_ARRAY(first\_name,last\_name) | \['Iron','man'] | ### **TO\_ASCII** **DESCRIPTION** Converts Unicode characters to ASCII. Note: Returns source, if source is not a string. **SYNTAX** ``` TO_ASCII(source) ``` **PARAMETER** | **Name** | **Type** | **Description** | | -------- | -------- | ---------------------- | | source | string | Source field to remove | **EXAMPLES** | **Source Data** | **Expression** | **Output** | | ------------------ | --------------------- | ---------- | | item\_name='Škoda' | TO\_ASCII(item\_name) | 'Skoda' | ### **TO\_NUMBER** **DESCRIPTION** Retrieves number in a string. Puts all the numbers in source as a list which can be indexed and accessed. Returns the value at zeroth index by default. Note: Returns " " if source is not a string. **SYNTAX** ``` TO_NUMBER(source*,index) ``` **PARAMETER** | **Name** | **Type** | **Description** | | -------- | -------- | ------------------------------------------------------ | | source | string | Source field | | index | integer |Index of the number need
Default Value: 0
| **EXAMPLES** | **Source Data** | **Expression** | **Output** | | ------------------------------------------------- | ------------------- | ---------- | | line1='14/3, 3055 GRAND AVE 75215, DALLAS, Texas' | TO\_NUMBER(line1) | "14/3" | | line1='14/3, 3055 GRAND AVE 75215, DALLAS, Texas' | TO\_NUMBER(line1,1) | "3055" | ### **TO\_STRING** **DESCRIPTION** Converts an array to string. **SYNTAX** ``` TO_STRING(source*,join_characters) ``` **PARAMETER** | **Name** | **Type** | **Description** | | ---------------- | -------- | ---------------------------------------------------------------------------------- | | source | list | Source field | | join\_characters | string |Join string to connect the elements in source array
Default Value=','
| **EXAMPLES** | **Source Data** | **Expression** | **Output** | | --------------------------------- | -------------------------- | --------------- | | alphabets=\["h","e","l","l","o" ] | TO\_STRING(alphabets) | "h,e,l,l,o" | | alphabets=\["h","e","l","l","o" ] | TO\_STRING(alphabets,'\*') | "h\*e\*l\*l\*o" | ### **TO\_TIMESTAMP** **DESCRIPTION** Converts the given datetime to timestamp. **SYNTAX** ``` TO_TIMESTAMP(source*, date_format, from_time_zone) ``` **PARAMETER** | **Name** | **Type** | **Description** | | ------------ | ---------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ | | source | Datetime object/String | Source field | | date\_format | String |Format of the date if source is a string
Ex: "%Y-%m-%d %H:%M:%S"
| | time\_zone | String |Default Value: "UTC"
| **EXAMPLE** | **Source Data** | **Expression** | **Output** | | ------------------------------------ | ------------------------------------------------- | ------------ | | created\_at='2021-05-27 01:30:00 PM' | TO\_TIMESTAMP(created\_at,'%Y-%m-%d %H:%M:%S %p') | 1622079000.0 | ### **TRUNCATE** **DESCRIPTION** Truncates count characters . If reverse is set to True, the characters from right are truncated. **SYNTAX** ``` TRUNCATE(source*,count,reverse) ``` **PARAMETER** | **Name** | **Type** | **Description** | | -------- | -------- | ------------------------------------------------------------------------------ | | source | string | Source Field | | count | integer | Number of characters to be truncated from right | | reverse | boolean |Set to True to truncate characters from left
Default Value: False
| **EXAMPLES** | **Source Data** | **Expression** | **Output** | | --------------- | ------------------------ | ---------- | | message='test' | TRUNCATE(message,2) | 'st' | | message='test' | TRUNCATE(message,2,True) | 'te' | ### **UPPER** **DESCRIPTION** Converts all lowercase characters in the string to uppercase. Note: Returns source if source is not a string. **SYNTAX** ``` UPPER(source*) ``` **PARAMETER** | **Name** | **Type** | **Description** | | -------- | -------- | --------------- | | source | string | Source field | **EXAMPLE** | **Source Data** | **Expression** | **Output** | | ------------------- | -------------- | ----------- | | message='Great Day' | UPPER(message) | 'GREAT DAY' | # Advanced Scheduler To schedule a Batch type Integration to run at any given time and frequency ## Advanced Scheduler The Advanced Scheduler in DCKAP Integrator is an easy-to-use Schedule Editor that enables easy configuration of the Schedules. With just a few mouse clicks and no complex syntax building or coding, the Pipes can be easily scheduled to run at any required time or time interval. Click on the "Schedule" link in the Pipe tile. The Schedule Editor will open. The following fields are present in the Schedule Editor: 1. Pipe Name: Name of the Integration pipe 2. Configured Schedules: The schedules that have been configured for this pipe 3. Cron Expression Builder Section: Where users can build and create different combinations of schedules for the pipe to run at. 4. Timezone: The pipe schedules are executed with respect to the timezone provided. By default, it is UTC. 5. Base Frequency levels: Basic interval levels for users to choose from 6. Frequency intervals: Specific interval or range values for the Integrations to run 7. Specific time or day intervals: Specific day or time values for the integrations to run ## Commonly Used Schedule Configurations with Examples Following are a few widely used schedule configurations and how they can be set up in DCKAP Integrator: 1. [Basic: Run every 5 minutes](https://docs.cloras.com/user-guide/projects/integrations/scheduler#1-basic-run-every-5-minutes) 2. [Specific Time: Run at 5 PM on Thursdays](https://docs.cloras.com/user-guide/projects/integrations/scheduler#2-specific-time-run-at-5-pm-on-thursdays) 3. [Multiple Times: Run at 9 AM, 1 PM and 5 PM every day](https://docs.cloras.com/user-guide/projects/integrations/scheduler#3-multiple-times-run-at-9-am-1-pm-and-5-pm-every-day) 4. [Range of values: Run every 5 minutes from Monday to Friday](https://docs.cloras.com/user-guide/projects/integrations/scheduler#4-range-of-values-run-every-5-minutes-from-monday-to-friday) 5. [Ranges with a step: Run every 15 minutes](https://docs.cloras.com/user-guide/projects/integrations/scheduler#5-ranges-with-a-step-run-every-15-minutes) 6. [Combination of numeric values and ranges: Run every hour outside office hours](https://docs.cloras.com/user-guide/projects/integrations/scheduler#6-combination-of-numeric-values-and-ranges-run-every-hour-outside-office-hours) 7. [Specific Day and Month: Run every hour on Mar 15](https://docs.cloras.com/user-guide/projects/integrations/scheduler#7-specific-day-and-month-run-every-hour-on-mar-15) ### 1.Basic: Run every 5 minutes
{
"envelope_namespace": "xmlns:urn='urn:enterprise.soap.sforce.com'",
"body": {
"urn:login": {
"urn:username": "user1@ddckap.com",
"urn:password": "user1@123"
}
}
}
| Iterable | Batch Processing | Output |
|---|---|---|
| [11,12,13,14,15] | No | Number of iterations: 5 Iteration 1: {'item': 11, 'index': 0} Iteration 2: {'item': 12, 'index': 1} Iteration 3: {'item': 13, 'index': 2} Iteration 4: {'item': 14, 'index': 3} Iteration 5: {'item': 15, 'index': 4} |
| [11,12,13,14,15] | Yes. Batch size: 3 | Number of iterations: 2 Iteration 1: {'item': [11,12,13], 'index': 0} |
| [{"name": "abc", "age": 20}, {"name": "def", "age": 25}, {"name": "ghi", "age": 30}, {"name": "jkl", "age": 35}, {"name": "mno", "age": 40}] | Yes. Batch size: 3 | Number of iterations: 2 Iteration 1: {'item': [{"name": "abc", "age": 20}, {"name": "def", "age": 25}, {"name": "ghi", "age": 30}], 'index': 0} Iteration 2: |
| {{1.response.products}} | Yes. Batch size: 100 | It will return each product data with index. |
Unable to make the get products API because of missing category ID.
Get products is failed. More details: {{1.response.error_message}}
Dear Sir,
This is to inform you that we received your ticket.
| {{key}} | {% endfor %}
| {{value}} | {% endfor %}
| Field Name | Description |
|---|---|
| Field Name | Description |
| Name | Enter a suitable name for your Credential details |
| Hostname | Enter your system URL in the format.
|
| Timezone | Select the target system server timezone. This will be used to fetch data based on the respective timezone. |
| Secure Keys | Provide secure keys depending on the system chosen |
| Field | Description | Example |
|---|---|---|
| Field | Description | Example |
| Label | A suitable display name for headers/params/body data | Content-Type |
| Key | Variable name at which the value is populated | Content-Type |
| Value | The actual value stored in the Key | application/json |
| Field | Description | Example |
|---|---|---|
| Field | Description | Example |
| Label | A suitable display name for headers/params/body data | Content-Type |
| Key | Variable name at which the value is populated | Content-Type |
| Value | The actual value stored in the Key | Support Content Types
|
| Sample Response from the TokenURL API | Format in which the system API Accepts token | Structure to enter in your API managerLabel: As you wishKey: Usually "Authorization". This might differ according to your system |
|---|---|---|
| Sample Response from the TokenURL API | Format in which the system API Accepts token | Structure to enter in your API manager |
| Value: | Label: As you wish | Key: Usually "Authorization". This might differ according to your system |
response = { "token":"TOKEN_VALUE_FROM_THE_SYSTEM" } | Bearer TOKEN_VALUE_FROM_THE_SYSTEM | Bearer DYNAMIC_TOKEN[token] |
| response = "TOKEN_VALUE_FROM_THE_SYSTEM" | Bearer TOKEN_VALUE_FROM_THE_SYSTEM | Bearer DYNAMIC_TOKEN |
response = { "authentication":{ "access_token":"TOKEN_VALUE_FROM_THE_SYSTEM" } } | Bearer TOKEN_VALUE_FROM_THE_SYSTEM | Bearer DYNAMIC_TOKEN[authentication][access_token] |
response = { "authentication":{ "access_token":"TOKEN_VALUE_FROM_THE_SYSTEM" } } | Basic TOKEN_VALUE_FROM_THE_SYSTEM | Basic DYNAMIC_TOKEN[authentication][access_token] |
| Field Name | Purpose/Value |
|---|---|
| Grant Type | Authorization Code |
| Client Authentication | Choose Send Client Credentials in Body when Client ID and Client Secret are to be passed in the body and Send as Basic Auth Header if they are to be passed as Basic Auth Header as per your System Specification. |
| Add Authorization Data to | Once the access token is generated, it is sent for all API calls to get authorized. If the authorization key has to be added in the header, choose Request Headers or vice versa. |
| Authorization Format | The format in which the token has to be sent for all API calls. Example 1: If your system returns token as
Example 2: If your system returns token as |
| Client ID | Client ID of your application |
| Client Secret | Client Secret of your application |
| Authorization URL | The absolute base URL for authorizing your System. Refer to your system documentation for Authorization Base URL. Ignore the query parameters part. This is the URL hit for requesting authorization code. |
| Token URL | The absolute token URL for requesting access token using the authorization code. Refer to your system documentation. |
| Scope | Scope of access you want to provide to DCKAP Integrator (Check the allowed scopes in your system documentation). When you want to grant access to more than one scope, use space to separate. Also, your access token will be usually short lived. To allow DCKAP Integrator to auto-generate the access token using refresh token without your intervention, kindly check your System’s documentation for the scope to generate access token along with refresh token. Example: |
| Redirect URL | Configure this redirect URL in your system’s application |
Reprocess: To reprocess the synchronization with the same data
View Detailed Logs:
Displays either
Console Logs
Logs Duration with records
Logs Duration Split-up on API Level
Logs Filter
Project Settings
| Parameters | Definition | Type |
|---|---|---|
| Parameters | Definition | Type |
| Systems | Platform to send and receive responses | DropDown |
| API | API endpoints of the selected system. Depending on the Platform chosen, the list of API’s in the dropdown changes. | DropDown |
| Response Variable | Stores API response Example: | Variable |
| Payload | Request Body. Information sent along with the API call | Variable (defined), JSON, Array |
| Files | Upload one or many files contents. Example:
| Variable (defined), JSON, Array |
| Headers | Request Headers Example:
| Variable (defined), JSON |
| URL Arguments | Arguments used in a dynamic URL. API URL: URL Argument: Formatted URL: In this case, | Variable (defined), JSON |
| Parameters | Request parameters API URL: Query Params: Formatted URL: Here, | Variable (defined), JSON |
| Override time | To override the timeout at Flow level. Read more below. |
{
"envelope_namespace": "xmlns:urn='urn:enterprise.soap.sforce.com'",
"body": {
"urn:login": {
"urn:username": "user1@ddckap.com",
"urn:password": "user1@123"
}
}
}
Variable to be incremented.
Example: line\_number, total\_records
Data to be formatted.
Example: orders\_summary, \["test", "array", "data"], {'data': orders\_summary}
Available Options
Types of Exception
Example: Exception, ValueError
Choose from drop-down:
Choose from drop-down:
Choose from drop-down:
a) if there is dynamic data, pass it as a dictionary here
b) else leave it blank
| Dictionary | | Message || {{key}} | {% endfor %}
| {{value}} | {% endfor %}
Value or data assigned to a variable
Examples:
Hello WorldNon String:
0\[1, 2, 3, 4, 5]{ "customer\_id": 123}Type of data to be modified
Action to modify existing data
Pop:
Remove
Deep Copy
To learn more, find the use cases below
| String | #### Use Case 1 - Dictionary(Action: Assign) ``` Modify variable customer_info['customer_id'] with value custom_attribute['value'] ``` * Assume the variable customer\_info is a dictionary/JSON and contains the value `{“entity_id”:12, “name”: “Alice Blue”}` * To add more keys with values to the dictionary, the modifier handler is used * The below step adds `customer_id` to the dictionary * After processing, the `customer_info` variable contains the value `{“entity_id”:12, “name”: “Alice Blue”, “customer_id”: custom_attribute[‘value’]}` #### Use Case 2 - **Array(Action: Append)** ``` Modify variable customer_info['customer_id'] with value custom_attribute['value'] ``` * Assume the variable customer\_info is an array/list and contains the value `[{“entity_id: 1}, {“entity_id: 2}, {“entity_id: 3}]` * To add an item to the array, the Modify Variable handler is used * The below step adds `customer_id` to the Array * After processing, the `customer_info` variable contains the value `[{“entity_id: 1}, {“entity_id: 2}, {“entity_id: 3}, {"custom_attribute['value']}]` ### Mapping Provides the ability to get mappings from the user and format data between two different system APIs. {% hint style="info" %} This adds a new mapping card in the pipes section to get mappings in the pipe. The Modifiers will also be provided in the same section. {% endhint %} Based on the Mapping configuration, the destination payload will be prepared from the source data.  #### Available Options | *Parameters* | *Definition* | *Type* | | ------------ | -------------------------------------------------------------------------------------------------------------- | ------------ | | Display name | Mapping name displayed in the pipe | Alphanumeric | | Source | API used to request data from the Source system | DropDown | | Destination | API used to send data to the Destination system | DropDown | | Variable | Stores mapped data | Variable | | Source Data | Source data that will be formatted and sent to destination API as per the mapping configuration | JSON, Array | | Ignore Keys | Keys that should be ignored by the system, while processing data in the mapping structure defined by the user. | Alphanumeric | #### **Example** ``` Prepare mapping with name Customers Information from source Get Customers- Magento 2 to destination Create Customers - Epicor P21 Custom Server ``` Creates a mapping node in the pipe to provide the mapping of data between the specified source and destination APIs. #### **Use Case - Ignore Keys** ``` { "customer": [ { "name":"alice", "address": { "street": "Jarvis St.", "door_number": "5A" } }, { "name":"bob", "address": { "street": "Marvel St.", "door_number": "7D" } } ] } ``` Assume the field `street` is mapped from source to destination system and the path generated for this field will be `customer/address/street`. During Mapping, when the user sends this customer data(Parameter: Data) inside a loop, one entry at a time, to get the `street address`, the resulting path generated will be `address/street`. In this case, the user should mention the parent keys to be ignored. In this case `customer`. If multiple keys need to be ignored, then the user should mention them as comma-separated values. {% hint style="info" %} When an API or system is changed in the Flow, then the previously configured mapping becomes unstable. So users will be alerted if the mapping should be retained or if it should be deleted during the save and merge process. If the mapping is retained, the errors will be highlighted. {% endhint %} ### If, Else If & Else To define and check for decision-making conditions inside the Flow. Condition parameters are defined for the `If` and `Else If` handlers. If this condition is satisfied, the children of `If` will be executed. Otherwise, the children of `Else` will be executed.  #### Available Options | *Parameters* | *Definition* | *Type* | | ------------ | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ------ | | Condition |Condition that needs to be satisfied for the children-statements to be executed
Example: admin\_details\['status']
If the value is true, the children will be executed
Data to be iterated/looped
Example: Sales\_rep\_data\['data']
The loop will keep running until there is an item in the data
| Array | | Key |Variable assigned to the loop counter
Example: key, item
Displayed in the progress bar of pipes
Examples:
ID of the entry. Useful in identifying if the entities succeeded or failed.
Example: item\[‘itemCode’], mapped\_orders\['hdr']\['webReferenceNumber']
Content that needs to be displayed
Example:
Dynamic ⇒ Variable: order\_info, line\_no
Static ⇒ HelloWorld, 12345
To change the format of the output time
Example: Month-Day-Year HH:MM:SS
| DropDown | ### Credential Keys Retrieves any credential details from the respective project. (Example: Name, System, Hostname)  #### Available Options | *Parameters* | *Definition* | *Type* | | ------------ | -------------------------------------------------------------------------------------------------------------------------------------------------------- | ------------ | | Value |Data that were assigned while setting up the credentials of the system
Value: Name, System, Hostname
String/Non-string
Actual date-time in UTC format or variable name containing the date-time in UTC format
| DropDown | | Action |Advance/Recede
To add or subtract hours and minutes
| DropDown | | Hours and Minutes | Value of hours and minutes to be added or subtracted to the given time | Numeric | ### Time Converter Converts Time from one format to the other (12Hr clock to 24Hr clock and vice versa). | *Parameters* | *Definition* | *Type* | | ------------- | ---------------------------- | ---------------------- | | Convert | The conversion time format | DropDown | | Variable | Variable to store the output | Alphanumeric | | Enter Hours | Hours value | Numeric (1-12 or 1-24) | | Enter Minutes | Minutes value | Numeric (1-60) | | Enter Seconds | Seconds value | Numeric (1-60) | | Meridiem | Choose AM or PM | DropDown | \ **Time Zone converter** This handler serves two purposes: 1. Converts datetime (object/string) from a time zone to another timezone. 2. Generates a timestamp for a given datetime (object/string). [Click here to Learn more about configuring the Timezone Converter and examples.](/developers/flows/timezone-converter-handler) ### **Data Type converter** Converts data from one data type to another (string to integer or integer to string). | *Parameters* | *Definition* | *Type* | | ------------ | ----------------------------------------------------------------------------- | ------------ | | Variable | Stores the output | Alphanumeric | | Value | Value or variable whose data type has to be converted | Alphanumeric | | Data type |Data type that the value has to be converted to
String/ Integer
| DropDown | ### **Current DateTime** Converts current time to the timezone of selected system. **Available options** | *Parameters* | *Definition* | *Type* | | ------------ | ------------------------------------------ | ------------ | | Variable | Stores the output | Alphanumeric | | System | Current time is converted to this timezone | Alphanumeric | ### Pagination To send required paginated data for API calls. **Available options** | *Parameters* | *Definition* | *Type* | | ----------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------ | ------------ | | Variable |Output from the handler
(Part of the data (from input data) as per the number of records mentioned)b
| Alphanumeric | | Response Data |The input to the handler i.e., the data which needs to divided into smaller arrays.
Example: response data will be the output from an API call
| Alphanumeric | | Number of records | Number of records the user needs in the output every time | Numeric | ### While Loop Loop till specified condition is true. **Available options** | *Parameters* | *Definition* | *Type* | | ------------ | ------------------------------------- | ------ | | Condition | Loop till specified condition is true | JSON | ### Break To break a loop. ### SFTP Writer To create files in a remote location using SFTP connection. Prerequisite: Add SFTP Credentials| Parameters | Definition | Type |
|---|---|---|
| File | Existing remote folder location followed by file name Example: /tmp/test/file1.csv | String |
| Data | Name of variable containing the data to be written | Alphanumeric |
| Character Set | Encoding character set for the file content | Drop Down |
| Parameters | Definition | Type |
|---|---|---|
| File | Existing remote folder location followed by file name Example: /tmp/test/file1.csv | String |
| Variable | Name of variable to store the data read from the remote location | Alphanumeric |
| Handle CSV Data | If yes, provides a list for easy looping and if no, provides raw bytes. | DropDown |
| Character Set | Decoding character set for the file content | Drop Down |
| Parameters | Definition | Type |
|---|---|---|
| File Path | File path where the new file to be read exists. Example: /testing/ | String |
| File name | Name of the file to be created with extension Example: file1.txt | String |
| Variable | Name of variable to store the data read from the remote location | Alphanumeric |
| Handle CSV Data | If yes, provides a list for easy looping and if no, provides raw bytes. | DropDown |
| Character Set | Decoding character set for the file content | Drop Down |
| Parameters | Definition | Type |
|---|---|---|
| File Path | Existing file path where the new file is to be created Example: /testing/ | String |
| File name | Name of the file to be created with extension Example: file1.txt | String |
| Data | Name of variable containing the data to be written | Alphanumeric |
| Character Set | Encoding character set for the file content | Drop Down |
Location from which the list of files and folders are to be listed
Example: /testing/
| String | | Variable | Name of variable to store the list of files and folders from the remote location | Alphanumeric | #### Delete File | Parameters | Definition | Type | | ----------------------- | ---------------------------------------------------------------------------------- | ------------ | | What do you want to do? | Delete File | DropDown | | Path |Location from which file is to be deleted
Example: /testing/
| String | | Variable | Name of variable to know the status of the action - whether file is deleted or not | Alphanumeric | | File Name |Name of the file to be deleted
Example: file1.txt
| String | #### Rename File | Parameters | Definition | Type | | ----------------------- | ---------------------------------------------------------------------------------- | ------------ | | What do you want to do? | Rename File | DropDown | | Path | Location in which the file to be renamed exists Example: /testing/ | String | | Variable | Name of variable to know the status of the action - whether file is renamed or not | Alphanumeric | | File Name |Name of the file to be renamed
Example: old.txt
| String | | New File Name | New name of the file Example: new\.txt | String | #### Move File | Parameters | Definition | Type | | ----------------------- | -------------------------------------------------------------------------------------------------------------------- | ------------ | | What do you want to do? | Move File | DropDown | | Path |Location in which the file to be moved exists
Example: /testing/
| String | | Destination Path |Location to which the file has to be moved
Example: /testing/folder/
| String | | Variable | Name of variable to know the status of the action - whether file is moved from the source path to destination or not | Alphanumeric | | File Name |Name of the file to be moved
Example: file.txt
| String | #### Change Permission | Parameters | Definition | Type | | ----------------------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------- | ------------ | | What do you want to do? | Change Permission | DropDown | | Path |Location in which the file whose permission is to be changed exists
Example: /testing/
| String | | Variable | Name of variable to know the status of the action - whether file’s permission is changed or not | Alphanumeric | | File Name | Name of the file whose permission is to be changed Example: file1.txt | String | | Desired Permission | The desired permission is given as a three digit number - by default, it is 644 meaning read and write for the owner, read for groups and read for the public. | String | #### Create Directory | Parameters | Definition | Type | | ----------------------- | --------------------------------------------------------------------------------------- | ------------ | | What do you want to do? | Create Directory | DropDown | | Path |Location in which directory has to be created
Example: /testing/
| String | | Variable | Name of variable to know the status of the action - whether directory is created or not | Alphanumeric | | Directory Name | Name of the directory to be created | String | ### SFTP Advanced Lists files, deletes, renames, moves & changes permission for file and creates directory in the remote location using the established SFTP connection {% hint style="success" %} **Note:** For root folder, use `/` in the path field {% endhint %} #### List files | Parameters | Definition | Type | | ----------------------- | --------------------------------------------------------------------------------------------------- | ------------ | | What do you want to do? | Choose the action to be performed as list files. By default, the handler lists files. | DropDown | | Path |Location from which the list of files and folders are to be listed
Example: /testing/
| String | | Variable | Name of variable to store the list of files and folders from the remote location | Alphanumeric | #### Delete File | Parameters | Definition | Type | | ----------------------- | ---------------------------------------------------------------------------------- | ------------ | | What do you want to do? | Delete File | DropDown | | Path |Location from which file is to be deleted
Example: /testing/
| String | | Variable | Name of variable to know the status of the action - whether file is deleted or not | Alphanumeric | | File Name |Name of the file to be deleted
Example: file1.txt
| String | #### Rename File | Parameters | Definition | Type | | ----------------------- | ---------------------------------------------------------------------------------- | ------------ | | What do you want to do? | Rename File | DropDown | | Path | Location in which the file to be renamed exists Example: /testing/ | String | | Variable | Name of variable to know the status of the action - whether file is renamed or not | Alphanumeric | | File Name |Name of the file to be renamed
Example: old.txt
| String | | New File Name | New name of the file Example: new\.txt | String | #### Move File | Parameters | Definition | Type | | ----------------------- | -------------------------------------------------------------------------------------------------------------------- | ------------ | | What do you want to do? | Move File | DropDown | | Path |Location in which the file to be moved exists
Example: /testing/
| String | | Destination Path |Location to which the file has to be moved
Example: /testing/folder/
| String | | Variable | Name of variable to know the status of the action - whether file is moved from the source path to destination or not | Alphanumeric | | File Name |Name of the file to be moved
Example: file.txt
| String | #### Change Permission | Parameters | Definition | Type | | ----------------------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------- | ------------ | | What do you want to do? | Change Permission | DropDown | | Path |Location in which the file whose permission is to be changed exists
Example: /testing/
| String | | Variable | Name of variable to know the status of the action - whether file’s permission is changed or not | Alphanumeric | | File Name | Name of the file whose permission is to be changed Example: file1.txt | String | | Desired Permission | The desired permission is given as a three digit number - by default, it is 644 meaning read and write for the owner, read for groups and read for the public. | String | #### Create Directory | Parameters | Definition | Type | | ----------------------- | --------------------------------------------------------------------------------------- | ------------ | | What do you want to do? | Create Directory | DropDown | | Path |Location in which directory has to be created
Example: /testing/
| String | | Variable | Name of variable to know the status of the action - whether directory is created or not | Alphanumeric | | Directory Name | Name of the directory to be created | String | ### Internal Dynamic Call To trigger a dynamic pipe from another pipe.  a) Dynamic Pipe: Choose the dynamic pipe to trigger from the dropdown list b) Payload: The payload field is used to send data to the Dynamic Pipe that is being called. This data will be used in the Dynamic pipe to process the associated Flow. c) Response Variable: Once the dynamic pipe is triggered from this handler, a variable will be sent back from the dynamic pipe. The 'Response variable' field will be used to store that response. # Add New Flow This section lists the steps that are required to create a new Flow. To add a new Flow, click on the **Add New** button.(i) For String Input:
Select String under the “Enter Date Time” field and give your input.
Enter Input Date Format for String Input (Refer to the table below).
Choose From Timezone and To Timezone from the drop-down list.
(ii) For date-time input:
Select Non-String under the “Enter Date Time” field and give your input.
Choose From Timezone and To Timezone from the drop-down list.
| | Output | **2. String Output** | | ------ | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ | | Input |(i) For String Input:
Select String under the “Enter Date Time” field and give your input.
Enter Input Date Format for String Input by referring to the table below.
Enter Output Date Format for String Output by referring to the table below.
Choose From Timezone and To Timezone from the drop-down list.
(ii) For date-time input:
Select Non-String under the “Enter Date Time” field and give your input.
Choose From Timezone and To Timezone from the drop-down list.
| ## 2. Timestamp Generator Generate timestamps from a date inputted previously (MM/DD/YYYY) to the entered Date and Time. **(i) For String Input** * Select String under the “Enter Date Time” field and give your input * Enter Input Date Format for String Input by referring to the table below * Choose the input time zone from the drop-down in the “From timezone” field. **(ii) For date-time input:** * Select Non-String under the “Enter Date Time” field and give your input. * Choose the input time zone from the drop-down in the “From timezone” field. * Consider this date for example, Saturday, 27 January 2018, 10:30:00.012345 AM +0530 The following formats are supported**:** | Format | Value | Description | | ------ | -------- | ------------------------------------------ | | %d | 27 | numerical representation of day | | %a | Sat | short alphabetical representation of day | | %A | Saturday | alphabetical representation of day | | %m | 01 | numerical representation of month | | %b | Jan | short alphabetical representation of month | | %B | January | alphabetical representation of month | | %y | 18 | short representation of year | | %Y | 2018 | numerical representation of year | | %H | 10 | hour | | %M | 30 | minute | | %f | 012345 | microseconds | | %p | AM | meridiem | | %z | +0530 | timezone offset | **Examples for reference** | Input | Format | | ------------------------------- | ------------------------ | | 2021-05-27 01:30:00 PM | %Y-%m-%d %H:%M:%S %p | | 2021-05-12T09:46:47-0400 | %Y-%m-%dT%H:%M:%S%z | | Sat, 27 Jan 2018 17:16:55 +0000 | %a, %d %b %Y %H:%M:%S %z | | 2018-01-27T13:34:25.518993+0530 | %Y-%m-%dT%H:%M:%S.%f%z | ## Modifier: Datetime to Timestamp Modifier This Modifier is used to provide the timestamp starting from \
{% endstep %}
{% step %}
### Add a New Workflow
Click on the Add Workflow button