Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Insert excerpt
_Banners
_Banners
nameactionflow
nopaneltrue

What is a HTTP Action?

HTTP actions perform HTTP(S) requests to external APIs and return the response.

Creating HTTP Actions

  1. Click and drag the 
    Insert excerpt
    _http
    _http
    nopaneltrue
     icon from the toolbar onto the canvas
  2. Enter a name for the HTTP action, then select Create Action
  3. In the HTTP action 
    Insert excerpt
    _property_settings
    _property_settings
    nopaneltrue
     on the right, populate the following details:
FieldDescriptionExample Value
NameName given to the HTTP Node. This will be displayed on the Actionflow canvas.BankHolidays
HTTP MethodThe HTTP method. A drop-down field containing: GET, POST, GET or POST, HEAD, PUT, DELETE, other. If other is specified a text box will allow the entering of a custom value which is not empty and contains only uppercase letters.Get
URL Template

A template that computes the URL of the request.

Expects literal values or expressions encapsulated within ${} syntax, for example ${in.MyValue}.

https://www.gov.uk/bank-holidays.json
Body Template

Optional.

If this is provided then it is used to carry the HTTP request data. If a body is provided then usually Content-Type and Content-Length headers lines specify the nature of the body associated.

In PhixFlow if this evaluates to whitespace only then it is not included in the request.

The body expects literal values, or expressions encapsulated within ${} syntax, for example ${in.MyValue}.


Error Expression

Optional.

A JEP expression to determine if the response is an error and so sent on the error output. The expression will have access to the input record (in) and the mapped output response (_result).


Log Traffic

Toggle on 

Insert excerpt
_toggle_on
_toggle_on
nopaneltrue
 to logs the response of the HTTP request.

Maximum HTTP Log Length

Available if Log Traffic is toggled on 

Insert excerpt
_toggle_on
_toggle_on
nopaneltrue
.

Restricts the size of the log traffic.


Use Raw URL

Toggle on 

Insert excerpt
_toggle_on
_toggle_on
nopaneltrue
 to send the URL Template value in exactly the format it is provided to the HTTP Node.

If toggled off 

Insert excerpt
_toggle_off
_toggle_off
nopaneltrue
PhixFlow will transpose values to form a valid URL, such as replacing spaces with %20.


4. 

Insert excerpt
_finish
_finish
nopaneltrue
 all settings

5. Hover over the 

Insert excerpt
_http
_http
nopaneltrue
 action on the canvas to see the output connection points

Output Connection Points

A HTTP action has two outputs. A HTTP request will be triggered for each input record and generate one output record, which will be sent on either the out or error output. 

The response from the server (headers and body) will be treated as the result record..

Output Connection PointDescription
OutContains the resulting record of the request. 
ErrorContains the resulting record of the request where it satisfies the error expression specified on the HTTP Node. 

The output records contain the attributes specified by the output connection point, successful records are passed down the out connection point and records containing an error are passed down the error connection point. The structure of the records by default are as follows:

  1. body: The content returned by a successful request, for example, JSON content

  2. contentType: The type of response provided by the target HTTP request, for example, application/json; charset=utf-8
  3. status: The returned status code, for example, 200

  4. status message: The returned status message, for example, OK

Adding and Editing

  • To add a new output connection point, click the 
    Insert excerpt
    _addIcon
    _addIcon
    nopaneltrue
     icon, see Connection Points


HTML Comment
hiddentrue

ZB I couldn't create a new output connection point? 


Configuration

The configuration of each output connection point is identical: 

FieldDescriptionExample
NameName of the outputout
Output TypeA drop-down field containing: String, Raw Data, JSON. String
Skip Invalid RecordsSkip attributes which are considered invalid.Enabled
Default CharsetA drop-down field containing character set options, including utf-8.utf-8
PathThe JSON path to apply. If empty this will default to '$' which matches the entire object. 

// $ returns everything, this syntax traverses down two levels using two full // stops.

$..events

JSON Lenient

When enabled this removes JSON specification restrictions, allowing for a degree of leniency in malformed JSON data.

When disabled the JSON will be treated strictly.

Enabled
AttributesContains the attributes which hold the values returned by the Output Connection Point. Result values are obtained using the keyword _result followed by the attribute name. _result.status

Headers

Headers are typically used to specify information for the request, such as character sets, session tokens or passwords. Headers can make use of the Secret Key Details.

For example,

  • Name: AuthValue
  • Expression: _datasource.MyKey

Secret Key Details

Secret Keys allow sensitive data, such as passwords or security tokens, to be encrypted and stored in the PhixFlow Database. See Secret Key and Local Secret.

HTML Comment
hiddentrue

Insert excerpt
HTTP Node
HTTP Node
nopaneltrue

Worked Example

You may notice that right-clicking the button does not display the option to add an Actionflow. The Actionflow must be created using an event handler. See 2.01 Connecting Actionflows to Events.

