On the 

Image Added

Loop Mappings

Attributes passed into a loop are available as passthrough, as well as attributes mapped in from the End Loop. This allows the original passthrough values to be referenced and if the loop is manipulating the incoming attributes, for example, incrementing a number, this is also available.

The mapped attributes that are manipulated by the loop are shown with a loop icon on the Mappings window, and passthrough attributes will be are shown with the icon of where they have come from, for example a calculated action., a

Image Added

Creating Loop Actions

1. Click and drag the 

   Insert excerpt
   _action_loop _action_loop name loop nopanel true

    icon from the toolbar onto the canvas
2. In the Create Loop Action window:
   1. Enter a Name
   2. Select Create Action
3. On the Start Loop action, 
4. On the End Loop action

1. Map attributes from other actions to the 

   Insert excerpt
   _action_loop_start _action_loop_start nopanel true

   to be processed by the loop
2. On the 

   Insert excerpt
   _action_loop_end _action_loop_end nopanel true

   , set:
   1. Records to output: Choose whether to output all records from the loop or just the final record
   2. Until Expression: An expression that is checked on each cycle of the loop, and once the expression returns true, the loop will end
      1. Example: in.myValue == 10
   3. Max Loops: This is a safety net designed to stop infinite loops. After the number of loops set here, the loops will stop
      1.  Set a sensible number of max loops
      2. This default to 10000

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 templateA 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 Bank Holiday API - Loops screen containing a grid backed by an empty Bank_Holiday_Results table, drop down fields for the user to select the Year From and Year To values and a Run button - this screen was created using the Tile no Buttons templateA Company Orders screen containing two grids of the Orders and OrderLines data - this screen was created using the Multi-Tile template

Loop Through Selected Years and Return Bank Holidays

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 user selects a date range (years) to return UK bank holidays. We'll create an Actionflow that takes in these parameters and each cycle of the loop returns the bank holiday dates for that year. For the purposes of this example, our Actionflow will call an API that exists within PhixFlow but this API represents an external public API. This is an example of paging where you retrieve a set amount of data per request, this is particular useful for large datasets.

Image Added

Obtain the API URL

We have provided an Actionflow that acts as a UK Bank Holiday API. This can be called by a Actionflow, in the same way that an external API can be called. The UK Bank Holiday API has been 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

See Setting up an API End Point, the setup is very similar.

1. Image Removed 
2. Name: Bank Holiday API

Setup the Input Connection Point Input Parameters

JSON Setup

1. Name: ReceiveYear
2. Input Expression: in.body
3. Path: $
4. Create an Output Attribute on the JSON action
   1. Name: YearReceived
   2. Type: String
   3. Expression: _result.Year

View Setup

1. Name: SelectedYearOnly
2. Filter Details: Image Removed

Obtain the API URL

Actionflow Setup

This Actionflow will use API Endpoint for more details on how this API has been setup or to set one up yourself.

This is a copy of the JSON body response, which will help with understanding the syntax used for the Output Attributes on the JSON action, when calling the API.

1. Search for the Bank Holiday API in the API Endpoint section of the

   Insert excerpt
   _repository _repository nopanel true

    for your application
   1. Image Added
2. Right-click the Bank Holiday API and select Edit
3. Copy the URL and save it locally to be used later

This is a copy of the JSON body response, which will help with understanding the syntax used for the Output Attributes on the JSON action, when calling the API.

