By Definition, A Function is a group of statements that together performs a task. DBSync Functions are categorized into two types 

  1. Standard Functions 
  2. User Defined Functions 

Standard Functions

Standard Functions or built in functions refers to specific function by name . Functions are available to all users of a project, If a project is imported, the same files and and functions from original project is available to the cloned project.

 Note 1: Functions are code sensitive
 Note 2: When you are using functions, the string objects must be enclosed in single quotes .

The standard function are listed out in detail in the iPaaS section, click on the link to learn about the function supported by our platform.

User Defined Functions 

User-Defined functions are those functions which are defined by the user from DBSync platform. Functions are made for code reuse-ability and for saving time and space 

At present, DBSync platform supports creation of UDF in JavaScript.

Benefits of them are :

  1. It provides modularity, so that create once and can be used across any project which gives a benefit of create once and use n number of times 
  2. Easy code reuse-ability, you just have to call the functions by its name to use it.