Open the  for the button and click on the 
  • In the Action Settings section, choose an Action Method of Actionflow
  • Create a new Actionflow

    HTTP Action Setup

    1. Select Click to Connect and

      button 

    2. Select Click to Connect and choose On Click

    3. Drag a 

    Excerpt

    Here is a worked example using the Shop Data (available from the Learning Centre) and JSON data from the UK government website (https://www.gov.uk/bank-holidays.json).

    In this example, we are using:  

    • Shop Shipping screen containing a grid of Orders data, a grid of Order Lines data, an area containing a Date form field and buttons  - this screen was created using the Multi-Tile template
    • A Shop Shipping Popup screen containing a grid of the bank holiday data  - this screen was created using the Tile no Buttons template
    Tip

    If you are completing this chapter as part of the Actionflow course and using a training instance, the data and screens have already been pre-loaded into the Actionflow Intermediate Application. For these example, we'll be working on the Search button on the Shop Shipping screen, and the Shop Shipping Popup screen. 

    GIF/SCREENSHOT OF FINISHED RESULT 

     

    Identify Bank Holiday Dates

    In this example, we'll create an Actionflow that retrieves bank holiday dates in the UK from the government website in JSON format and map this onto a screen in a grid. 

    Image Added

    HTML Comment
    hiddentrue

    Select shipment date date field (date picker), then press Ship Date which changes the status of the order and order lines to completed.
    Area underneath showing upcoming bank holidays

    Table Setup

    1. Create a new
      Insert excerpt
      _tables
      _tables
      nopaneltrue
       on your
      Insert excerpt
      _erd
      _erd
      nopaneltrue
       to save the bank holiday data to, and ensure it contains the following attributes:
      1. Name: UID
        1. Type: String
        2. Length: 50
        3. Expression: _NULL
      2. Name: Name
        1. Type: String
        2. Length: 200
        3. Expression: _NULL
      3. Name: Date
        1. Type: Date
          1. Leave the Expression field blank
      4. Name: Country
        1. Type: String
        2. Length: 50 
          1. Leave the Expression field blank
    Initial Configuration

    HTTP Action Setup

    1. On the Shop Shipping screen, add an Actionflow to the  button  ("GetDates")

      Add an Actionflow to the button that is triggered by the button click

    Expand
    titleHow?
    Insert excerpt
    _property_settings_property_settings
    nopaneltrue
    Insert excerpt
    _property_tabs_property_tabs
    nameaction
    nopaneltrue
    Insert excerpt
    _http
    _http
    nopaneltrue
     action onto the canvas and give it a suitable name - this will be used to retrieve the bank holidays from the government JSON URL

  • Drag the 

    Insert excerpt
    _input
    _input
    nopaneltrue
     connection point node onto the
    Insert excerpt
    _http
    _http
    nopaneltrue
     action

  • Click on the 

    Insert excerpt
    _http
    _http
    nopaneltrue
     action to open its Properties

    1. HTTP Method: GET
    2. URL: https://www.gov.uk/bank-holidays.jsonLog Traffic:  Insert excerpt_toggle_on_toggle_onnopaneltrueMaximum HTTP Log Length: 100000


  • Drag a 
    Insert excerpt
    _action_json
    _action_json
    nopaneltrue
     action onto the canvas and give it a suitable name - this will be used to convert the JSON data into data suitable for our bank holiday table
  • Connect the out connector from the HTTP node to the JSON node
      Click on the connector between the  Insert excerpt_http_httpnopaneltrue action and the Insert excerpt_action_json_action_jsonnopaneltrue action
      1. Map across all attributes
      1. Map across all attributes

        Expand
        titleCheckpoint

        Image Added


    JSON Action Setup

    1. Click on the 
      Insert excerpt
      _action_json
      _action_json
      nopaneltrue
       action to open its Properties
      1. Input Expression: in.body
      2. Path: $..events
      3. Output Attributes:

        Code Block
        themeEmacs
        titleName: Country, Type: String
        _result.^.^.division


        Code Block
        themeEmacs
        titleName: Date, Type: Date
        toDate(_result.date, "yyyy-MM-dd")


        Code Block
        themeEmacs
        titleName: ID, Type: String
        toString(_result.date, "yyyyMMdd") + substring(_result.^.^.division, 1,1)


        Code Block
        themeEmacs
        titleName: Title, Type: String
        _result.title


    2. Hover over the JSON action and select out
    3. Click on the connector between the JSON action and the Save action
    4. Create a
      Insert excerpt
      _action_save
      _action_save
      nopaneltrue
       action
      1. Primary Table: Shop Bank Holidays

    Save Action and Open Screen Action Setup

      1. Map across the JSON attributes to their relevant attributes on the Save action


        Expand
        titleHow?

        Image Modified


    1. Hover over the Save action and choose out
    2. Create an 

      Insert excerpt
      _action_screen
      _action_screen
      nopaneltrue
       action to open the Shop Shipping Popup screen

      Expand
      titleCheckpoint

      Image Added


    Testing

    1. Close all open screens and reopen the Shop Shipping screen
    2. Click the  button to run the Actionflow
    3. If the Actionflow is working, the Shop Shipping Popup screen should open containing all of the bank holiday data from the government website

    Background Filter and Default Sort Order

    Tidy up your Shop Shipping Popup screen by hiding the UID column on the grid, adding a Default Filter to show only bank holidays in the future, and Default Sort Order to show the most recent bank holidays first.


    Expand
    titleHow?
    1. Right-click on the grid and choose,
      Insert excerpt
      _view_show_config
      _view_show_config
      nopaneltrue
    2. In the Data Retrieval Options section of the Properties:
      1. For Background Filter, select the 
        Insert excerpt
        _addIcon
        _addIcon
        nopaneltrue
         icon to create a new background filter
      2. For Default Sort Order, select the 
        Insert excerpt
        _addIcon
        _addIcon
        nopaneltrue
         icon to create a new sort order


    1.02 Actionflow Principles2.13 JSON Action Configuration