cs-icon.svg

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 Resource: JavaScript is an advanced programming language. For more information, refer to the JavaScript documentation.

Set up Code Block

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.
    Select_Connector.png
  4. Under Choose an Action tab, select the JavaScript Code action.
    Select_Action.png
  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.

      Note: Select Account is an optional field. You can still configure the action without selecting an account.

      Select_Account.png
    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.

      You can also use the value fetched from the selected account as shown below.

    3. Provide the JavaScript Code for execution.
      Javascipt_Code.png

      Note: The automation code uses Node.js 18.x.x version for executions.

  6. Click Proceed.
  7. Click Test Action to test the configured action.
    Test_Action.pngYou will get the response.
    Save_and_Exit.pngFor 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.
    Error_output.png
  8. Once set, click Save and Exit. Save_and_Exit.png

This sets the Code Block action connector.

Examples

Fetching the values of JSON attributes

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);
}

Save_Exit_Use-Case.png

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

Using regular expressions to check whether the email is valid

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.";    
}

Valid_Email_Output.png

Comparing the calendar dates

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";

CustomDate_Save_Exit.png

Using Lodash library for sorting the age of users

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']);

Save_Exit_Loadash.png

Generating Random Numbers

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

Save_Exit_Random_Numbers.png

Limitations

  1. The execution time limit is 5 seconds only.
  2. You can perform up to 1,00,000 executions per month for an 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.
Was this article helpful?

More articles in "Development"

^