Apptigent PowerTools (Preview)

Unlock the potential of Microsoft Power Platform with Apptigent PowerTools PRO. Manipulate text, modify collections, format dates and times, convert currency, perform advanced mathematical calculations, shorten URL's, encode strings, convert text to speech, translate content into multiple languages, and more. PowerTools PRO includes all the functionality from the LITE version plus over 40 advanced actions to take your apps, forms and flows to the next level.

This connector is available in the following products and regions:

Service Class Regions
Logic Apps Standard All Logic Apps regions except the following:
     -   Azure Government regions
     -   Azure China regions
Power Automate Premium All Power Automate regions except the following:
     -   US Government (GCC)
     -   US Government (GCC High)
     -   China Cloud operated by 21Vianet
Power Apps Premium All Power Apps regions except the following:
     -   US Government (GCC)
     -   US Government (GCC High)
     -   China Cloud operated by 21Vianet
Contact
Name Customer Support
URL https://www.apptigent.com/help/
Email support@apptigent.com
Connector Metadata
Publisher Apptigent Limited
Website https://www.apptigent.com
Privacy policy https://www.apptigent.com/help/privacy-policy/
Categories Productivity

Create user-driven solutions that solve everyday business problems in a fraction of the time with the ultimate toolkit for Power Platform professionals. Redact a sensitive document, localize currencies and dates, translate text into multiple languages, perform advanced calculations, convert text to speech and more with only a few clicks. PowerTools PRO eliminates the need for complex expression syntax and formulas, putting the power to build advanced solutions back in the hands of business users. Increase productivity, reduce delivery time and accelerate adoption with a powerful set of utilities designed to supercharge no-code apps, forms and workflows.

Prerequisites

Create an account and subscribe to PowerTools Professional Edition. Plans start at only $49 a month and scale to fit every budget. Learn more at https://portal.apptigent.com.

How to get credentials

Generate an API key by following these simple steps:

  1. Open https://portal.apptigent.com in your browser, click "Create an account" and follow the prompts.
  2. Login with your new credentials and select the "Apps" link from the main menu.
  3. Click the "Create new App" button.
  4. Enter a Title and optional description (such as "Power Automate App") then click "Submit".
  5. Upon successful submission, the App details page will be shown with your new credentials. Click the "Show" checkbox next to the Client ID field and copy the value - this is the key you will use in the "API Key" field to authorize a new connector.
  6. Browse to "API Products", select "PowerTools Professional", then click Subscribe under any paid plan (contact support for Enterprise and custom billing arrangements).
  7. Select the app name created in Step 4 and click "Subscribe" to finish.

Known issues and limitations

Professional Edition plans range from 100 - 5,000 action calls per day. Visit our Subscriptions page at https://www.apptigent.com/solutions/power-tools/subscription-plans/ to learn more about plan limits.

** SPECIAL OFFER FOR MICROSOFT MVP's **

Once registered, select the drop-down menu next to your user name and click "My Organization". Edit the organization name and add your MVP ID. Then navigate to subscriptions and select the "MVP" plan for a FREE PRO 100 subscription. You will receive an email confirming your benefit within 48 hours. You may then begin using your app Client ID in your Power Platform subscriptions (NOTE: for personal use only, not valid for customer, client or commercial purposes).

Creating a connection

The connector supports the following authentication types:

Default Required parameters for creating connection. All regions

Default

Applicable: All regions

Required parameters for creating connection.

Name Type Description
API Key securestring PowerTools PRO Client ID

Throttling Limits

Name Calls Renewal Period
API calls per connection10060 seconds

Actions

Collections - Add to collection

Add an item to a collection

Collections - Collection to JSON

Convert a collection to a named JSON object

Collections - Collection to XML

Convert a collection to an XML string

Collections - Contains number

Determine if a collection contains a specific number

Collections - Contains string

Determine if any items in a collection contain a specific string

Collections - Count collection

Count a collection of items

Collections - Ends with string

Determine if any items in a collection end with a specific string

Collections - Filter collection

Filter a collection of strings by keyword

Collections - Remove from collection

Remove an item from a collection

Collections - Replace values in collection

Replace whole or partial strings in a collection

Collections - Sort collection

Sort a collection of strings

Collections - Split collection

Split a collection of items by matching value or index

Collections - Starts with string

Determine if any items in a collection start with a specific string

Currency - Convert currency

