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:

Open https://portal.apptigent.com in your browser, click "Create an account" and follow the prompts.
Login with your new credentials and select the "Apps" link from the main menu.
Click the "Create new App" button.
Enter a Title and optional description (such as "Power Automate App") then click "Submit".
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.
Browse to "API Products", select "PowerTools Professional", then click Subscribe under any paid plan (contact support for Enterprise and custom billing arrangements).
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 connection	100	60 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

Operation ID:: AddToCollection

Add an item to a collection

Parameters

Name	Key	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

Body: outputCollectionResult

Collections - Collection to JSON

Operation ID:: CollectionToJSON

Convert a collection to a named JSON object

Parameters

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

Returns

Body: outputString

Collections - Collection to XML

Operation ID:: CollectionToXml

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

Body: outputString

Collections - Contains number

Operation ID:: CollectionContainsNumber

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

Body: outputCollectionNumber

Collections - Contains string

Operation ID:: CollectionContainsString

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

Body: outputCollectionString

Collections - Count collection

Operation ID:: CountCollection

Count a collection of items

Parameters

Name	Key	Required	Type	Description
Collection	Collection		string

Returns

Body: outputNumber

Collections - Ends with string

Operation ID:: CollectionEndsWithString

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

Body: outputCollectionString

Collections - Filter collection

Operation ID:: FilterCollection

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

Body: outputCollectionResult

Collections - Remove from collection

Operation ID:: RemoveFromCollection

Remove an item from a collection

Parameters

Name	Key	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

Body: outputCollectionResult

Collections - Replace values in collection

Operation ID:: ReplaceValuesInCollection

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

Body: outputCollectionResult

Collections - Sort collection

Operation ID:: SortCollection

Sort a collection of strings

Parameters

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

Returns

Body: outputCollectionResult

Collections - Split collection

Operation ID:: SplitCollection

Split a collection of items by matching value or index

Parameters

Name	Key	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

Body: outputMultiCollection

Collections - Starts with string

Operation ID:: CollectionStartsWithString

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

Body: outputCollectionString

Currency - Convert currency

Operation ID:: ConvertCurrency

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

Body: outputNumber

Currency - Format currency

Operation ID:: FormatCurrency

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

Body: outputString

Data - CSV to JSON

Operation ID:: CsvToJson

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

Body: outputString

Data - JSON to CSV

Operation ID:: JsonToCsv

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

Body: outputString

Data - JSON to HTML Table

Operation ID:: JsonToHtml

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

Body: outputString

Data - JSON to XML

Operation ID:: JsonToXml

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

Body: outputString

Data - Query JSON

Operation ID:: QueryJson

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

Body: outputString

Data - Query XML

Operation ID:: QueryXml

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

Body: outputString

Data - XML to JSON

Operation ID:: XmlToJson

Convert an XML string to a JSON object

Parameters

Name	Key	Required	Type	Description
Value	input	True	string	XML string

Returns

Body: outputString

DateTime - DateTime difference

Operation ID:: DateTimeDifference

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

Body: outputDateDifference

DateTime - Format date and time

Operation ID:: FormatDateTime

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

Body: outputString

DateTime - Get date and time information

Operation ID:: DateTimeInfo

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

Body: outputDateInfo

DateTime - Get world time

Operation ID:: WorldTime

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

Body: outputString

Files - Convert Image

Operation ID:: ConvertImage

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

Operation ID:: CropImage

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

Operation ID:: FileToString

Convert a file to a Base64 string

Parameters

Name	Key	Required	Type	Description
File	file	True	file	Source file (10MB limit)

Returns

Body: outputString

Files - Flip Image

Operation ID:: FlipImage

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

Operation ID:: GenerateQRCode

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

Operation ID:: ResizeImage

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

Operation ID:: RotateImage

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

Operation ID:: WatermarkImage

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

Operation ID:: MarketIndex

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

Body: outputMarketIndex

Finance - Stock prices

Operation ID:: StockPrices

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

Body: outputStockPrice

Math - Calculate Absolute

Operation ID:: CalculateAbsolute

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

Body: outputNumber

Math - Calculate Addition

Operation ID:: CalculateAddition

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

Body: outputNumber

Math - Calculate average

Operation ID:: CalculateAverage

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

Body: outputNumber

Math - Calculate Cosine

Operation ID:: CalculateCosine

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

Body: outputNumber

Math - Calculate Division

Operation ID:: CalculateDivision

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

Body: outputNumber

Math - Calculate Logarithm

Operation ID:: CalculateLogarithm

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

Body: outputNumber

Math - Calculate median

Operation ID:: CalculateMedian

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

Body: outputNumber

Math - Calculate minimum or maximum

Operation ID:: CalculateMinMax

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

Body: outputNumber

Math - Calculate Modulo

Operation ID:: CalculateModulo

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

Body: outputNumber

Math - Calculate Multiplication

Operation ID:: CalculateMultiplication

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

