By Definition, A Function is a group of statements that together performs a task. DBSync Functions are categorized into two types
- Standard Functions
- 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 :
- 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
- Easy code reuse-ability, you just have to call the functions by its name to use it.