Calculate monetary value in a different currency

Currency - Format currency

Apply currency symbol to a numeric value

Data - CSV to JSON

Convert a CSV string to a JSON array

Data - JSON to CSV

Convert a JSON array to CSV string

Data - JSON to HTML Table

Convert a JSON array to an HTML table

Data - JSON to XML

Convert a JSON object to an XML string

Data - Query JSON

Query a JSON object using a JSONPath expression

Data - Query XML

Query an XML string using an XPath expression

Data - XML to JSON

Convert an XML string to a JSON object

DateTime - DateTime difference

Calculate the difference between two dates

DateTime - Format date and time

Create a date/time string in a specific format

DateTime - Get date and time information

Retrieve useful date and time information, such as day of year, total seconds and ticks

DateTime - Get world time

Convert date and time from one time zone to another

Files - Convert Image

Convert an image from one format to another

Files - Crop Image

Crop an image

Files - File to string

Convert a file to a Base64 string

Files - Flip Image

Flip an image (horizontal or vertical)

Files - Generate QR code

Generate a QR code image

Files - Resize Image

Resize an image

Files - Rotate Image

Rotate an image by specified number of degrees

Files - Watermark Image

Add watermark text to an image

Finance - Market index

Get current and historical market index information

Finance - Stock prices

Get current and historical stock price information

Math - Calculate Absolute

Calculate the absolute value of a number

Math - Calculate Addition

Calculate the sum of two numbers

Math - Calculate average

Calculate the average of two or more numbers

Math - Calculate Cosine

Calculate the cosine value of an angle

Math - Calculate Division

Calculate the quotient of two numbers

Math - Calculate Logarithm

Calculate the logarithm of a number

Math - Calculate median

Calculate the median of two or more numbers

Math - Calculate minimum or maximum

Calculate the minimum or maximum value in a sequence of numbers

Math - Calculate Modulo

Calculate the remainder of dividing two numbers

Math - Calculate Multiplication

Calculate the product of two numbers

Math - Calculate Nth Root

Calculate the n-th root of a number

Math - Calculate power

Raise number to a specified power

Math - Calculate Sine

Calculate the sine value of an angle

Math - Calculate Square Root

Calculate the square root of a number

Math - Calculate standard deviation

Calculate the standard deviation of two or more numbers

Math - Calculate Subtraction

Calculate the difference between two numbers

Math - Calculate sum

Calculate the sum of two or more numbers

Math - Calculate Tangent

Calculate the tangent value of an angle

Math - Calculate variance

Calculate the statistical variance of two or more numbers

Math - Convert angle

Convert value from one angle measurement to another

Math - Convert area

Convert value from one area measurement to another

Math - Convert distance

Convert value from one distance measurement to another

Math - Convert duration

Convert value from one duration measurement to another

Math - Convert energy

Convert value from one energy measurement to another

Math - Convert power

Convert value from one power measurement to another

Math - Convert speed

Convert value from one speed measurement to another

Math - Convert temperature

Convert value from one temperature measurement to another

Math - Convert volume

Convert value from one volume measurement to another

Math - Convert weight

Convert value from one weight measurement to another

Math - Random number

Generate a random number within a specified range

Math - Round number

Round a numeric value up or down

Text - Compare strings

Perform a comparison of two strings

Text - Contains string

Determine if a string contains another string

Text - Convert case

Convert string to upper, lower or title case

Text - Decode string

Decode a string encoded with Base64 encoding

Text - Decode URL

Decode an encoded URL

Text - Encode string

Encode a string using Base64 encoding

Text - Encode URL

Generate an encoded string from a complex hyperlink

Text - Generate GUID

Generate a globally unique identifier

Text - Generate hash

Generate a hash value from a string

Text - Join strings

Join a collection of strings

Text - Redact string

Redact a strng containing sensitive content

Text - Replace string

Replace one value with another in a string

Text - Shorten hyperlink

Generate a simple, short URL from a complex URL

Text - Speech to Text

Convert audio file to text (10MB limit)

Text - Split string

Split a string based upon one or more characters

Text - String to File

Convert text string to file

Text - Text to Speech

Convert text to an audio file using AI-driven speech synthesis.

Text - Translate string

Translate a string into a different language

Text - Trim string

Trim leading or trailing whitespace from a string

Text - Validate email

Determine if an email address is valid

Text - Verify hash

Verify a hashed value against the original source string

