Code Block

The Code Block connector lets you execute the JavaScript code and returns the expected output to assist in complex data transformation. It helps developers and software engineers to automate the execution of small code snippets.

Additional ResourceJavaScript is an advanced programming language. For more information, refer to the JavaScript documentation.

Perform the following steps to set up the Code Block action connector:

1. Click Configure Action Step from the left navigation panel.
2. Click Action Step to configure third-party services.
3. Within the Configure Action Step, click the Code Block connector.
   
   Click to enlarge
4. Under Choose an Action tab, select the JavaScript Code action.
   
   Click to enlarge
5. On the Javascript Code Configure Action tab, enter the details given below:
   1. Under the Select Account drop-down, select one of the accounts connected to your project. The sensitive information, such as access code, secret key, API key, etc., is fetched from the selected account.

      NoteSelect Account is an optional field. You can still configure the action without selecting an account.

      Click to enlarge
   2. Provide the Input Name and Input Value you want to use in your JavaScript code. You can get the input data from the previous step.
   3. Provide the JavaScript Code for execution.

      You can debug the code at multiple lines using the console.log code. This will help identify the errors or failures at different stages of the code.

      You can view the console.log in the payload, once you test the action as shown in step 8.

      Click to enlarge
      Note

      1. The automation code uses Node.js 18.x.x version for executions.
      2. The console.log output cannot be viewed in the payload if the string exceeds 4 kilobytes in length.
6. Click Proceed.
7. Click Test Action to test the configured action.
   
   Click to enlarge
   You will get the response.
   
   Click to enlarge
   For unsuccessful execution, an error message is displayed. This message specifies the type of error and the line number of the error to trace the issue.
   
   Click to enlarge
8. Once set, click Save and Exit.
   Click to enlarge

This sets the Code Block action connector.

try{

    const res = await fetch('https://nodejs.org/api/documentation.json');

    if (res.ok) {

      const data = await res.json();

      return data;

    }else{

        throw new Error("Network response was not OK");

    }

}catch(err){

    throw new Error(err);

}

Click to enlarge

NoteFor such scenarios, using the HTTP Action connector is preferable. For more information, please refer to the HTTP Action Connector document.

const re = /\S+@\S+\.\S+/g;


// check if the email is valid

let result = re.test(input.email);

if (result) {

    return "The email is valid.";

}

else {

   return "The email is not valid.";    

}

Click to enlarge

let today  = new Date();

let customDate = new Date("2019/08/03"); // (YYYY-MM-DD)


if (today.getTime() < customDate.getTime())

    return "today is lesser than customDate";

else if (today.getTime() > customDate.getTime())

    return "today is greater than customDate";

else

    return "both are equal";

Click to enlarge

const users = [

  { 'user': 'fred',   'age': 48 },

  { 'user': 'barney', 'age': 36 },

  { 'user': 'fred',   'age': 40 },

  { 'user': 'barney', 'age': 34 }

];


// sort by user in descending order

return _.orderBy(users, ['user'], ['desc']);

Click to enlarge

let min = 20.4;

let max = 29.8;


let randomNum = Math.random() * (max - min) + min;


return randomNum;

Click to enlarge

1. The execution time limit is 5 seconds only.
2. You can perform up to 10,000 code block executions per month per organization.
3. You are not allowed to use external libraries, or to install or import npm modules. Only the standard node.js library and the fetch and lodash package are available in the Code Block connector.