What is a JSON Action?

For the full list of JSON action

Creating JSON Actions

1. Click and drag the 

   Insert excerpt
   _action_json _action_json nopanel true

    icon from the toolbar onto the canvas
2. Enter a name for the JSON action, then select Create Action
3. In the JSON action 

   Insert excerpt
   _property_settings _property_settings nopanel true

    on the right, populate the following details:

4. 

Path Syntax

Output Attributes

JSON is converted into data objects that can be used by PhixFlow, this information is accessed using the syntax, _result.AttributeName.

Worked Example

Here is a worked example using the Shop Data (available from the Learning Centre).

In this example, we are using:  

• A Shop Staff screen containing a grid of the Shop Staff data and a blank tile  - this screen was created using the Multi-Tile template

GIF/SCREENSHOT OF FINISHED RESULT   

Calculate Working Days

In this example, we'll use the bank holiday data created in 2.12 HTTP Action Configuration to calculate the remaining working days in the current month and map this onto a screen. 

Table Setup

1. Name: UID
   1. Type: Integer
   2. Expression: _NULL
2. Name: Date
   1. Type: Date
   2. Expression: _NULL

Event Handler Setup

Create a new Actionflow on an Event Handler that will run when the chevron state is changed

Extract Actions From Actionflow

We will reuse the Actions created to retrieve the bank holiday dates.

1. Name: Get Gov Bank Holidays

Working Days Actionflow

Expression: 

do( 
//set $lastDay to the 1st day of the month
    $lastDay = dateSet(now(),_DAY,1),
     
//add a month to $lastDay
        $lastDay = dateAdd($lastDay, _MONTH,1),
        
//minus a day to get the last day of the month
            $lastDay = dateAdd($lastDay, _DAY,-1)
                          
)                    

Create a filter on the View that retrieves only bank holiday dates for England and Wales, and the current month

do(

    //Get the last day of the month and set $lastDay to this
    $lastDay = dateGet($lastDay,_DAY),

        //for each day of the month, remove the time and set $allDays to now
        forEach($day,1..$lastDay,
 
            addElement($allDays, removeTime(dateSet(now(),_DAY,$day)
                                )
                        )
                ),

                    //remove BH days from month days
                    excluded($allDays, lu.Date)
)

Testing

1. Test your Actionflow by clicking the chevron on the Shop Staff screen

Extracting Data Example

Below is an example JSON object passed to the JSON action:

// Example JSON string.
{
    "main_page": {
        "page": "PF Main Page",
        "title": {
            "name": "PF Title Text",
            "data": [
                {"initials": "AA", "value" : "Alistair Andrews"},
                {"initials": "BB", "value" : "Bert Brown"}
            ]
        }
    }
}

{
	"a": "1",
	"b": 2,
	"c": "xxx",
	"d": {
		"x": 1,
		"y": 2,
		"z": 3
	}
}

do(
	$json = jsonToItems(in.JsonIn),
	$fields = getFields($json.d),
	$fields[1]
)

Worked Example

Image Added