Collections - Add to collection

Add an item to a collection

Parameters

Name Key Required Type Description
Collection
Collection string
Item
item string

Item (for multiple items, leave blank and use Items)

Items
Items string
Index
index string

Index position for operation (leave blank to specify end of collection)

Returns

Collections - Collection to JSON

Convert a collection to a named JSON object

Parameters

Name Key Required Type Description
Values
Values string
Name
name True string

Collection name

Returns

Collections - Collection to XML

Convert a collection to an XML string

Parameters

Name Key Required Type Description
Values
Values string
Root Node Name
root True string

Name of root XML node

Child Node Name
child True string

Name of child XML node(s)

Returns

Collections - Contains number

Determine if a collection contains a specific number

Parameters

Name Key Required Type Description
Values
Values number
Number
match True number

Number to match

Number Type
type string

Type of number - integer or decimal

Returns

Collections - Contains string

Determine if any items in a collection contain a specific string

Parameters

Name Key Required Type Description
Values
Values string
Text
match True string

Text to match

Trim
trim string

Trim white space from comparison string

Ignore Case
ignorecase string

Ignore case when performing comparison

Returns

Collections - Count collection

Count a collection of items

Parameters

Name Key Required Type Description
Collection
Collection string

Returns

Collections - Ends with string

Determine if any items in a collection end with a specific string

Parameters

Name Key Required Type Description
Values
Values string
Text
match True string

Text to match

Trim
trim string

Trim white space from comparison string

Ignore Case
ignorecase string

Ignore case when performing comparison

Returns

Collections - Filter collection

Filter a collection of strings by keyword

Parameters

Name Key Required Type Description
Collection
Collection string
Match
match True string

Match type

Keywords
keywords True string

Keywords (separate multiple values with commas)

Returns

Collections - Remove from collection

Remove an item from a collection

Parameters

Name Key Required Type Description
Collection
Collection string
Item
item string

Item (for multiple items, leave blank and use Items)

Items
Items string
Index
index string

Index position for operation (leave blank to specify end of collection)

Returns

Collections - Replace values in collection

Replace whole or partial strings in a collection

Parameters

Name Key Required Type Description
Collection
Collection string
Match value
match True string

Match value

Replacement value
replacement True string

Replacement value

Ignore case
ignoreCase True string

Ignore case

Returns

Collections - Sort collection

Sort a collection of strings

Parameters

Name Key Required Type Description
Collection
Collection string
Order
order True string

Sort order

Returns

Collections - Split collection

Split a collection of items by matching value or index

Parameters

Name Key Required Type Description
Collection
Collection string
Match Value
match string

String to match (explicit, case-insensitive, leave empty to use Index)

Index
index string

Index location to split (leave empty to use Match value)

Returns

Collections - Starts with string

Determine if any items in a collection start with a specific string

Parameters

Name Key Required Type Description
Values
Values string
Text
match True string

Text to match

Trim
trim string

Trim white space from comparison string

Ignore Case
ignorecase string

Ignore case when performing comparison

Returns

Currency - Convert currency

Calculate monetary value in a different currency

Parameters

Name Key Required Type Description
Value
input True number

Amount to convert

Source currency
source True string
Target currency
target True string

Returns

Currency - Format currency

Apply currency symbol to a numeric value

Parameters

Name Key Required Type Description
Value
input True number

Amount to format

Target currency
target True string

Returns

Data - CSV to JSON

Convert a CSV string to a JSON array

Parameters

Name Key Required Type Description
Value
input True string

CSV string

Header
header True boolean

Include header row

Returns

Data - JSON to CSV

Convert a JSON array to CSV string

Parameters

Name Key Required Type Description
Value
input True string

JSON array object

Header
header True boolean

Include header row

Omit Columns
omit string

Columns to omit (comma separated)

Order
order string

Column order (comma separated)

Returns

Data - JSON to HTML Table

Convert a JSON array to an HTML table

Parameters

Name Key Required Type Description
Value
input True string

JSON array object

Header
header True boolean

Include header row

Alternate Header
alternate string

Alternate header row markup

Table Attributes
attributes string

Optional table attributes (single quoted values)

Omit Columns
omit string

Columns to omit (comma separated)

Order
order string

Column order (comma separated)

Returns

Data - JSON to XML

Convert a JSON object to an XML string

Parameters

Name Key Required Type Description
Value
input True string

JSON array object

