Console
    Contact Us Start free

    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. Click Integrations from the left navigation menu to open the Integrations page.
    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 Triggersto view the list of available triggers.
    2. Click and place the API triggerelement 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 +Createto create a variable.

    3. In the Create Variablepane, 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 Tasksto view the list of available tasks.
    2. Click and place the Data Mappingelement in the integration editor.
    3. Click the Data Mappingelement in the integration editor to open the task configuration pane.
    4. Click Open Data Mapping Editor.
    5. Configure the Inputas follows:
      1. In the Inputsection, 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_EACHfunction input parameter. Click Variable or Valueand select ~obj1.
      6. Click Save.
      7. Add a mapping function to obj1. Click +in the FOR EACH row within the parentheses after the obj1element that you just added. In the list of functions, scroll down and select GET PROPERTY(String) -> JSON.
      8. Click Variable or Valueand in Valueenter itemName .
      9. Click Save.
      10. Click + Add a functionin the row after GET PROPERTYand select TO_STRING() -> String.
      11. Click + Add a functionin the last row and select TO_STRING() -> String.
    6. Configure the Outputas follows:
      1. Create a new output variable. In the Outputsection, click create a new one.
      2. In the Create Variablepane, 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 Editorto return to the integration editor.

    Add and configure a Send Email task

    To add and configure the Send Emailtask 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 Tasksand click and place the Send Emailelement in the integration editor.
    3. Click the Send Emailtask element in the integration editor to open the task configuration pane.

    4. Set the following Task Inputfields:

      1. To Recipient(s): Click Variableand 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 triggerelement to the Data Mappingelement. Hover over a control point on the API triggerelement, then click and drag a line to a control point on the Data Mappingelement.
    2. Similarly, add an edge from the Data Mappingelement to the Send Emailelement.

    Test and publish the sub-integration

    1. To test this sub-integration, click Testin the integration editor toolbar and then click Test integrationin the Test Integrationdialog. 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 Publishin the integration editor toolbar.

    Create the main integration

    1. In the navigation menu, click Integrationsto go back to the Integrationspage.
    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 Regionfor 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 Triggersto view the list of available tasks and triggers.
    2. Click and place the API triggerelement 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 Variablepane, 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 Loopelement in the integration editor.
    3. Click the For Each Looptask 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 triggerelement to the For Each Loopelement. Hover over a control point on the API triggerelement, then click and drag a line to a control point on the For Each Loopelement.

    Test and publish the main integration

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

    1. Click Testin the integration editor toolbar and then click Test integrationin the Test Integrationdialog. You should see a success message when the test completes.

    2. To publish this integration, click Publishin 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 .
    Create a Mobile Website
    View Site in Mobile | Classic
    Share by: