See the supported connectors for Application Integration.

Invoke a sub-integration using a For Each Loop task

This quickstart shows you how to create an integration that uses a For Each Loop task to invoke a sub-integration. The sub-integration takes the input from the main integration and sends emails to the recipients using the Send Email task.

Create the sub-integration

  1. In the Google Cloud console, go to the Application Integration page.

    Go to Application Integration

  2. In the navigation menu, click Integrations. The Integrations page appears.
  3. Click Create integration.
  4. Enter a name and a description for the integration.

    For this quickstart, enter the name ForEachSendEmailSubIntegration and the description Quickstart sub-integration.

  5. Select a region for the integration.
  6. Click Create to open the integration editor.

Add an API trigger in the sub-integration

Triggers are required to start the sequence of tasks that make up an integration. In this quickstart, you use an API trigger to start the integration.

To add and configure the API trigger, perform the following steps:

  1. In the integration editor, click Triggers to view the list of available triggers.
  2. Click and place the API trigger element in the integration editor.

Create an input variable in the sub-integration

The sub-integration uses a variable to store the details received in JSON format from the main integration. To create a new input variable, perform the following steps:

  1. Click (Toggle panel) in the designer navigation bar to bring up the Variables pane.
  2. Click +Create to create a variable.
  3. In the Create Variable pane, do the following:

    a. Name: Enter order_details.

    b. Data Type: Select JSON.

    c. Click Infer from the default value.

    d. In Default Value, enter the following JSON.

      {
        "orderId": "1",
        "customerName": "Harry Ford",
        "emailId": "YOUR_EMAIL_ID",
        "shippingAddress": {
          "city": "New York",
          "country": "USA",
          "zipcode": "103487"
          },
        "items": [{
          "itemid": "111-222-333",
          "itemName": "Smartphone",
          "itemPrice": 999.0,
          "quantity": 1.0
          }, {
          "itemid": "444-555-666",
          "itemName": "Mobile Cover",
          "itemPrice": 49.0,
          "quantity": ""
          }],
        "paymentDetails": {
          "mode": "COD",
          "status": ""
          },
        "expectedDelivery": "15 March 2023"
      }
    

    In this sample JSON object, replace YOUR_EMAIL_ID with the email ID that you want to use to test the integration.

    e. Click Use as an input to integration.

    f. Click Create.

Add and configure a Data Mapping task

The Data Mapping task lets you perform variable assignments in your integration, get and set properties of json objects, and apply nested transform functions to values. The variables used by the Data Mapping task can be either integration variables or task variables.

To add and configure a Data Mapping task, perform the following steps:

  1. In the integration editor, click Tasks to view the list of available tasks.
  2. Click and place the Data Mapping element in the integration editor.
  3. Click the Data Mapping element in the integration editor to open the task configuration pane.
  4. Click Open Data Mapping Editor.
  5. Configure the Input as follows:
    1. In the Input section, click Variable or Value.
    2. In Variable, enter item and then select order_details.items.
    3. Click Save.
    4. Add a mapping function to order_details.items. Click the + symbol next to order_details.items. In the list of functions, scroll down and select FOR_EACH(Any) -> JSON.
    5. Enter the FOR_EACH function input parameter. Click Variable or Value and select ~obj1.
    6. Click Save.
    7. Add a mapping function to obj1. Click + in the FOR EACH row within the parentheses after the obj1 element that you just added. In the list of functions, scroll down and select GET PROPERTY(String) -> JSON.
    8. Click Variable or Value and in Value enter itemName.
    9. Click Save.
    10. Click + Add a function in the row after GET PROPERTY and select TO_STRING() -> String.
    11. Click + Add a function in the last row and select TO_STRING() -> String.
  6. Configure the Output as follows:
    1. Create a new output variable. In the Output section, click create a new one.
    2. In the Create Variable pane, enter the name items, retain the default values for all the other fields, and click Create.
  7. Verify that your data mapping configuration is similar to the following image.

    image of data mapping editor configuration

  8. Close the Data Mapping Editor to return to the integration editor.

Add and configure a Send Email task

To add and configure the Send Email task to send an email to each of the recipients, perform the following steps.

  1. In the integration editor, click Add a task/trigger.
  2. Go to Tasks and click and place the Send Email element in the integration editor.
  3. Click the Send Email task element in the integration editor to open the task configuration pane.
  4. Set the following Task Input fields:

    1. To Recipient(s): Click Variable and select order_details.emailId.
    2. Subject: Enter the subject for the email. For this quickstart, enter Order delivery notification.
    3. Body in Plain Text: Enter the following text:
    Hi $order_details.customerName$! Your order with Order Id: $order_details.orderId$ with items: $items$ has been successfully placed. Expected delivery by: $order_details.expectedDelivery$.
    