Root Name
root True string

Name of root node

Returns

Data - Query JSON

Query a JSON object using a JSONPath expression

Parameters

Name Key Required Type Description
Value
input True string

XML or JSON string

Query
query True string

XPath or JSONPath query

Returns

Data - Query XML

Query an XML string using an XPath expression

Parameters

Name Key Required Type Description
Value
input True string

XML or JSON string

Query
query True string

XPath or JSONPath query

Returns

Data - XML to JSON

Convert an XML string to a JSON object

Parameters

Name Key Required Type Description
Value
input True string

XML string

Returns

DateTime - DateTime difference

Calculate the difference between two dates

Parameters

Name Key Required Type Description
First date/time value
dateTime1 True string

First date/time value

Second date/time value
dateTime2 True string

Second date/time value

Returns

DateTime - Format date and time

Create a date/time string in a specific format

Parameters

Name Key Required Type Description
Value
input True string

Source date and time

Culture
culture True string

Language culture

Format
format True string

Output format

Returns

DateTime - Get date and time information

Retrieve useful date and time information, such as day of year, total seconds and ticks

Parameters

Name Key Required Type Description
Value
input True string

Source date and time

Culture
culture True string

Language culture

Returns

DateTime - Get world time

Convert date and time from one time zone to another

Parameters

Name Key Required Type Description
Value
input True string

Source date and time

Source Time Zone
source True string
Target Time Zone
target True string
Format
format string

Display format (defaults to 'yyyy-MM-dd HH:mm:ss')

Returns

Files - Convert Image

Convert an image from one format to another

Parameters

Name Key Required Type Description
Format
format True string

Output file format

File
file True file

Source image file

Returns

response
file

Files - Crop Image

Crop an image

Parameters

Name Key Required Type Description
Position
position True string

Crop start position (use negative values to reverse crop area)

Width
Width True number

Width (X-axis right, negative to reverse)

Height
Height True number

Height (Y-axis down, negative to reverse)

File
file True file

Source image file

Returns

response
file

Files - File to string

Convert a file to a Base64 string

Parameters

Name Key Required Type Description
File
file True file

Source file (10MB limit)

Returns

Files - Flip Image

Flip an image (horizontal or vertical)

Parameters

Name Key Required Type Description
Orientation
orientation True string

Horizontal or Vertical

File
file True file

Source image file

Returns

response
file

Files - Generate QR code

Generate a QR code image

Parameters

Name Key Required Type Description
Value
input True string

Text value(s) (vertical bar delimited by type)

Type
payload True string

Payload type

Returns

response
file

Files - Resize Image

Resize an image

Parameters

Name Key Required Type Description
Resampling Algorithm
algorithm True string

Optimize output quality of the target image

Units
units True string

Image adjustment units

Height
height number

Image height (pixels or percent)

Width
width number

Image width (pixels or percent)

File
file True file

Source image file

Returns

response
file

Files - Rotate Image

Rotate an image by specified number of degrees

Parameters

Name Key Required Type Description
Degrees
degrees True string

Number of degrees

File
file True file

Source image file

Returns

response
file

Files - Watermark Image

Add watermark text to an image

Parameters

Name Key Required Type Description
Text
text True string

Watermark text

Font
font True string

Text font

Font Size
size True number

Font size (points)

Text Color
color True string

Text color hex value

Horizontal
horizontal True string

Horizontal alignment

Vertical
vertical True string

Vertical alignment

File
file True file

Source image file

Returns

response
file

Finance - Market index

Get current and historical market index information

Parameters

Name Key Required Type Description
Index
symbol True string

Market index

Date
date string

Date (yyyy-MM-dd, leave empty for last trading day)

Returns

Finance - Stock prices

Get current and historical stock price information

Parameters

Name Key Required Type Description
Symbols
symbols True string

Stock ticker symbols (comma-separated, max 20)

Date
date string

Date (yyyy-MM-dd, leave empty for latest)

Exchange
exchange string

Stock exchange

Returns

Math - Calculate Absolute

Calculate the absolute value of a number

Parameters

Name Key Required Type Description
Value
input True number

Numeric value to calculate

Decimal Places
decimals True number

Round to number of decimal places

Returns

Math - Calculate Addition

Calculate the sum of two numbers

Parameters

Name Key Required Type Description
Primary Value
input True number

Numeric value

Secondary Value
value True number

Addend, subtrahend, factor, divisor or radicand

