# Functions ## Introduction DBSync Cloud Workflow Functions are reusable components that give you power to execute specific additional operations within your integration processes. They help streamline workflows by reducing redundancy and enabling efficient data processing. Functions can be leveraged to transform, manipulate, and validate data as it moves between different applications. ## User-Defined Functions User-Defined Functions (UDFs) allow you to create custom functions as per your specific integration requirement. Unlike built-in functions, UDFs provide flexibility to define your own logic and processing rules. All User Defined Functions begin with the `//@UserDefined` header so DBSync can recognize them. This ensures they are populated in the UserDefined list on the **Mapping** page. > Functions are code sensitive. When you are using Functions, the string objects must be enclosed within single quotes. | Refer [Standard Functions](https://docs.mydbsync.com/cloud-workflow/create-your-workflow/flow-builder/standard-functions) to learn more about the inbuilt functions. | | -------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ## Key Features * **Customization** – Write your own functions to handle specific data operations. * **Reusability** – Create once and use across multiple workflows. * **Scalability** – Manage complex logic for handling large-scale data transformations. * **Integration Support** – Process data from both cloud and on-premise applications. ## Create User-Defined Function All User Defined Functions must be preceded by `//@UserDefined` for DBSync to recognize them as User Defined Function. When done so, they are populated in the UserDefined list of the **Mapping** page (Automated Task → Flows → Transform and Write (Configure) → Maps). 1. To access User Defined Functions, click ![](data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABcAAAARCAYAAAA2cze9AAABHklEQVR4AeySu0oDQRSGf2anXJZcLM0LxFZ9A8VSsRERDXkBERtFRCF4QRAREaxE8dqIlpI8QZI2eYGkzWWXbLGwC5vdamZgYDgkZQ588DPMfBzOHBZLFYZh3Gq343qjSaLT6UoWERmk8n0f75/feH55JfFfrUkWERU55xxz+TyymQyJXC4rjFJS5LZt4/BgH1cXFRKbG+uSUkRFLo6nkxR5OvPbu3scn5yS+Pn903ajyKMoQq/fx9B1SQwGQ7M8nfnO9hbKpT0Sa6srZnm6LQvFIpaXFkkUCvNmebL+GCW77iZjoRAEgVnueR4ur29wlHwohbePL7OcMQbOLVDLsvRvlG1xHAeV8zM8PT6QKJd2tf0ocu2NCQ5ncu3wxgAAAP//IzyoMwAAAAZJREFUAwDuuTzWVg6W5AAAAABJRU5ErkJggg==) from the top panel. This opens the left menu panel. 2. Click ![](data:image/jpeg;base64,/9j/4AAQSkZJRgABAQAAAQABAAD/4gHYSUNDX1BST0ZJTEUAAQEAAAHIAAAAAAQwAABtbnRyUkdCIFhZWiAH4AABAAEAAAAAAABhY3NwAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAQAA9tYAAQAAAADTLQAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAlkZXNjAAAA8AAAACRyWFlaAAABFAAAABRnWFlaAAABKAAAABRiWFlaAAABPAAAABR3dHB0AAABUAAAABRyVFJDAAABZAAAAChnVFJDAAABZAAAAChiVFJDAAABZAAAAChjcHJ0AAABjAAAADxtbHVjAAAAAAAAAAEAAAAMZW5VUwAAAAgAAAAcAHMAUgBHAEJYWVogAAAAAAAAb6IAADj1AAADkFhZWiAAAAAAAABimQAAt4UAABjaWFlaIAAAAAAAACSgAAAPhAAAts9YWVogAAAAAAAA9tYAAQAAAADTLXBhcmEAAAAAAAQAAAACZmYAAPKnAAANWQAAE9AAAApbAAAAAAAAAABtbHVjAAAAAAAAAAEAAAAMZW5VUwAAACAAAAAcAEcAbwBvAGcAbABlACAASQBuAGMALgAgADIAMAAxADb/2wBDAAMCAgICAgMCAgIDAwMDBAYEBAQEBAgGBgUGCQgKCgkICQkKDA8MCgsOCwkJDRENDg8QEBEQCgwSExIQEw8QEBD/2wBDAQMDAwQDBAgEBAgQCwkLEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBD/wAARCAAZABwDASIAAhEBAxEB/8QAGQAAAgMBAAAAAAAAAAAAAAAAAAgEBQYH/8QAKBAAAQMEAQMEAgMAAAAAAAAAAQIDBAAFBhEHEiFBCBMUMSQyNEKB/8QAGAEAAwEBAAAAAAAAAAAAAAAAAAMEBQj/xAAjEQABBAEEAQUAAAAAAAAAAAABAAIDETEEBRNBUSFhcdHw/9oADAMBAAIRAxEAPwDj9bPDuIc9zTLbZhkCxPwbhd2FS4puLTkdtbASVe6CU7KCB2UAQavPTlI4wjcp2t3lZoqtYV+OpzRjIk7Htl8eW9/5vW+26Zqc3yRhmR8q8yclPMOvWmyi3YwuKfxS1JUQ18ceO4Tvzsndbs0vF10T9D5tc97PszNfHzSO9A4AgZAySfAoGvdJVkmM33Ebs9ZMhtkmDLZP6PtKb60bOlp6gOpCtbCh2I7iqumv5jXHi+nixQOenGpHIxSFY+I2vnMxNj+Yr6Kdb2Pvev7BRpUKInl1g9KLdtAzQytEbrDgDRyL6P7CK17/ACxnUrAF8aSr0t+xrlNyi26OtwFA0hAWe/QNAhP0PFZCimkBwoqCKeSCzG4ixRrwVJuFzuN1fEq6XCTMeCEthyQ6pxQSkaSnaiToDsB4qNRRQlucXGyv/9k=) **Extend** to navigate to **Functions**. 3. Click **New** to create a new function. 4. Provide the function name and input parameters.
5. Write the function using Javascript. 6. **Save** and **Test** the function to ensure proper execution. Your User Defined Function is ready to be deployed within a workflow to automate data processing. #### Example 1 The following example helps a user to get the full name. Below is the code snippet of a User Defined Function and **Test** method to execute it. |