{
  "getBH" : [ {
    "UID" : "20190101e",
    "Name" : "New Year?s Day",
    "Date" : "2019-01-01T00:00:00.000Z",
    "Country" : "england-and-wales"
  }, {
    "UID" : "20190419e",
    "Name" : "Good Friday",
    "Date" : "2019-04-19T00:00:00.000Z",
    "Country" : "england-and-wales"
  }, {
    "UID" : "20190422e",
    "Name" : "Easter Monday",
    "Date" : "2019-04-22T00:00:00.000Z",
    "Country" : "england-and-wales"
  }, {
    "UID" : "20190506e",
    "Name" : "Early May bank holiday",
    "Date" : "2019-05-06T00:00:00.000Z",
    "Country" : "england-and-wales"
  }, {
    "UID" : "20190527e",
    "Name" : "Spring bank holiday",
    "Date" : "2019-05-27T00:00:00.000Z",
    "Country" : "england-and-wales"
  }, {
    "UID" : "20190826e",
    "Name" : "Summer bank holiday",
    "Date" : "2019-08-26T00:00:00.000Z",
    "Country" : "england-and-wales"
  },

Actionflow Setup

Create an Actionflow using 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 on the input to allow them to be easily distinguished from two attributes with similar names we will create in the next section
   1. Change their names to: 
      1. YearFromIn
      2. YearToIn
      3. 

Type Conversion

The data coming into the Actionflow from the screen is in the Type, : String. Our Actionflow needs this data in Integer format. This can be changed on the field on the screen but can also be modified in the Actionflow, which we will do here.

1. Create a 

   Insert excerpt
   _action_calculate _action_calculate nopanel true

    action
   1. Name: ConvertToInteger
2. Map both attribvutes attributes 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?

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

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. Connect the Start Loop action to the HTTP action
3. Map across the YearFrom attribute from the 

   Insert excerpt
   _action_loop_start _action_loop_start nopanel true

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

   3. Body: 

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

      
      

   4. Toggle on Log Traffic to log the response from the API in the 

      Insert excerpt
      _console _console nopanel true

      Expand
      title Checkpoint

      
      

JSON Action

Create

a JSON action to read the data coming in from the API.

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 using the out connector
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 Removed

Save Action

1. Create a  Insert excerpt_action_save_action_savenopaneltrue action to save the data
   1. Name: SaveBHs
   2. Type: Auto Insert/Update
   3. Table: click the  Insert excerpt_tables_tablesnopaneltrue icon Under Tables in the  Insert excerpt_repository_repositorynopaneltrue, click Input Expression: in.body
   4. Path: $.getBH
   5. Output Attributes:

      1. 
         

         Code Block
         theme Emacs title Name: Name, Type: String
         _result.Name

         
         

      2. 
         

         Code Block
         theme Emacs title Name: UID, Type: String
         _result.UID

         
         

      3. 
         

         Code Block
         theme Emacs title Name: Country, Type: String
         _result.Country

         
         

      4. 
         

         Code Block
         theme Emacs title Name: Date, Type: Date
         substring(_result.Date,1,10)

         
         

Image Added

Save Action

Create a save action to save the bank holiday data to the Bank_Holiday_Results table where it can be viewed on the screen.

1. Create a 

   Insert excerpt
   _

   add

   action_

   icon

   save _

   add

   action_

   icon

   save nopanel true

    to create a new tableName:  action to save the data
   1. Name: SaveBHs
   2. Type: Auto Insert/Update
   3. Table: choose the Bank_Holiday_Results
   4. Add the attributes from the UK_Bank_Holidays table to this table
   5. Image Removed
   Select this table on the Create Save Action drop down table
   1. This table has been prepopulated with the attributes required to hold the data
   6. Click Create Action
2. Connect the JSON action to the Save action and map across the attributes being returned by the JSON action 
   1. 

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 is first hits the Save actionsaved, it is just the 2018 data. For the second loop, the 2019 data will be obtained, and so on. The criteria to end the loop is covered in the next section.

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.  
3. On the Calculate action, add an Output Attribute:
   1. Name: LoopYear
   2. Type: Integer
   3. Expression: in.YearFrom + 1

End Loop Setup

As the loop completes each iteration, criteria can be set on the End Loop to specify when the loop stops. This is specified using the Until Expression or Max Loops (whichever comes first). Our loop obtains one year's bank holidays for each loop, so if 2018 is entered for YearFrom and 2020 for YearTo, three loops are completed.

We want the looping to stop once the YearTo has passed, for this reason we must specify that the loop ends when the year after the YearTo has been reached.

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  ConvertToInteger 

   Insert excerpt
   _action_calculate _action_calculate nopanel true

    action
   1. 
3. Setup the 

   Insert excerpt
   _action_loop_end _action_loop_end nopanel true

    as follows:
   1. Records to output: All records
      1. This will output all the bank holidays, not just those satisfying the final year in the date range
   2. Until Expression: in.LoopYear == in.YearTo+1
   3. Max Loops: 10
      1. A loop will be completed per year in the date range
4. Image Modified
5. 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  from the

   Insert excerpt
   _action_calculate _action_calculate nopanel true

    action to the YearFrom  attribute 
   1. 

Testing

1. Close all screens and reopen the 

1. Company Bank Holidays API - Loops screen
2. Select the Year From and Year To criteria and press Run

Image Added