Decimal Places
decimals True number

Round to number of decimal places

Returns

Math - Calculate average

Calculate the average of two or more numbers

Parameters

Name Key Required Type Description
Values
Values number
Decimal Places
decimals True number

Round to number of decimal places

Returns

Math - Calculate Cosine

Calculate the cosine value of an angle

Parameters

Name Key Required Type Description
Value
input True number

Numeric value to calculate

Decimal Places
decimals True number

Round to number of decimal places

Returns

Math - Calculate Division

Calculate the quotient of two numbers

Parameters

Name Key Required Type Description
Primary Value
input True number

Numeric value

Secondary Value
value True number

Addend, subtrahend, factor, divisor or radicand

Decimal Places
decimals True number

Round to number of decimal places

Returns

Math - Calculate Logarithm

Calculate the logarithm of a number

Parameters

Name Key Required Type Description
Value
input True number

Numeric value to calculate

Decimal Places
decimals True number

Round to number of decimal places

Returns

Math - Calculate median

Calculate the median of two or more numbers

Parameters

Name Key Required Type Description
Values
Values number
Decimal Places
decimals True number

Round to number of decimal places

Returns

Math - Calculate minimum or maximum

Calculate the minimum or maximum value in a sequence of numbers

Parameters

Name Key Required Type Description
Values
Values number
Min or Max
type True string

Minimum or Maximum

Returns

Math - Calculate Modulo

Calculate the remainder of dividing two numbers

Parameters

Name Key Required Type Description
Primary Value
input True number

Numeric value

Secondary Value
value True number

Addend, subtrahend, factor, divisor or radicand

Decimal Places
decimals True number

Round to number of decimal places

Returns

Math - Calculate Multiplication

Calculate the product of two numbers

Parameters

Name Key Required Type Description
Primary Value
input True number

Numeric value

Secondary Value
value True number

Addend, subtrahend, factor, divisor or radicand

Decimal Places
decimals True number

Round to number of decimal places

Returns

Math - Calculate Nth Root

Calculate the n-th root of a number

Parameters

Name Key Required Type Description
Primary Value
input True number

Numeric value

Secondary Value
value True number

Addend, subtrahend, factor, divisor or radicand

Decimal Places
decimals True number

Round to number of decimal places

Returns

Math - Calculate power

Raise number to a specified power

Parameters

Name Key Required Type Description
Number
input True number

Number to raise

Power
power True number

Power

Decimal Places
decimals True number

Round to number of decimal places

Returns

Math - Calculate Sine

Calculate the sine value of an angle

Parameters

Name Key Required Type Description
Value
input True number

Numeric value to calculate

Decimal Places
decimals True number

Round to number of decimal places

Returns

Math - Calculate Square Root

Calculate the square root of a number

Parameters

Name Key Required Type Description
Value
input True number

Numeric value to calculate

Decimal Places
decimals True number

Round to number of decimal places

Returns

Math - Calculate standard deviation

Calculate the standard deviation of two or more numbers

Parameters

Name Key Required Type Description
Values
Values number
Decimal Places
decimals True number

Round to number of decimal places

Returns

Math - Calculate Subtraction

Calculate the difference between two numbers

Parameters

Name Key Required Type Description
Primary Value
input True number

Numeric value

Secondary Value
value True number

Addend, subtrahend, factor, divisor or radicand

Decimal Places
decimals True number

Round to number of decimal places

Returns

Math - Calculate sum

Calculate the sum of two or more numbers

Parameters

Name Key Required Type Description
Values
Values number
Decimal Places
decimals True number

Round to number of decimal places

Returns

Math - Calculate Tangent

Calculate the tangent value of an angle

Parameters

Name Key Required Type Description
Value
input True number

Numeric value to calculate

Decimal Places
decimals True number

Round to number of decimal places

Returns

Math - Calculate variance

Calculate the statistical variance of two or more numbers

Parameters

Name Key Required Type Description
Values
Values number
Decimal Places
decimals True number

Round to number of decimal places

Returns

Math - Convert angle

Convert value from one angle measurement to another

Parameters

Name Key Required Type Description
Measurement value
input True number
Source measurement
source True string
Target measurement
target True string

Returns

Math - Convert area

Convert value from one area measurement to another

Parameters

Name Key Required Type Description
Measurement value
input True number
Source measurement
source True string
Target measurement
target True string