Connect the elements in the sub-integration

Now that you have added and configured the required tasks and triggers in the sub-integration, add a connection (edge) between the elements. An edge denotes the flow of control from one element to the next.

  1. Add an edge from the API trigger element to the Data Mapping element. Hover over a control point on the API trigger element, then click and drag a line to a control point on the Data Mapping element.
  2. Similarly, add an edge from the Data Mapping element to the Send Email element.

Test and publish the sub-integration

  1. To test this sub-integration, click Test in the integration editor toolbar and then click Test integration in the Test Integration dialog. The sub-integration runs with the default value as input and sends an email to the email address specified in the Send Email task. You should see a success message when the test completes.
  2. To publish this sub-integration, click Publish in the integration editor toolbar.

Create the main integration

  1. In the navigation menu, click Integrations to go back to the Integrations page.
  2. Click Create integration.
  3. Enter a name and (optionally) a description for the integration. For this quickstart, enter the name ForEachSendEmail and the description Quickstart main integration.
  4. Select a Region for the integration from the list of supported regions. Ensure that you create the main integration in the same region as the sub-integration.
  5. Click Create.

Add an API trigger in the main integration

  1. In the integration editor, click Triggers to view the list of available tasks and triggers.
  2. Click and place the API trigger element in the integration editor.

Create an input variable in the main integration

In the main integration, an input variable is used to store the data that is passed via the For Each Loop to the sub-integration. You can create this variable now, or in the next step when you add and configure the For Each Loop task. For this quickstart, create the variable now.

  1. Click (Toggle panel) in the designer navigation bar to bring up the Variables pane.
  2. In the Create Variable pane, do the following:

    a. Name: Enter order_requests.

    b. Data Type: Select JSON.

    c. Click Infer from the default value.

    d. In Default Value, enter the following JSON:

      [{
        "orderId": "1",
        "customerName": "Harry Ford",
        "emailId": "YOUR_EMAIL_ID",
        "shippingAddress": {
          "city": "New York",
          "country": "USA",
          "zipcode": "103487"
        },
        "items": [{
          "itemid": "111-222-333",
          "itemName": "Smartphone",
          "itemPrice": 999.0,
          "quantity": 1.0
        }, {
          "itemid": "444-555-666",
          "itemName": "Mobile Cover",
          "itemPrice": 49.0,
          "quantity": ""
        }],
        "paymentDetails": {
          "mode": "COD",
          "status": ""
        },
       "expectedDelivery": "15 March 2023"
      }, {
        "orderId": "2",
        "customerName": "Tim Harvey",
        "emailId": "YOUR_EMAIL_ID",
        "shippingAddress": {
          "city": "Los Angeles",
          "country": "USA",
          "zipcode": "210738"
        },
        "items": [{
          "itemid": "222-333-444",
          "itemName": "Laptop",
          "itemPrice": 5999.0,
          "quantity": 1.0
       }],
        "paymentDetails": {
          "mode": "Online Payment",
          "status": "Success"
        },
        "expectedDelivery": "21 Feb 2023"
      }]
    

    In this sample JSON object, replace both occurrences of YOUR_EMAIL_ID with the email ID that you want to use to test the integration.

    e. Click Use as an input to integration.

    f. Click Create.

Add and configure a For Each Loop task

  1. In the integration editor, click Tasks.
  2. Click and place the For Each Loop element in the integration editor.
  3. Click the For Each Loop task element in the integration editor to open the task configuration pane.
  4. In the configuration pane, do the following:
    1. List to iterate: Select the input variable that you created, order_requests.
    2. API trigger ID: Select the API trigger in your sub-integration. For this quickstart, select api_trigger/ForEachSendEmailSubIntegration_API_1.
    3. Integration name: Select the name of the sub-integration that you want to invoke. For this quickstart, select ForEachSendEmailSubIntegration.
    4. Iteration element sub-integration mapping: Select order_details.

Connect the elements in the main integration

  1. Add an edge from the API trigger element to the For Each Loop element. Hover over a control point on the API trigger element, then click and drag a line to a control point on the For Each Loop element.

Test and publish the main integration

The final task is to test and publish the main integration.

  1. Click Test in the integration editor toolbar and then click Test integration in the Test Integration dialog. You should see a success message when the test completes.
  2. To publish this integration, click Publish in the integration editor toolbar.

    Upon successful completion, the integration sends an email to the email address specified in the Send Email task. Confirm receipt of the email in your email client.

Quotas and limits

For information about quotas and limits, see Quotas and limits.