Action - Transform
- OSS/BSS Answers
- App Model - Organization Management
- App Model - Communication Apps Answers
- License Model - Organization Management
-
License Model - CPaaS Solution Answers
Phone System - Admin Guide Phone System - End-user Guide Mobile App Desktop App Web Phone Auto Attendant - Admin Guide Developer Hub - Admin Guide Microsoft Teams Operator Connect - Admin Guide Microsoft Teams Direct Routing - Admin Guide Contact Center - Supervisor Guide Contact Center - Agent Guide Omni-Channel SIP Trunk CPaaS - SIP Trunk CPaaS Fax Contact Dashboard Campaign File Explorer
- Integrations Answers
- Updated Regulations
- Ideas Portal
Table of Contents
You can use the Transform action to pivot your data into a new index. By transforming and summarizing your data, it becomes possible to visualize and analyze it in alternative ways.
Here is the list of available transform actions:
1. Generate Random UUID
This action is used for generating a random UUID to use as input for the later actions.
In order to generate a random UUID, please follow the steps below:
- Click the (+) icon, choose Transform action
- In the Transform function section, select Generate Random UUID
- Add
![](https://d2x3xhvgiqkx42.cloudfront.net/c94ab348-5fb1-4c1d-89b1-fa79e3e916d0/81ec6e6f-2b1b-45dc-9193-b23c4a10d966/2022/11/03/0412ac5b-b3f6-4e17-90cf-fd68c10d5741/58af3a4f-40cc-49a6-8207-e4d2ad3a24d2.gif)
2. Get Current Timestamp
This action is used for getting the current timestamp when this action is executed.
In order to get the current timestamp, please follow the steps below:
- Click the (+) icon, choose Transform action
- In the Transform function section, select Get Current Timestamp
- Add
![](https://d2x3xhvgiqkx42.cloudfront.net/c94ab348-5fb1-4c1d-89b1-fa79e3e916d0/81ec6e6f-2b1b-45dc-9193-b23c4a10d966/2022/11/03/3b2a0136-8d13-41da-aa8f-4a2532da1740/a198f321-9314-4927-87da-8a5141ea64fa.gif)
3. Format Datetime
This action is used for defining how date and time values should be read and written from the previous timestamp output.
-
REQUIRED INPUTS
- Timestamp
-
OUTPUT
- Formatted Datetime (String)
In order to format the date & time, please follow the steps below:
- Click the (+) icon, choose Transform action
- At the Transform function section, select Format Datetime
- Input the parameters:
- Timestamp: Output from the previous actions
- Format: (e.g yyyy-MM-dd'T'HH:mm:ss)
- Time zone: (e.g +08:00)
- Add
![](https://d2x3xhvgiqkx42.cloudfront.net/c94ab348-5fb1-4c1d-89b1-fa79e3e916d0/81ec6e6f-2b1b-45dc-9193-b23c4a10d966/2022/07/20/0024aa30-1807-4894-a1cd-228c49899d86/262fbca0-c843-444f-bea6-b082c309f4f3.gif)
4. Format Number to E164
This action is used for formatting a phone number to E164 standard (eg. +6591234567) in case the caller number is not in E164 format.
-
REQUIRED INPUTS
- Phone Number to Format
- Default Country
-
OUTPUT
- Formatted Number
In order to format the number to E164, please follow the steps below:
- Click the (+) icon, choose Transform action
- At the Transform function section, select Format Number to E164
- Input the parameters:
- Phone number to Format: Output from the previous actions (e.g Caller ID)
- Default Country: (e.g SG - Singapore)
- Add
![](https://d2x3xhvgiqkx42.cloudfront.net/c94ab348-5fb1-4c1d-89b1-fa79e3e916d0/81ec6e6f-2b1b-45dc-9193-b23c4a10d966/2022/07/20/767673bd-0b72-4bce-a1c1-7851182e2c63/f62ccf4c-5d01-4625-903b-1406222ebb6e.gif)
5. Get Country Code
This action is used for getting the phone number's country code.
-
REQUIRED INPUTS
- Phone Number: Phone number in E.164 format (eg. +6591234567)
-
OUTPUT
- Country Code: Country code of +6581234567 is "65"
In order to get phone number properties, please follow the steps below:
- Click the (+) icon, choose Transform action
- At the Transform function section, select Get Country Code
- Input the parameters:
- E164 Phone Number: Output of the previous actions
- Add
![](https://d2x3xhvgiqkx42.cloudfront.net/c94ab348-5fb1-4c1d-89b1-fa79e3e916d0/81ec6e6f-2b1b-45dc-9193-b23c4a10d966/2022/07/20/6df0456c-a035-4511-8652-570d7412f7c1/dda009c0-123b-4419-af49-055346770235.gif)
6. Get Region Code
This action is used for getting the phone number's region code.
-
REQUIRED INPUTS
- Phone Number: Phone number in E.164 format (eg. +6591234567)
-
OUTPUT
- Region Code: Region code of +6581234567 is "SG"
In order to get phone number properties, please follow the steps below:
- Click the (+) icon, choose Transform action
- At the Transform function section, select Get Region Code
- Input the parameters:
- E164 Phone Number: Output of the previous actions
- Add
![](https://d2x3xhvgiqkx42.cloudfront.net/c94ab348-5fb1-4c1d-89b1-fa79e3e916d0/81ec6e6f-2b1b-45dc-9193-b23c4a10d966/2022/07/20/3acac653-da0b-411b-ad42-46c531b42fe3/321c2d59-c05f-4526-b6f0-17a36d8f69b5.gif)
7. Get Number Type
This action is used for getting the phone number type.
-
REQUIRED INPUTS
- Phone Number: Phone number in E.164 format (eg. +6591234567)
-
OUTPUT
- Number Type: Fixed line, mobile, toll-free, etc
In order to get phone number properties, please follow the steps below:
- Click the (+) icon, choose Transform action
- At the Transform function section, select Get Number Type
- Input the parameters:
- E164 Phone Number: Output of the previous actions
- Add
![](https://d2x3xhvgiqkx42.cloudfront.net/c94ab348-5fb1-4c1d-89b1-fa79e3e916d0/81ec6e6f-2b1b-45dc-9193-b23c4a10d966/2022/07/20/151e0598-4009-44fb-83bc-5f3791826a4d/af479f85-fb08-487b-ac19-a9c1a4d2bdbd.gif)
8. Spell
This action is used to make a text compatible with TTS spelling. This action will usually be added before playing a message to confirm the caller's number. Otherwise, the system will spell the number in units.
-
REQUIRED INPUTS
- Text to spell
-
OUTPUT
- Spelled Text
In order to configure the spell action, please follow the steps below:
- Click the (+) icon, choose Transform action
- At the Transform function section, select Spell
- Input the parameters:
- Text to Spell: Type your text or use the output of the previous actions
- Add
![](https://d2x3xhvgiqkx42.cloudfront.net/c94ab348-5fb1-4c1d-89b1-fa79e3e916d0/81ec6e6f-2b1b-45dc-9193-b23c4a10d966/2022/07/20/9d16c75e-5866-4388-aadd-9bff45bccc60/b37af9bc-497f-4238-b156-ed16e388347a.gif)
9. String Length
This action is used for calculating the length of the string of text or numbers to check the number of characters it contains.
-
REQUIRED INPUTS
- String to get Length
-
OUTPUT
- Number of characters (String)
In order to get the string length, please follow the steps below:
- Click the (+) icon, choose Transform action
- In the Transform function section, select String Length
- Input the parameters:
- String to get Length
- Add
![](https://d2x3xhvgiqkx42.cloudfront.net/c94ab348-5fb1-4c1d-89b1-fa79e3e916d0/81ec6e6f-2b1b-45dc-9193-b23c4a10d966/2022/07/20/e507435b-bac7-4ee7-a345-e2e1cac8a683/bc68cae9-3eeb-41ea-a2b1-e81c83056ff3.gif)
10. Check if String Matches A Regex Pattern
This action is used for checking if a number is of a certain pattern (frequently used for checking whether a callback number is valid or not).
-
REQUIRED INPUTS
- String to check
- Regex
-
OUTPUT
- True/False (Boolean)
In order to check if the string matches a regex pattern, please follow the steps below:
- Click the (+) icon, choose Transform action
- In the Transform function section, select Check if String Matches A Regex Pattern
- Input the parameters:
- String To Check
- Regex
- Add
![](https://d2x3xhvgiqkx42.cloudfront.net/c94ab348-5fb1-4c1d-89b1-fa79e3e916d0/81ec6e6f-2b1b-45dc-9193-b23c4a10d966/2022/11/04/1d65b153-f81f-4d61-ba4d-c4e15fd33bbb/9e8b4230-57e4-4127-95ab-32e528cd7e14.gif)
11. Replace String
This action is used for replacing a section of a text, used when wanting to personalize a message (sample: Original String: Hello {name}, replace String {name} with Tom => Hello Tom)
-
REQUIRED INPUTS
- Original String
- Old Term
- New Term
-
OUTPUT
- The new string
In order to replace a string, please follow the steps below:
- Click the (+) icon, choose Transform action
- In the Transform function section, select Replace String
- Input the parameters:
- Original String
- Old Term
- New Term
- Add
![](https://d2x3xhvgiqkx42.cloudfront.net/c94ab348-5fb1-4c1d-89b1-fa79e3e916d0/81ec6e6f-2b1b-45dc-9193-b23c4a10d966/2022/11/04/f56c3563-9802-45b3-b977-37c3b4fd955b/af1e895e-8dc4-47d1-b954-a48c710d9878.gif)
12. Add Two Numbers
The digits are stored in reverse order, and each of their nodes contains a single digit. Add the two numbers and return the sum as a linked list.
-
REQUIRED INPUTS
- First Number
- Second Number
-
OUTPUT
- The sum of the first and second number
In order to configure this, please follow the steps below:
- Click the (+) icon, choose Transform action
- In the Transform function section, select Add Two Numbers
- Input the parameters:
- First Number
- Second Number
- Add
![](https://d2x3xhvgiqkx42.cloudfront.net/c94ab348-5fb1-4c1d-89b1-fa79e3e916d0/81ec6e6f-2b1b-45dc-9193-b23c4a10d966/2022/11/04/c63b8d8c-94e4-46dc-9ecd-406e56b1978a/353ff634-91dd-4e8a-96f1-73a66ce4e559.gif)