Returns

Math - Convert distance

Convert value from one distance measurement to another

Parameters

Name Key Required Type Description
Measurement value
input True number
Source measurement
source True string
Target measurement
target True string

Returns

Math - Convert duration

Convert value from one duration measurement to another

Parameters

Name Key Required Type Description
Measurement value
input True number
Source measurement
source True string
Target measurement
target True string

Returns

Math - Convert energy

Convert value from one energy measurement to another

Parameters

Name Key Required Type Description
Measurement value
input True number
Source measurement
source True string
Target measurement
target True string

Returns

Math - Convert power

Convert value from one power measurement to another

Parameters

Name Key Required Type Description
Measurement value
input True number
Source measurement
source True string
Target measurement
target True string

Returns

Math - Convert speed

Convert value from one speed measurement to another

Parameters

Name Key Required Type Description
Measurement value
input True number
Source measurement
source True string
Target measurement
target True string

Returns

Math - Convert temperature

Convert value from one temperature measurement to another

Parameters

Name Key Required Type Description
Measurement value
input True number
Source measurement
source True string
Target measurement
target True string

Returns

Math - Convert volume

Convert value from one volume measurement to another

Parameters

Name Key Required Type Description
Measurement value
input True number
Source measurement
source True string
Target measurement
target True string

Returns

Math - Convert weight

Convert value from one weight measurement to another

Parameters

Name Key Required Type Description
Measurement value
input True number
Source measurement
source True string
Target measurement
target True string

Returns

Math - Random number

Generate a random number within a specified range

Parameters

Name Key Required Type Description
Start
start True number

Start of range

End
end True number

End of range

Returns

Math - Round number

Round a numeric value up or down

Parameters

Name Key Required Type Description
Value
input True number

Numeric value to calculate

Decimal Places
decimals True number

Round to number of decimal places

Returns

Text - Compare strings

Perform a comparison of two strings

Parameters

Name Key Required Type Description
Source
input True string

Original string

Target
compare True string

Comparison string

Lowercase
lower True string

Convert strings to lowercase before comparison

Trim
trim True string

Trim strings before comparison

Returns

Text - Contains string

Determine if a string contains another string

Parameters

Name Key Required Type Description
Value
find True string

Text to match

Target
input True string

Text to search

Lowercase
lower True string

Convert strings to lowercase

Returns

Text - Convert case

Convert string to upper, lower or title case

Parameters

Name Key Required Type Description
Value
input True string

String containing the text to convert

Case
alphacase True string

Case of conversion result

Returns

Text - Decode string

Decode a string encoded with Base64 encoding

Parameters

Name Key Required Type Description
Source
source True string

Encoded string variable or text value

Returns

Text - Decode URL

Decode an encoded URL

Parameters

Name Key Required Type Description
Source
source True string

Encoded string variable or text value

Returns

Text - Encode string

Encode a string using Base64 encoding

Parameters

Name Key Required Type Description
Source
source True string

String variable or text value

Returns

Text - Encode URL

Generate an encoded string from a complex hyperlink

Parameters

Name Key Required Type Description
Source
source True string

String variable or text value

Returns

Text - Generate GUID

Generate a globally unique identifier

Parameters

Name Key Required Type Description
Uppercase
uppercase True string

All uppercase alpha characters

Returns

Text - Generate hash

Generate a hash value from a string

Parameters

Name Key Required Type Description
Input
input True string

Hash source string

Algorithm
algorithm True string

Hash algorithm

Returns

Text - Join strings

Join a collection of strings

Parameters

Name Key Required Type Description
Values
Values string
Separator
separator True string

Separator character

Lowercase
lower True string

Convert strings in collection to lowercase

Trim
trim True string

Trim strings in collection

Returns

Text - Redact string

Redact a strng containing sensitive content

Parameters

Name Key Required Type Description
Source String
source True string

String containing the complete text

Value
value string

Individual string to redact

-OR- Values Collection
-OR- Values Collection string
-OR- Regular Expression
regex string

Regular expression pattern for matching strings

Returns

Text - Replace string

Replace one value with another in a string

Parameters

Name Key Required Type Description
Source
source True string

String containing the text to be replaced

Value
value True string

Text to replace

Replacement
replacement True string

Replacement text

Returns

Generate a simple, short URL from a complex URL

Parameters

Name Key Required Type Description
Source
source True string

String variable or text value

Returns

