1. On the Start Loop action, 
2. On the End Loop action

Worked Example

Here's a worked example using the Company Data (available from the Learning Centre).

In this example, we are using:  

• A Company Management screen containing a grid of the Companies data and a card container of their associated Employees - this screen was created using the Multi-Tile template
• A Company Merger Pop up screen containing:
  • two manual drop down fields of the company name's of the companies to be merged
  • two string fields showing the company ID's of the companies to be merged
  • a button to initiate the Actionflow - this screen was created using the Tile no Buttons template
• A Company Orders screen containing two grids of the Orders and OrderLines data - this screen was created using the Multi-Tile template

Bulk Update Employees and Orders for Company Acquisition

In this example, a company is being merged into another company and we need to update the employees and orders to reflect the change.

GIF

Create API End Point Actionflow

In this example, we'll set up an Actionflow that will act as an UK Bank Holiday API that can be called by another Actionflow. This Actionflow will be configured to receive a year parameter and use that parameter to pass out the bank holiday dates for the corresponding year. If you have completed the worked example on 3.01 Setting up an API End Point, the setup is very similar.

1. Open the Company Management screen
2. Click the Merge button to open the Company Merger Pop up screen
3. Create an Actionflow on the Run Acquisition button
   1. Name: RunCompanyAcquisition
4. On the Actionflow canvas,

Testing

Actionflow Setup

This Actionflow will use a

1. Open the Company Bank Holidays API - Loops screen
2. Add an Actionflow to the Run button
   1. Name: Get Bank Holidays
3. Choose the input of the CompanyBankHolidayAPI-Loops form
4. Map in the two input fields:
   1. YearFrom
   2. YearTo
5. On the Mappings window, change the names of these two attributes to:
   1. YearFromIn
   2. YearToIn
      1. Image Added

Type Conversion

The data coming into the Actionflow is in the Type, String. Our Actionflow needs this data in Integer format.

1. Create a 

   Insert excerpt
   _action_calculate _action_calculate nopanel true

    action
   1. Name: ConvertToInteger
2. Map both attribvutes from the input to the Calculate action

3. Use the function toNumber to create two Output Attributes on the Calculate action that convert the strings to integers

   Expand
   title How?
   Image Added

   
   

Create Loop Action

1. Create a 

   Insert excerpt
   _action_loop _action_loop name loop nopanel true

    action
   1. Name: Loop Years
2. Connect the 

   Insert excerpt
   _action_calculate _action_calculate nopanel true

    action to the 

   Insert excerpt
   _action_loop_start _action_loop_start nopanel true

3. Map across the YearFrom attribute

Create HTTP Action

1. Create a 

   Insert excerpt
   _action_http _action_http nopanel true

    to call the Bank Holiday API
   1. Name: Call BH API
2. Map across the YearFrom attribute from the 

   Insert excerpt
   _action_loop_start _action_loop_start nopanel true

    to the HTTP action
3. Rename the attribute on the HTTP action to CallingYear
   1. Image Added
4. In the HTTP Action properties, enter the following:
   1. HTTP Method: POST
   2. URL: Paste in the URL you copied earlier and saved locally

   3. Body: 

      Code Block
      theme Emacs
      [{ "CallingYear": "${in.CallingYear}" }]

      
      

   4. Toggle on Log Traffic

      Expand
      title Checkpoint
      Image Added

      
      

Create JSON Action

1. Create a 

   Insert excerpt
   _action_json _action_json nopanel true

    to process the returned bank holiday data from the API
   1. Name: Returned Bank Holidays
2. Connect the HTTP action to the JSON action
3. Map across the body from the HTTP action

4. Setup the JSON action to receive the data from the API

   Expand
   title How?
   Image Added

   
   

Save Action

1. Create a 

   Insert excerpt
   _action_save _action_save nopanel true

    action to save the data
   1. Name: SaveBHs
   2. Type: Auto Insert/Update
   3. Table: click the 

      Insert excerpt
      _tables _tables nopanel true

       icon 
      1. Under Tables in the 

         Insert excerpt
         _repository _repository nopanel true

         , click 

         Insert excerpt
         _add_icon _add_icon nopanel true

          to create a new table
         1. Name: Bank_Holiday_Results
         2. Add the attributes from the UK_Bank_Holidays table to this table
         3. Image Added
      2. Select this table on the Create Save Action drop down
      3. Click Create Action
2. Connect the JSON action to the Save action and map across the attributes being returned by the JSON action 
   1. Image Added

Increment Year By One

After the bank holiday data has been saved, we need the loop to go round again, this time getting the next year in the sequence, for example, if the user has entered 2018 for the YearFrom and 2020 for the YearTo, when the data first hits the Save action, it is just the 2018 data. For the second loop, the 2019 data will be obtained.

1. Create a 

   Insert excerpt
   _action_calculate _action_calculate nopanel true

    action
   1. Name: Increment +1
2. Connect it to the Save action and map across the YearFrom attribute
   1. Ensure this is the attribute from the  

      Insert excerpt
      _action_loop_start _action_loop_start nopanel true

   2. Image Added 
3. On the Calculate action, add an Output Attribute:
   1. Name: LoopYear
   2. Type: Integer
   3. Expression: in.YearFrom + 1

End Loop Setup

1. Connect the Increment +1 

   Insert excerpt
   _action_calculate _action_calculate nopanel true

    action to the 

   Insert excerpt
   _action_loop_end _action_loop_end nopanel true

2. Map across the LoopYear attribute from the Increment +1 

   Insert excerpt
   _action_calculate _action_calculate nopanel true

    action and the YearTo attribute from the ConvertToInteger 

   Insert excerpt
   _action_calculate _action_calculate nopanel true

    action
   1. Image Added
3. Setup the 

   Insert excerpt
   _action_loop_end _action_loop_end nopanel true

    as follows:

1. 
   
   1. Image Added
2. On the Loop connector between the 

   Insert excerpt
   _action_loop_end _action_loop_end nopanel true

    and 

   Insert excerpt
   _action_loop_start _action_loop_start nopanel true

    map the LoopYear attribute to the YearFrom  attribute 
   1. Image Added

Testing

1. Close all screens and reopen the 

3.05 Custom Confirmation Message Configuration