Body: outputNumber

Math - Calculate Nth Root

Operation ID:: CalculateNthRoot

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

Body: outputNumber

Math - Calculate power

Operation ID:: CalculatePower

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

Body: outputNumber

Math - Calculate Sine

Operation ID:: CalculateSine

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

Body: outputNumber

Math - Calculate Square Root

Operation ID:: CalculateSquareRoot

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

Body: outputNumber

Math - Calculate standard deviation

Operation ID:: StandardDeviation

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

Body: outputNumber

Math - Calculate Subtraction

Operation ID:: CalculateSubtraction

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

Body: outputNumber

Math - Calculate sum

Operation ID:: CalculateSum

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

Body: outputNumber

Math - Calculate Tangent

Operation ID:: CalculateTangent

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

Body: outputNumber

Math - Calculate variance

Operation ID:: CalculateVariance

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

Body: outputNumber

Math - Convert angle

Operation ID:: ConvertAngle

Convert value from one angle measurement to another

Parameters

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

Returns

Body: outputNumber

Math - Convert area

Operation ID:: ConvertArea

Convert value from one area measurement to another

Parameters

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

Returns

Body: outputNumber

Math - Convert distance

Operation ID:: ConvertDistance

Convert value from one distance measurement to another

Parameters

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

Returns

Body: outputNumber

Math - Convert duration

Operation ID:: ConvertDuration

Convert value from one duration measurement to another

Parameters

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

Returns

Body: outputNumber

Math - Convert energy

Operation ID:: ConvertEnergy

Convert value from one energy measurement to another

Parameters

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

Returns

Body: outputNumber

Math - Convert power

Operation ID:: ConvertPower

Convert value from one power measurement to another

Parameters

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

Returns

Body: outputNumber

Math - Convert speed

Operation ID:: ConvertSpeed

Convert value from one speed measurement to another

Parameters

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

Returns

Body: outputNumber

Math - Convert temperature

Operation ID:: ConvertTemperature

Convert value from one temperature measurement to another

Parameters

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

Returns

Body: outputNumber

Math - Convert volume

Operation ID:: ConvertVolume

Convert value from one volume measurement to another

Parameters

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

Returns

Body: outputNumber

Math - Convert weight

Operation ID:: ConvertWeight

Convert value from one weight measurement to another

Parameters

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

Returns

Body: outputNumber

Math - Random number

Operation ID:: RandomNumber

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

Body: outputNumber

Math - Round number

Operation ID:: RoundNumber

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

Body: outputNumber

Text - Compare strings

Operation ID:: CompareStrings

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

Body: outputString

Text - Contains string

Operation ID:: ContainsString

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

Body: outputString

Text - Convert case

Operation ID:: ConvertCase

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

Body: outputString

Text - Decode string

Operation ID:: DecodeString

Decode a string encoded with Base64 encoding

Parameters

Name	Key	Required	Type	Description
Source	source	True	string	Encoded string variable or text value

Returns

Body: outputString

Text - Decode URL

Operation ID:: UrlDecode

Decode an encoded URL

Parameters

Name	Key	Required	Type	Description
Source	source	True	string	Encoded string variable or text value

Returns

Body: outputString

Text - Encode string

Operation ID:: EncodeString

Encode a string using Base64 encoding

Parameters

Name	Key	Required	Type	Description
Source	source	True	string	String variable or text value

Returns

Body: outputString

Text - Encode URL

Operation ID:: UrlEncode

Generate an encoded string from a complex hyperlink

Parameters

Name	Key	Required	Type	Description
Source	source	True	string	String variable or text value

Returns

Body: outputString

Text - Generate GUID

Operation ID:: GenerateGuid

Generate a globally unique identifier

Parameters

Name	Key	Required	Type	Description
Uppercase	uppercase	True	string	All uppercase alpha characters

Returns

Body: outputString

Text - Generate hash

Operation ID:: GenerateHash

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

Body: outputString

Text - Join strings

Operation ID:: JoinStrings

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

Body: outputString

Text - Redact string

Operation ID:: RedactString

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

Body: outputString

Text - Replace string

Operation ID:: ReplaceString

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

Body: outputString

Text - Shorten hyperlink

Operation ID:: ShortenLink

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

Body: outputString

Text - Speech to Text

Operation ID:: SpeechToText

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

Body: outputString

Text - Split string

Operation ID:: SplitString

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

Body: outputStringArray

Text - String to File

Operation ID:: StringToFile

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

Operation ID:: TextToSpeech

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

Operation ID:: TranslateString

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

Body: outputString

Text - Trim string

Operation ID:: TrimString

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

Body: outputString

Text - Validate email

Operation ID:: ValidateEmail

Determine if an email address is valid

Parameters

Name	Key	Required	Type	Description
Source	source	True	string	String variable or text value

Returns

Body: outputString

Text - Verify hash

Operation ID:: VerifyHash

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

Body: outputBoolean

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'.