//@UserDefined

function CombineName(firstname,lastname)

{

return firstname+" "+lastname;

}


//@Test

function Test()

{

var firstname = 'Ashish';

var lastname = 'Samant';

CombineName(firstname,lastname)

}

| | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | #### Example 2 The following example explains how to use user defined functions and public functions and how to call public functions from User Defined Functions. The below mentioned code snippet is of a user defined function and a test method. \|

input\['type'] = {newid:"", newid: "", name:"string", first:"string", id:"int"};

out\['type'] = {newid: "", newid: "", name2:"string", first2:"string", surname: "string", id2:"int"};input\['type'] = {newid:"", newid: "", name:"string", first:"string", id:"int"};

out\['type'] = {newid: "", newid: "", name2:"string", first2:"string", surname: "string", id2:"int"};

var myapp = {

//@UserDefined

doubleme: function(nu){

return 2*nu;

},

//@Public

readData: function(){

print(input\['data'].name+'---'+input\['data'].first);

out\['data']= \[

{name2:"rg1", first2:"gu1", surname: "string1"},

{name2:"rg2", first2:"gu2", surname: "string2"},

{name2:"rg3", first2:"gu3", surname: "string3"}];

},

/*

--------------------

| name2 | first2 |

---------------------

| rg1 | gu1 |

---------------------

| rg2 | gu2 |

---------------------

| rg3 | gu3 |

---------------------

*/

//@Public

writeData: function(){

if (out\['data']==null){

out\['data']=\[];

}

index=0;

for each (r in input\['data']){

print(r.name2+'--'+r.first2);

currentId = 123 + index;

currentName = r.name2 + index;

currentFirst = r.first2 + index;

out\['data'].push({"id": currentId, "name2": currentName, "first2":currentFirst});

index++;

}

}

}

//@UserDefined

function combine(first, last){

return first + ' ' + last;

}

//@UserDefined

function doubleme(nu){

return 2*nu;

}

//@Test

function test(){

input\['data'] = {name:"rajeev", first:"gip"};

myapp.readData();

input\['data'] = out\['data'];// this is the straight transformation

myapp.writeData();

}

| \| --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | #### Test a User-Defined Functions To test a User Defined Function, the Function must be followed by the test method. The test method must start with the header `//@Test`. > **Note:** Ensure that you save the Function before testing it. The following code snippets shows the User defined function for name and the Test method required to test this User defined function: #### User defined function Code |

//@UserDefined

function fullName(firstName, lastName){

return firstName + " " + lastName;

}

function fullName(firstName, lastName){ return firstName + " " + lastName;

}

| | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | #### User-Defined Function Test |

// @Test

function testFirstAndLastName(){//@Test

function testFirstAndLastName(){

var firstname = "Xxxxxx";

var lastname = "Yyyyy";

addFirstAndLastNames(firstname, lastname);

} var firstname = "Xxxxxx"; var lastname = "Yyyyy"; addFirstAndLastNames(firstname, lastname);

}

| | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | The following screen shows the User-Defined Function along with the Test method required to execute it.

Example Function

## Miscellaneous 1. It is a best practice to **Save** the Functions after writing the Test method. The **Save** button is located at the top right corner of the page. 2. When you click Test, you will be prompted to Select Test from the available Test Methods in a pop-up. Select the appropriate test and click Run Tests.
3. Once the tests are completed, the number of code lines executed is shown in the Top ribbon. The color of the ribbon is green or red based on the success or failure of your test.

--- # Agent Instructions: Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter: ``` GET https://docs.mydbsync.com/cloud-workflow/2026_dbsync-platform/extend/functions.md?ask= ``` The question should be specific, self-contained, and written in natural language. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.