Text - Speech to Text

Convert audio file to text (10MB limit)

Parameters

Name Key Required Type Description
Language
language True string

Language of audio input

File
file True file

Source audio file (WAV, MP3, AAC, M4A)

Returns

Text - Split string

Split a string based upon one or more characters

Parameters

Name Key Required Type Description
Value
input True string

Text to split

Character(s)
characters True string

One or more characters that will be used to split the text

Returns

Text - String to File

Convert text string to file

Parameters

Name Key Required Type Description
Value
input True string

Text string (body of file)

Extension
extension True string

File extension

Filename
filename True string

Name of file (without extension)

Returns

response
file

Text - Text to Speech

Convert text to an audio file using AI-driven speech synthesis.

Parameters

Name Key Required Type Description
Text
text True string

Text to convert (10,000 characters max)

Text or file type
type True string

Text or file type

Voice
voice True string

Voice locale (must match language of input text)

Returns

response
file

Text - Translate string

Translate a string into a different language

Parameters

Name Key Required Type Description
Value
input True string

String containing the text to be translated

Language
language True string

Translation language

Returns

Text - Trim string

Trim leading or trailing whitespace from a string

Parameters

Name Key Required Type Description
Source
source True string

String containing the text to be trimmed

Type
type True string

Type of white space to remove

Returns

Text - Validate email

Determine if an email address is valid

Parameters

Name Key Required Type Description
Source
source True string

String variable or text value

Returns

Text - Verify hash

Verify a hashed value against the original source string

Parameters

Name Key Required Type Description
Input
input True string

Original source string

Algorithm
algorithm True string

Hash algorithm

Hash
hash True string

Hashed result

Returns

Definitions

outputStringArray

Name Path Type Description
data
data array of string

data

outputDateInfo

Name Path Type Description
DayOfYear
DayOfYear number

DayOfYear

DayOfWeek
DayOfWeek number

DayOfWeek

WeekOfYear
WeekOfYear number

WeekOfYear

SecondsInDay
SecondsInDay number

SecondsInDay

MinutesInDay
MinutesInDay number

MinutesInDay

Ticks
Ticks number

Ticks

outputDateDifference

Name Path Type Description
Years
years number

Years

Months
months number

Months

Days
days number

Days

Hours
hours number

Hours

Minutes
minutes number

Minutes

Milliseconds
milliseconds number

Milliseconds

Total Years
totalYears double

Total Years

Total Months
totalMonths double

Total Months

Total Days
totalDays double

Total Days

Total Hours
totalHours double

Total Hours

Total Minutes
totalMinutes double

Total Minutes

Total Seconds
totalSeconds double

Total Seconds

Total Milliseconds
totalMilliseconds double

Total Milliseconds

Ticks
ticks number

Ticks

outputCollectionNumber

Name Path Type Description
Success
status boolean

Success

First Value
item number

First Value

All Values
items array of number

All Values

outputCollectionResult

Name Path Type Description
Modified collection result
result array of string

Modified collection result

outputCollectionString

Name Path Type Description
Success
status boolean

Success

First Value
item string

First Value

All Values
items array of string

All Values

outputMultiCollection

Name Path Type Description
First collection result
result1 array of string

First collection result

Second collection result
result2 array of string

Second collection result

outputString

Name Path Type Description
Result
result string

Result

outputNumber

Name Path Type Description
Result
result number

Result

outputBoolean

Name Path Type Description
Result
result boolean

Result

outputStockPrice

Name Path Type Description
Stock price information
result array of object

Stock price information

Date
result.date string

Date

Symbol
result.symbol string

Ticker symbol

Exchange
result.exchange string

Stock exchange

Open
result.open number

Open

High
result.high number

High

Low
result.low number

Low

Close
result.close number

Close

Volume
result.volume number

Volume

outputMarketIndex

Name Path Type Description
Date
date string

Date

Symbol
symbol string

Index symbol

Exchange
exchange string

Market exchange

Open
open number

Open value

High
high number

High value

Low
low number

Low value

Close
close number

Close value

Volume
volume number

Trading volume

Adjusted Open
adj_open number

Adjusted open value

Adjusted High
adj_high number

Adjusted high value

Adjusted Low
adj_low number

Adjusted low value

Adjusted Close
adj_close number

Adjusted close value

Adjusted Volume
adj_volume number

Adjusted trading volume

file

This is the basic data type 'file'.