Skip to main content

Utility Actions

Append to list

Append an item to the end of a list. If the variable does not exist, the action will create a new list automatically.

ParameterDescription
Variable NameThe name of the variable.
ItemItem to add to list.

AppendToList

Run JP Command

Run a JSON path query command on a given JSON object.

ParameterDescription
JSONJSON object to run the path query command on.
QueryPath query command to run.
UnquotedIf the final result is a string, it will be printed without quotes.

JP Command

Run JQ Command

Run a JSON query command on a given JSON object.

ParameterDescription
JSONJSON object to run the query command on.
QueryQuery command to run.

JQ Command

Get Epoch Time

Gets an epoch time specific or relative to a given time.

ParameterDescription
TimeCan be a specific date and hour, or a relative range.
Epoch FormatWhether to display the epoch time as seconds or milliseconds.

Epoch Time

Convert JSON To CSV

Convert a JSON object to a CSV object.

ParameterDescription
JSON ObjectJSON object to convert to the CSV format.

HTML Table

Convert CSV To JSON

Convert a CSV object to a JSON object.

ParameterDescription
CSV ObjectCSV object to convert to the JSON format.

JSON

Convert CSV To HTML Table

Convert a CSV object to an HTML Table.

ParameterDescription
CSV ObjectCSV object to convert to an HTML Table format.

HTML Table

Get Time Difference Between Timestamps

Get Time Difference, in Seconds, Between Two Different Timestamps.

ParameterDescription
Timestamp 1The first Timestamp. Can be a specific date and hour, or a relative range.
Timestamp 2The second Timestamp. Can be a specific date and hour, or a relative range.

Timestamp Differences

Print

Prints text to the output screen.

ParameterDescription
TextThe text to print.

Print

Get Timezone

Gets the timezone identifier from a latitude/longitude pair or from the current workspace.

Can be used in conjunction with the Get Timezone Offset to get the amount of seconds after GMT.

ParameterDescription
Location TypeChoose how the location for the timezone should be provided.
LatitudeThe degrees latitude of the desired position to get the time for.
LongitudeThe degrees longitude of the desired position to get the time for.

AppendToList

Get Timezone Offset

Gets the timezone offset (in seconds) relative to GMT from a IANA timezone identifier.

ParameterDescription
Timezone IdentifierThe IANA timezone identifier, usually provided as <Country>/<City>.
If given UTC, returns the offset of UTC time (0).
Visit Wikipedia for a frequently updated list of names.
For the most updated list, visit the IANA registry and download the distribution file.

AppendToList

Generate Password

Generates secret password and stores it in a variable.

ParameterDescription
Variable NameThe name of the variable to store the generated password in.
Password LengthThe password length, default 10.
Include Special Chars[!-*] character set - !@#$%&*.
Include Lowercase Chars[a-z] character set - abcdedfghijklmnopqrst.
Include Uppercase Chars[A-Z] character set - ABCDEFGHIJKLMNOPQRSTUVWXYZ.
Include Digit Chars[0-9] character set - 0123456789.

Generate Password

Increment Variable

The Increment Variable utility action enables you to increment your variable by a value of one. You can choose the variable you would like to increment by selecting it from the dynamic dropdown menu.

AppendToList

Extend List

The Extend List utility action allows you to append an item to the end of your list or append a second list onto the end of your original list. You can choose the list you want to append to by clicking on the dynamic dropdown menu and selecting your preferred list.

ParameterDescription
Variable nameThe name of the original list variable
List to appendThe name of second list to append.
ValueName of the item to append to the list

The Extend List utility action enables you to:

  1. Append a variable to the end of an original list

AppendToList

  1. Append a second list to the end of an original list

AppendToList

  1. Append both a variable and a second list to the end of the original list

AppendToList

Encode Base64

Encodes the input text to base64 and prints the result to the output screen. The action supports either standard base64 or URL base64 encoding.

ParameterDescription
TextThe text to encode.
Encoding TypeThe type of encoding to decode: Standard or URL

Encode Base64

Decode Base64

Decodes the input text from base64 and prints the result to the output screen. The action supports either standard base64 or URL base64 encoding.

ParameterDescription
TextThe text to decode.
Encoding TypeThe type of encoding: Standard or URL

Decode Base64