Connectors Reference

Apptigent PowerTools

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.

 

Status: Preview

Tier: Premium

Version: 1.3.0

 

Actions:

Name

Summary

AddToCollection ([Optional]inputCollectionModify collectionModify)

Collections - Add to collection

RemoveFromCollection ([Optional]inputCollectionModify collectionModify)

Collections - Remove from collection

FilterCollection ([Optional]inputCollectionFilter collectionFilter)

Collections - Filter collection

SortCollection ([Optional]inputCollectionSort collectionSort)

Collections - Sort collection

CountCollection ([Optional]inputCollectionCount collectionCount)

Collections - Count collection

SplitCollection ([Optional]inputCollectionSplit collectionSplit)

Collections - Split collection

ReplaceValuesInCollection ([Optional]inputCollectionReplace collectionReplace)

Collections - Replace values in collection

CollectionContainsString ([Optional]inputCollectionSearch collectionSearch)

Collections - Contains string

CollectionStartsWithString ([Optional]inputCollectionSearch collectionSearch)

Collections - Starts with string

CollectionEndsWithString ([Optional]inputCollectionSearch collectionSearch)

Collections - Ends with string

CollectionContainsNumber ([Optional]inputCollectionSearchNumeric collectionSearch)

Collections - Contains number

CollectionToJSON ([Optional]inputCollectionConversion collectionConversion)

Collections - Collection to JSON

CollectionToXml ([Optional]inputCollectionConversionXML collectionConversionXML)

Collections - Collection to XML

ConvertCurrency ([Optional]inputCurrencyConversion currencyConversion)

Currency - Convert currency

FormatCurrency ([Optional]inputCurrencyFormat currencyFormat)

Currency - Format currency

StockPrices ([Optional]inputStockPrices stockPrices)

Finance - Stock prices

MarketIndex ([Optional]inputMarketIndex marketIndex)

Finance - Market index

DateTimeInfo ([Optional]inputDateTimeInfo dateTimeInfo)

DateTime - Get date and time information

DateTimeDifference ([Optional]inputDateTimeDifference dateTimeDifference)

DateTime - DateTime difference

FormatDateTime ([Optional]inputDateTimeFormat dateTimeFormat)

DateTime - Format date and time

WorldTime ([Optional]inputDateTimeConversion dateTimeConversion)

DateTime - Get world time

CalculateAverage ([Optional]inputCalculateSeries calculateSeries)

Math - Calculate average

CalculateMedian ([Optional]inputCalculateSeries calculateSeries)

Math - Calculate median

CalculateMinMax ([Optional]inputCalculateMinMax calculateSeries)

Math - Calculate minimum or maximum

CalculateSum ([Optional]inputCalculateSeries calculateSeries)

Math - Calculate sum

CalculatePower ([Optional]inputCalculatePower calculatePower)

Math - Calculate power

CalculateVariance ([Optional]inputCalculateSeries calculateSeries)

Math - Calculate variance

CalculateAddition ([Optional]inputCalculateNumbers calculateNumbers)

Math - Calculate Addition

CalculateSubtraction ([Optional]inputCalculateNumbers calculateNumbers)

Math - Calculate Subtraction

CalculateMultiplication ([Optional]inputCalculateNumbers calculateNumbers)

Math - Calculate Multiplication

CalculateDivision ([Optional]inputCalculateNumbers calculateNumbers)

Math - Calculate Division

CalculateModulo ([Optional]inputCalculateNumbers calculateNumbers)

Math - Calculate Modulo

CalculateNthRoot ([Optional]inputCalculateNumbers calculateNumbers)

Math - Calculate Nth Root

CalculateSquareRoot ([Optional]inputCalculateNumber calculateNumber)

Math - Calculate Square Root

CalculateLogarithm ([Optional]inputCalculateNumber calculateNumber)

Math - Calculate Logarithm

CalculateSine ([Optional]inputCalculateNumber calculateNumber)

Math - Calculate Sine

CalculateCosine ([Optional]inputCalculateNumber calculateNumber)

Math - Calculate Cosine

CalculateTangent ([Optional]inputCalculateNumber calculateNumber)

Math - Calculate Tangent

CalculateAbsolute ([Optional]inputCalculateNumber calculateNumber)

Math - Calculate Absolute

ConvertAngle ([Optional]inputConvertAngle convertAngle)

Math - Convert angle

ConvertArea ([Optional]inputConvertArea convertArea)

Math - Convert area

ConvertDistance ([Optional]inputConvertDistance convertDistance)

Math - Convert distance

ConvertDuration ([Optional]inputConvertDuration convertDuration)

Math - Convert duration

ConvertEnergy ([Optional]inputConvertEnergy convertEnergy)

Math - Convert energy

ConvertPower ([Optional]inputConvertPower convertPower)

Math - Convert power

ConvertSpeed ([Optional]inputConvertSpeed convertSpeed)

Math - Convert speed

ConvertTemperature ([Optional]inputConvertTemperature convertTemperature)

Math - Convert temperature

ConvertVolume ([Optional]inputConvertVolume convertVolume)

Math - Convert volume

ConvertWeight ([Optional]inputConvertWeight convertWeight)

Math - Convert weight

RandomNumber ([Optional]inputNumberRange numberRange)

Math - Random number

RoundNumber ([Optional]inputCalculateNumber calculateNumber)

Math - Round number

StandardDeviation ([Optional]inputCalculateSeries calculateSeries)

Math - Calculate standard deviation

CompareStrings ([Optional]inputStringComparison stringComparison)

Text - Compare strings

ContainsString ([Optional]inputStringContains stringContains)

Text - Contains string

ConvertCase ([Optional]inputCaseConversion caseConversion)

Text - Convert case

DecodeString ([Optional]DecodeStringParameterStringInput stringInput)

Text - Decode string

EncodeString ([Optional]inputString stringInput)

Text - Encode string

GenerateGuid ([Optional]inputGenerateUniqueID generateUniqueID)

Text - Generate GUID

GenerateHash ([Optional]inputGenerateHash generateHash)

Text - Generate hash

VerifyHash ([Optional]inputVerifyHash verifyHash)

Text - Verify hash

JoinStrings ([Optional]inputJoinStrings joinStrings)

Text - Join strings

RedactString ([Optional]inputRedactString redactString)

Text - Redact string

ReplaceString ([Optional]inputReplaceString replaceString)

Text - Replace string

ShortenLink ([Optional]ShortenLinkParameterStringInput stringInput)

Text - Shorten hyperlink

SplitString ([Optional]inputSplitString splitString)

Text - Split string

SpeechToText (string language, file file)

Text - Speech to Text

TextToSpeech ([Optional]inputTextToSpeech textToSpeech)

Text - Text to Speech

TranslateString ([Optional]inputTranslateString translateString)

Text - Translate string

TrimString ([Optional]inputTrimString trimString)

Text - Trim string

UrlDecode ([Optional]UrlDecodeParameterStringInput stringInput)

Text - Decode URL

UrlEncode ([Optional]inputString stringInput)

Text - Encode URL

ValidateEmail ([Optional]ValidateEmailParameterStringInput stringInput)

Text - Validate email

JsonToHtml ([Optional]inputJsonConversionHTML jsonConversionHTML)

Data - JSON to HTML Table

JsonToCsv ([Optional]inputJsonConversionCSV jsonConversionCSV)

Data - JSON to CSV

JsonToXml ([Optional]inputJsonConversionXML jsonConversionXML)

Data - JSON to XML

CsvToJson ([Optional]inputCsvConversionJSON csvConversionJSON)

Data - CSV to JSON

XmlToJson ([Optional]inputXmlConversionJSON xmlConversionJSON)

Data - XML to JSON

QueryJson ([Optional]inputDataQuery inputDataQuery)

Data - Query JSON

QueryXml ([Optional]inputDataQuery inputDataQuery)

Data - Query XML

ConvertImage (string format, file file)

Files - Convert Image

ResizeImage (string algorithm, string units, [Optional]number height, [Optional]number width, file file)

Files - Resize Image

RotateImage (string degrees, file file)

Files - Rotate Image

FlipImage (string orientation, file file)

Files - Flip Image

WatermarkImage (string text, string font, number size, string color, string horizontal, string vertical, file file)

Files - Watermark Image

CropImage (string position, number Width, number Height, file file)

Files - Crop Image

GenerateQRCode ([Optional]inputQRCode inputQRCode)

Files - Generate QR code

FileToString (file file)

Files - File to string

StringToFile ([Optional]inputStringToFile inputStringToFile)

Text - String to File

 

Triggers:

Name

Summary

 

Objects:

Name

Summary

DecodeStringParameterStringInput

 

file

File

inputCalculateMinMax

 

inputCalculateNumber

 

inputCalculateNumbers

 

inputCalculatePower

 

inputCalculateSeries

 

inputCaseConversion

 

inputCollectionConversion

 

inputCollectionConversionXML

 

inputCollectionCount

 

inputCollectionFilter

 

inputCollectionModify

 

inputCollectionReplace

 

inputCollectionSearch

 

inputCollectionSearchNumeric

 

inputCollectionSort

 

inputCollectionSplit

 

inputConvertAngle

 

inputConvertArea

 

inputConvertDistance

 

inputConvertDuration

 

inputConvertEnergy

 

inputConvertPower

 

inputConvertSpeed

 

inputConvertTemperature

 

inputConvertVolume

 

inputConvertWeight

 

inputCsvConversionJSON

 

inputCurrencyConversion

 

inputCurrencyFormat

 

inputDataQuery

 

inputDateTimeConversion

 

inputDateTimeDifference

 

inputDateTimeFormat

 

inputDateTimeInfo

 

inputGenerateHash

 

inputGenerateUniqueID

 

inputJoinStrings

 

inputJsonConversionCSV

 

inputJsonConversionHTML

 

inputJsonConversionXML

 

inputMarketIndex

 

inputNumberRange

 

inputQRCode

 

inputRedactString

 

inputReplaceString

 

inputSplitString

 

inputStockPrices

 

inputString

 

inputStringComparison

 

inputStringContains

 

inputStringToFile

 

inputTextToSpeech

 

inputTranslateString

 

inputTrimString

 

inputVerifyHash

 

inputXmlConversionJSON

 

outputBoolean

 

outputCollectionNumber

 

outputCollectionResult

 

outputCollectionString

 

outputDateDifference

 

outputDateInfo

 

outputMarketIndex

 

outputMultiCollection

 

outputNumber

 

outputStockPrice

 

outputString

 

outputStringArray

 

ShortenLinkParameterStringInput

 

UrlDecodeParameterStringInput

 

ValidateEmailParameterStringInput

 

 

Actions:

AddToCollection

Summary: Collections - Add to collection

Description: Add an item to a collection

 

Syntax:

ApptigentPowerTools.AddToCollection ([Optional]inputCollectionModify collectionModify)

 

Parameters:

Name

Type

Summary

Required

Related Action

collectionModify

inputCollectionModify

 

 

False

 

Returns:

          Type:outputCollectionResult

 

RemoveFromCollection

Summary: Collections - Remove from collection

Description: Remove an item from a collection

 

Syntax:

ApptigentPowerTools.RemoveFromCollection ([Optional]inputCollectionModify collectionModify)

 

Parameters:

Name

Type

Summary

Required

Related Action

collectionModify

inputCollectionModify

 

 

False

 

Returns:

          Type:outputCollectionResult

 

FilterCollection

Summary: Collections - Filter collection

Description: Filter a collection of strings by keyword

 

Syntax:

ApptigentPowerTools.FilterCollection ([Optional]inputCollectionFilter collectionFilter)

 

Parameters:

Name

Type

Summary

Required

Related Action

collectionFilter

inputCollectionFilter

 

 

False

 

Returns:

          Type:outputCollectionResult

 

SortCollection

Summary: Collections - Sort collection

Description: Sort a collection of strings

 

Syntax:

ApptigentPowerTools.SortCollection ([Optional]inputCollectionSort collectionSort)

 

Parameters:

Name

Type

Summary

Required

Related Action

collectionSort

inputCollectionSort

 

 

False

 

Returns:

          Type:outputCollectionResult

 

CountCollection

Summary: Collections - Count collection

Description: Count a collection of items

 

Syntax:

ApptigentPowerTools.CountCollection ([Optional]inputCollectionCount collectionCount)

 

Parameters:

Name

Type

Summary

Required

Related Action

collectionCount

inputCollectionCount

 

 

False

 

Returns:

          Type:outputNumber

 

SplitCollection

Summary: Collections - Split collection

Description: Split a collection of items by matching value or index

 

Syntax:

ApptigentPowerTools.SplitCollection ([Optional]inputCollectionSplit collectionSplit)

 

Parameters:

Name

Type

Summary

Required

Related Action

collectionSplit

inputCollectionSplit

 

 

False

 

Returns:

          Type:outputMultiCollection

 

ReplaceValuesInCollection

Summary: Collections - Replace values in collection

Description: Replace whole or partial strings in a collection

 

Syntax:

ApptigentPowerTools.ReplaceValuesInCollection ([Optional]inputCollectionReplace collectionReplace)

 

Parameters:

Name

Type

Summary

Required

Related Action

collectionReplace

inputCollectionReplace

 

 

False

 

Returns:

          Type:outputCollectionResult

 

CollectionContainsString

Summary: Collections - Contains string

Description: Determine if any items in a collection contain a specific string

 

Syntax:

ApptigentPowerTools.CollectionContainsString ([Optional]inputCollectionSearch collectionSearch)

 

Parameters:

Name

Type

Summary

Required

Related Action

collectionSearch

inputCollectionSearch

 

 

False

 

Returns:

          Type:outputCollectionString

 

CollectionStartsWithString

Summary: Collections - Starts with string

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

 

Syntax:

ApptigentPowerTools.CollectionStartsWithString ([Optional]inputCollectionSearch collectionSearch)

 

Parameters:

Name

Type

Summary

Required

Related Action

collectionSearch

inputCollectionSearch

 

 

False

 

Returns:

          Type:outputCollectionString

 

CollectionEndsWithString

Summary: Collections - Ends with string

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

 

Syntax:

ApptigentPowerTools.CollectionEndsWithString ([Optional]inputCollectionSearch collectionSearch)

 

Parameters:

Name

Type

Summary

Required

Related Action

collectionSearch

inputCollectionSearch

 

 

False

 

Returns:

          Type:outputCollectionString

 

CollectionContainsNumber

Summary: Collections - Contains number

Description: Determine if a collection contains a specific number

 

Syntax:

ApptigentPowerTools.CollectionContainsNumber ([Optional]inputCollectionSearchNumeric collectionSearch)

 

Parameters:

Name

Type

Summary

Required

Related Action

collectionSearch

inputCollectionSearchNumeric

 

 

False

 

Returns:

          Type:outputCollectionNumber

 

CollectionToJSON

Summary: Collections - Collection to JSON

Description: Convert a collection to a named JSON object

 

Syntax:

ApptigentPowerTools.CollectionToJSON ([Optional]inputCollectionConversion collectionConversion)

 

Parameters:

Name

Type

Summary

Required

Related Action

collectionConversion

inputCollectionConversion

 

 

False

 

Returns:

          Type:outputString

 

CollectionToXml

Summary: Collections - Collection to XML

Description: Convert a collection to an XML string

 

Syntax:

ApptigentPowerTools.CollectionToXml ([Optional]inputCollectionConversionXML collectionConversionXML)

 

Parameters:

Name

Type

Summary

Required

Related Action

collectionConversionXML

inputCollectionConversionXML

 

 

False

 

Returns:

          Type:outputString

 

ConvertCurrency

Summary: Currency - Convert currency

Description: Calculate monetary value in a different currency

 

Syntax:

ApptigentPowerTools.ConvertCurrency ([Optional]inputCurrencyConversion currencyConversion)

 

Parameters:

Name

Type

Summary

Required

Related Action

currencyConversion

inputCurrencyConversion

 

 

False

 

Returns:

          Type:outputNumber

 

FormatCurrency

Summary: Currency - Format currency

Description: Apply currency symbol to a numeric value

 

Syntax:

ApptigentPowerTools.FormatCurrency ([Optional]inputCurrencyFormat currencyFormat)

 

Parameters:

Name

Type

Summary

Required

Related Action

currencyFormat

inputCurrencyFormat

 

 

False

 

Returns:

          Type:outputString

 

StockPrices

Summary: Finance - Stock prices

Description: Get current and historical stock price information

 

Syntax:

ApptigentPowerTools.StockPrices ([Optional]inputStockPrices stockPrices)

 

Parameters:

Name

Type

Summary

Required

Related Action

stockPrices

inputStockPrices

 

 

False

 

Returns:

          Type:outputStockPrice

 

MarketIndex

Summary: Finance - Market index

Description: Get current and historical market index information

 

Syntax:

ApptigentPowerTools.MarketIndex ([Optional]inputMarketIndex marketIndex)

 

Parameters:

Name

Type

Summary

Required

Related Action

marketIndex

inputMarketIndex

 

 

False

 

Returns:

          Type:outputMarketIndex

 

DateTimeInfo

Summary: DateTime - Get date and time information

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

 

Syntax:

ApptigentPowerTools.DateTimeInfo ([Optional]inputDateTimeInfo dateTimeInfo)

 

Parameters:

Name

Type

Summary

Required

Related Action

dateTimeInfo

inputDateTimeInfo

 

 

False

 

Returns:

          Type:outputDateInfo

 

DateTimeDifference

Summary: DateTime - DateTime difference

Description: Calculate the difference between two dates

 

Syntax:

ApptigentPowerTools.DateTimeDifference ([Optional]inputDateTimeDifference dateTimeDifference)

 

Parameters:

Name

Type

Summary

Required

Related Action

dateTimeDifference

inputDateTimeDifference

 

 

False

 

Returns:

          Type:outputDateDifference

 

FormatDateTime

Summary: DateTime - Format date and time

Description: Create a date/time string in a specific format

 

Syntax:

ApptigentPowerTools.FormatDateTime ([Optional]inputDateTimeFormat dateTimeFormat)

 

Parameters:

Name

Type

Summary

Required

Related Action

dateTimeFormat

inputDateTimeFormat

 

 

False

 

Returns:

          Type:outputString

 

WorldTime

Summary: DateTime - Get world time

Description: Convert date and time from one time zone to another

 

Syntax:

ApptigentPowerTools.WorldTime ([Optional]inputDateTimeConversion dateTimeConversion)

 

Parameters:

Name

Type

Summary

Required

Related Action

dateTimeConversion

inputDateTimeConversion

 

 

False

 

Returns:

          Type:outputString

 

CalculateAverage

Summary: Math - Calculate average

Description: Calculate the average of two or more numbers

 

Syntax:

ApptigentPowerTools.CalculateAverage ([Optional]inputCalculateSeries calculateSeries)

 

Parameters:

Name

Type

Summary

Required

Related Action

calculateSeries

inputCalculateSeries

 

 

False

 

Returns:

          Type:outputNumber

 

CalculateMedian

Summary: Math - Calculate median

Description: Calculate the median of two or more numbers

 

Syntax:

ApptigentPowerTools.CalculateMedian ([Optional]inputCalculateSeries calculateSeries)

 

Parameters:

Name

Type

Summary

Required

Related Action

calculateSeries

inputCalculateSeries

 

 

False

 

Returns:

          Type:outputNumber

 

CalculateMinMax

Summary: Math - Calculate minimum or maximum

Description: Calculate the minimum or maximum value in a sequence of numbers

 

Syntax:

ApptigentPowerTools.CalculateMinMax ([Optional]inputCalculateMinMax calculateSeries)

 

Parameters:

Name

Type

Summary

Required

Related Action

calculateSeries

inputCalculateMinMax

 

 

False

 

Returns:

          Type:outputNumber

 

CalculateSum

Summary: Math - Calculate sum

Description: Calculate the sum of two or more numbers

 

Syntax:

ApptigentPowerTools.CalculateSum ([Optional]inputCalculateSeries calculateSeries)

 

Parameters:

Name

Type

Summary

Required

Related Action

calculateSeries

inputCalculateSeries

 

 

False

 

Returns:

          Type:outputNumber

 

CalculatePower

Summary: Math - Calculate power

Description: Raise number to a specified power

 

Syntax:

ApptigentPowerTools.CalculatePower ([Optional]inputCalculatePower calculatePower)

 

Parameters:

Name

Type

Summary

Required

Related Action

calculatePower

inputCalculatePower

 

 

False

 

Returns:

          Type:outputNumber

 

CalculateVariance

Summary: Math - Calculate variance

Description: Calculate the statistical variance of two or more numbers

 

Syntax:

ApptigentPowerTools.CalculateVariance ([Optional]inputCalculateSeries calculateSeries)

 

Parameters:

Name

Type

Summary

Required

Related Action

calculateSeries

inputCalculateSeries

 

 

False

 

Returns:

          Type:outputNumber

 

CalculateAddition

Summary: Math - Calculate Addition

Description: Calculate the sum of two numbers

 

Syntax:

ApptigentPowerTools.CalculateAddition ([Optional]inputCalculateNumbers calculateNumbers)

 

Parameters:

Name

Type

Summary

Required

Related Action

calculateNumbers

inputCalculateNumbers

 

 

False

 

Returns:

          Type:outputNumber

 

CalculateSubtraction

Summary: Math - Calculate Subtraction

Description: Calculate the difference between two numbers

 

Syntax:

ApptigentPowerTools.CalculateSubtraction ([Optional]inputCalculateNumbers calculateNumbers)

 

Parameters:

Name

Type

Summary

Required

Related Action

calculateNumbers

inputCalculateNumbers

 

 

False

 

Returns:

          Type:outputNumber

 

CalculateMultiplication

Summary: Math - Calculate Multiplication

Description: Calculate the product of two numbers

 

Syntax:

ApptigentPowerTools.CalculateMultiplication ([Optional]inputCalculateNumbers calculateNumbers)

 

Parameters:

Name

Type

Summary

Required

Related Action

calculateNumbers

inputCalculateNumbers

 

 

False

 

Returns:

          Type:outputNumber

 

CalculateDivision

Summary: Math - Calculate Division

Description: Calculate the quotient of two numbers

 

Syntax:

ApptigentPowerTools.CalculateDivision ([Optional]inputCalculateNumbers calculateNumbers)

 

Parameters:

Name

Type

Summary

Required

Related Action

calculateNumbers

inputCalculateNumbers

 

 

False

 

Returns:

          Type:outputNumber

 

CalculateModulo

Summary: Math - Calculate Modulo

Description: Calculate the remainder of dividing two numbers

 

Syntax:

ApptigentPowerTools.CalculateModulo ([Optional]inputCalculateNumbers calculateNumbers)

 

Parameters:

Name

Type

Summary

Required

Related Action

calculateNumbers

inputCalculateNumbers

 

 

False

 

Returns:

          Type:outputNumber

 

CalculateNthRoot

Summary: Math - Calculate Nth Root

Description: Calculate the n-th root of a number

 

Syntax:

ApptigentPowerTools.CalculateNthRoot ([Optional]inputCalculateNumbers calculateNumbers)

 

Parameters:

Name

Type

Summary

Required

Related Action

calculateNumbers

inputCalculateNumbers

 

 

False

 

Returns:

          Type:outputNumber

 

CalculateSquareRoot

Summary: Math - Calculate Square Root

Description: Calculate the square root of a number

 

Syntax:

ApptigentPowerTools.CalculateSquareRoot ([Optional]inputCalculateNumber calculateNumber)

 

Parameters:

Name

Type

Summary

Required

Related Action

calculateNumber

inputCalculateNumber

 

 

False

 

Returns:

          Type:outputNumber

 

CalculateLogarithm

Summary: Math - Calculate Logarithm

Description: Calculate the logarithm of a number

 

Syntax:

ApptigentPowerTools.CalculateLogarithm ([Optional]inputCalculateNumber calculateNumber)

 

Parameters:

Name

Type

Summary

Required

Related Action

calculateNumber

inputCalculateNumber

 

 

False

 

Returns:

          Type:outputNumber

 

CalculateSine

Summary: Math - Calculate Sine

Description: Calculate the sine value of an angle

 

Syntax:

ApptigentPowerTools.CalculateSine ([Optional]inputCalculateNumber calculateNumber)

 

Parameters:

Name

Type

Summary

Required

Related Action

calculateNumber

inputCalculateNumber

 

 

False

 

Returns:

          Type:outputNumber

 

CalculateCosine

Summary: Math - Calculate Cosine

Description: Calculate the cosine value of an angle

 

Syntax:

ApptigentPowerTools.CalculateCosine ([Optional]inputCalculateNumber calculateNumber)

 

Parameters:

Name

Type

Summary

Required

Related Action

calculateNumber

inputCalculateNumber

 

 

False

 

Returns:

          Type:outputNumber

 

CalculateTangent

Summary: Math - Calculate Tangent

Description: Calculate the tangent value of an angle

 

Syntax:

ApptigentPowerTools.CalculateTangent ([Optional]inputCalculateNumber calculateNumber)

 

Parameters:

Name

Type

Summary

Required

Related Action

calculateNumber

inputCalculateNumber

 

 

False

 

Returns:

          Type:outputNumber

 

CalculateAbsolute

Summary: Math - Calculate Absolute

Description: Calculate the absolute value of a number

 

Syntax:

ApptigentPowerTools.CalculateAbsolute ([Optional]inputCalculateNumber calculateNumber)

 

Parameters:

Name

Type

Summary

Required

Related Action

calculateNumber

inputCalculateNumber

 

 

False

 

Returns:

          Type:outputNumber

 

ConvertAngle

Summary: Math - Convert angle

Description: Convert value from one angle measurement to another

 

Syntax:

ApptigentPowerTools.ConvertAngle ([Optional]inputConvertAngle convertAngle)

 

Parameters:

Name

Type

Summary

Required

Related Action

convertAngle

inputConvertAngle

 

 

False

 

Returns:

          Type:outputNumber

 

ConvertArea

Summary: Math - Convert area

Description: Convert value from one area measurement to another

 

Syntax:

ApptigentPowerTools.ConvertArea ([Optional]inputConvertArea convertArea)

 

Parameters:

Name

Type

Summary

Required

Related Action

convertArea

inputConvertArea

 

 

False

 

Returns:

          Type:outputNumber

 

ConvertDistance

Summary: Math - Convert distance

Description: Convert value from one distance measurement to another

 

Syntax:

ApptigentPowerTools.ConvertDistance ([Optional]inputConvertDistance convertDistance)

 

Parameters:

Name

Type

Summary

Required

Related Action

convertDistance

inputConvertDistance

 

 

False

 

Returns:

          Type:outputNumber

 

ConvertDuration

Summary: Math - Convert duration

Description: Convert value from one duration measurement to another

 

Syntax:

ApptigentPowerTools.ConvertDuration ([Optional]inputConvertDuration convertDuration)

 

Parameters:

Name

Type

Summary

Required

Related Action

convertDuration

inputConvertDuration

 

 

False

 

Returns:

          Type:outputNumber

 

ConvertEnergy

Summary: Math - Convert energy

Description: Convert value from one energy measurement to another

 

Syntax:

ApptigentPowerTools.ConvertEnergy ([Optional]inputConvertEnergy convertEnergy)

 

Parameters:

Name

Type

Summary

Required

Related Action

convertEnergy

inputConvertEnergy

 

 

False

 

Returns:

          Type:outputNumber

 

ConvertPower

Summary: Math - Convert power

Description: Convert value from one power measurement to another

 

Syntax:

ApptigentPowerTools.ConvertPower ([Optional]inputConvertPower convertPower)

 

Parameters:

Name

Type

Summary

Required

Related Action

convertPower

inputConvertPower

 

 

False

 

Returns:

          Type:outputNumber

 

ConvertSpeed

Summary: Math - Convert speed

Description: Convert value from one speed measurement to another

 

Syntax:

ApptigentPowerTools.ConvertSpeed ([Optional]inputConvertSpeed convertSpeed)

 

Parameters:

Name

Type

Summary

Required

Related Action

convertSpeed

inputConvertSpeed

 

 

False

 

Returns:

          Type:outputNumber

 

ConvertTemperature

Summary: Math - Convert temperature

Description: Convert value from one temperature measurement to another

 

Syntax:

ApptigentPowerTools.ConvertTemperature ([Optional]inputConvertTemperature convertTemperature)

 

Parameters:

Name

Type

Summary

Required

Related Action

convertTemperature

inputConvertTemperature

 

 

False

 

Returns:

          Type:outputNumber

 

ConvertVolume

Summary: Math - Convert volume

Description: Convert value from one volume measurement to another

 

Syntax:

ApptigentPowerTools.ConvertVolume ([Optional]inputConvertVolume convertVolume)

 

Parameters:

Name

Type

Summary

Required

Related Action

convertVolume

inputConvertVolume

 

 

False

 

Returns:

          Type:outputNumber

 

ConvertWeight

Summary: Math - Convert weight

Description: Convert value from one weight measurement to another

 

Syntax:

ApptigentPowerTools.ConvertWeight ([Optional]inputConvertWeight convertWeight)

 

Parameters:

Name

Type

Summary

Required

Related Action

convertWeight

inputConvertWeight

 

 

False

 

Returns:

          Type:outputNumber

 

RandomNumber

Summary: Math - Random number

Description: Generate a random number within a specified range

 

Syntax:

ApptigentPowerTools.RandomNumber ([Optional]inputNumberRange numberRange)

 

Parameters:

Name

Type

Summary

Required

Related Action

numberRange

inputNumberRange

 

 

False

 

Returns:

          Type:outputNumber

 

RoundNumber

Summary: Math - Round number

Description: Round a numeric value up or down

 

Syntax:

ApptigentPowerTools.RoundNumber ([Optional]inputCalculateNumber calculateNumber)

 

Parameters:

Name

Type

Summary

Required

Related Action

calculateNumber

inputCalculateNumber

 

 

False

 

Returns:

          Type:outputNumber

 

StandardDeviation

Summary: Math - Calculate standard deviation

Description: Calculate the standard deviation of two or more numbers

 

Syntax:

ApptigentPowerTools.StandardDeviation ([Optional]inputCalculateSeries calculateSeries)

 

Parameters:

Name

Type

Summary

Required

Related Action

calculateSeries

inputCalculateSeries

 

 

False

 

Returns:

          Type:outputNumber

 

CompareStrings

Summary: Text - Compare strings

Description: Perform a comparison of two strings

 

Syntax:

ApptigentPowerTools.CompareStrings ([Optional]inputStringComparison stringComparison)

 

Parameters:

Name

Type

Summary

Required

Related Action

stringComparison

inputStringComparison

 

 

False

 

Returns:

          Type:outputString

 

ContainsString

Summary: Text - Contains string

Description: Determine if a string contains another string

 

Syntax:

ApptigentPowerTools.ContainsString ([Optional]inputStringContains stringContains)

 

Parameters:

Name

Type

Summary

Required

Related Action

stringContains

inputStringContains

 

 

False

 

Returns:

          Type:outputString

 

ConvertCase

Summary: Text - Convert case

Description: Convert string to upper, lower or title case

 

Syntax:

ApptigentPowerTools.ConvertCase ([Optional]inputCaseConversion caseConversion)

 

Parameters:

Name

Type

Summary

Required

Related Action

caseConversion

inputCaseConversion

 

 

False

 

Returns:

          Type:outputString

 

DecodeString

Summary: Text - Decode string

Description: Decode a string encoded with Base64 encoding

 

Syntax:

ApptigentPowerTools.DecodeString ([Optional]DecodeStringParameterStringInput stringInput)

 

Parameters:

Name

Type

Summary

Required

Related Action

stringInput

DecodeStringParameterStringInput

 

 

False

 

Returns:

          Type:outputString

 

EncodeString

Summary: Text - Encode string

Description: Encode a string using Base64 encoding

 

Syntax:

ApptigentPowerTools.EncodeString ([Optional]inputString stringInput)

 

Parameters:

Name

Type

Summary

Required

Related Action

stringInput

inputString

 

 

False

 

Returns:

          Type:outputString

 

GenerateGuid

Summary: Text - Generate GUID

Description: Generate a globally unique identifier

 

Syntax:

ApptigentPowerTools.GenerateGuid ([Optional]inputGenerateUniqueID generateUniqueID)

 

Parameters:

Name

Type

Summary

Required

Related Action

generateUniqueID

inputGenerateUniqueID

 

 

False

 

Returns:

          Type:outputString

 

GenerateHash

Summary: Text - Generate hash

Description: Generate a hash value from a string

 

Syntax:

ApptigentPowerTools.GenerateHash ([Optional]inputGenerateHash generateHash)

 

Parameters:

Name

Type

Summary

Required

Related Action

generateHash

inputGenerateHash

 

 

False

 

Returns:

          Type:outputString

 

VerifyHash

Summary: Text - Verify hash

Description: Verify a hashed value against the original source string

 

Syntax:

ApptigentPowerTools.VerifyHash ([Optional]inputVerifyHash verifyHash)

 

Parameters:

Name

Type

Summary

Required

Related Action

verifyHash

inputVerifyHash

 

 

False

 

Returns:

          Type:outputBoolean

 

JoinStrings

Summary: Text - Join strings

Description: Join a collection of strings

 

Syntax:

ApptigentPowerTools.JoinStrings ([Optional]inputJoinStrings joinStrings)

 

Parameters:

Name

Type

Summary

Required

Related Action

joinStrings

inputJoinStrings

 

 

False

 

Returns:

          Type:outputString

 

RedactString

Summary: Text - Redact string

Description: Redact a strng containing sensitive content

 

Syntax:

ApptigentPowerTools.RedactString ([Optional]inputRedactString redactString)

 

Parameters:

Name

Type

Summary

Required

Related Action

redactString

inputRedactString

 

 

False

 

Returns:

          Type:outputString

 

ReplaceString

Summary: Text - Replace string

Description: Replace one value with another in a string

 

Syntax:

ApptigentPowerTools.ReplaceString ([Optional]inputReplaceString replaceString)

 

Parameters:

Name

Type

Summary

Required

Related Action

replaceString

inputReplaceString

 

 

False

 

Returns:

          Type:outputString

 

ShortenLink

Summary: Text - Shorten hyperlink

Description: Generate a simple, short URL from a complex URL

 

Syntax:

ApptigentPowerTools.ShortenLink ([Optional]ShortenLinkParameterStringInput stringInput)

 

Parameters:

Name

Type

Summary

Required

Related Action

stringInput

ShortenLinkParameterStringInput

 

 

False

 

Returns:

          Type:outputString

 

SplitString

Summary: Text - Split string

Description: Split a string based upon one or more characters

 

Syntax:

ApptigentPowerTools.SplitString ([Optional]inputSplitString splitString)

 

Parameters:

Name

Type

Summary

Required

Related Action

splitString

inputSplitString

 

 

False

 

Returns:

          Type:outputStringArray

 

SpeechToText

Summary: Text - Speech to Text

Description: Convert audio file to text (10MB limit)

 

Syntax:

ApptigentPowerTools.SpeechToText (string language, file file)

 

Parameters:

Name

Type

Summary

Required

Related Action

language

string

(Language)Values: [Arabic (Bahrain), Arabic (Egypt), Arabic (Iraq), Arabic (Jordan), Arabic (Kuwait), Arabic (Lebanon), Arabic (Oman), Arabic (Qatar), Arabic (Saudi Arabia), Arabic (Syria), Arabic (United Arab Emirates), Bulgarian (Bulgaria), Catalan (Spain), Chinese (Cantonese, Traditional), Chinese (Mandarin, Simplified), Chinese (Taiwanese Mandarin), Croatian (Croatia), Czech (Czech Republic), Danish (Denmark), Dutch (Netherlands), English (Australia), English (Canada), English (Hong Kong), English (India), English (Ireland), English (New Zealand), English (Philippines), English (Singapore), English (South Africa), English (United Kingdom), English (United States), Estonian(Estonia), Finnish (Finland), French (Canada), French (France), German (Germany), Greek (Greece), Gujarati (Indian), Hindi (India), Hungarian (Hungary), Irish(Ireland), Italian (Italy), Japanese (Japan), Korean (Korea), Latvian (Latvia), Lithuanian (Lithuania), Maltese(Malta), Marathi (India), Norwegian (Norway), Polish (Poland), Portuguese (Brazil), Portuguese (Portugal), Romanian (Romania), Russian (Russia), Slovak (Slovakia), Slovenian (Slovenia), Spanish (Argentina), Spanish (Bolivia), Spanish (Chile), Spanish (Colombia), Spanish (Costa Rica), Spanish (Cuba), Spanish (Dominican Republic), Spanish (Ecuador), Spanish (El Salvador), Spanish (Guatemala), Spanish (Honduras), Spanish (Mexico), Spanish (Nicaragua), Spanish (Panama), Spanish (Paraguay), Spanish (Peru), Spanish (Puerto Rico), Spanish (Spain), Spanish (Uruguay), Spanish (USA), Spanish (Venezuela), Swedish (Sweden), Tamil (India), Telugu (India), Thai (Thailand), Turkish (Turkey)]

Language of audio input

True

file

file

(File)

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

True

 

Returns:

          Type:outputString

 

TextToSpeech

Summary: Text - Text to Speech

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

 

Syntax:

ApptigentPowerTools.TextToSpeech ([Optional]inputTextToSpeech textToSpeech)

 

Parameters:

Name

Type

Summary

Required

Related Action

textToSpeech

inputTextToSpeech

 

 

False

 

Returns:

          Type:file

 

TranslateString

Summary: Text - Translate string

Description: Translate a string into a different language

 

Syntax:

ApptigentPowerTools.TranslateString ([Optional]inputTranslateString translateString)

 

Parameters:

Name

Type

Summary

Required

Related Action

translateString

inputTranslateString

 

 

False

 

Returns:

          Type:outputString

 

TrimString

Summary: Text - Trim string

Description: Trim leading or trailing whitespace from a string

 

Syntax:

ApptigentPowerTools.TrimString ([Optional]inputTrimString trimString)

 

Parameters:

Name

Type

Summary

Required

Related Action

trimString

inputTrimString

 

 

False

 

Returns:

          Type:outputString

 

UrlDecode

Summary: Text - Decode URL

Description: Decode an encoded URL

 

Syntax:

ApptigentPowerTools.UrlDecode ([Optional]UrlDecodeParameterStringInput stringInput)

 

Parameters:

Name

Type

Summary

Required

Related Action

stringInput

UrlDecodeParameterStringInput

 

 

False

 

Returns:

          Type:outputString

 

UrlEncode

Summary: Text - Encode URL

Description: Generate an encoded string from a complex hyperlink

 

Syntax:

ApptigentPowerTools.UrlEncode ([Optional]inputString stringInput)

 

Parameters:

Name

Type

Summary

Required

Related Action

stringInput

inputString

 

 

False

 

Returns:

          Type:outputString

 

ValidateEmail

Summary: Text - Validate email

Description: Determine if an email address is valid

 

Syntax:

ApptigentPowerTools.ValidateEmail ([Optional]ValidateEmailParameterStringInput stringInput)

 

Parameters:

Name

Type

Summary

Required

Related Action

stringInput

ValidateEmailParameterStringInput

 

 

False

 

Returns:

          Type:outputString

 

JsonToHtml

Summary: Data - JSON to HTML Table

Description: Convert a JSON array to an HTML table

 

Syntax:

ApptigentPowerTools.JsonToHtml ([Optional]inputJsonConversionHTML jsonConversionHTML)

 

Parameters:

Name

Type

Summary

Required

Related Action

jsonConversionHTML

inputJsonConversionHTML

 

 

False

 

Returns:

          Type:outputString

 

JsonToCsv

Summary: Data - JSON to CSV

Description: Convert a JSON array to CSV string

 

Syntax:

ApptigentPowerTools.JsonToCsv ([Optional]inputJsonConversionCSV jsonConversionCSV)

 

Parameters:

Name

Type

Summary

Required

Related Action

jsonConversionCSV

inputJsonConversionCSV

 

 

False

 

Returns:

          Type:outputString

 

JsonToXml

Summary: Data - JSON to XML

Description: Convert a JSON object to an XML string

 

Syntax:

ApptigentPowerTools.JsonToXml ([Optional]inputJsonConversionXML jsonConversionXML)

 

Parameters:

Name

Type

Summary

Required

Related Action

jsonConversionXML

inputJsonConversionXML

 

 

False

 

Returns:

          Type:outputString

 

CsvToJson

Summary: Data - CSV to JSON

Description: Convert a CSV string to a JSON array

 

Syntax:

ApptigentPowerTools.CsvToJson ([Optional]inputCsvConversionJSON csvConversionJSON)

 

Parameters:

Name

Type

Summary

Required

Related Action

csvConversionJSON

inputCsvConversionJSON

 

 

False

 

Returns:

          Type:outputString

 

XmlToJson

Summary: Data - XML to JSON

Description: Convert an XML string to a JSON object

 

Syntax:

ApptigentPowerTools.XmlToJson ([Optional]inputXmlConversionJSON xmlConversionJSON)

 

Parameters:

Name

Type

Summary

Required

Related Action

xmlConversionJSON

inputXmlConversionJSON

 

 

False

 

Returns:

          Type:outputString

 

QueryJson

Summary: Data - Query JSON

Description: Query a JSON object using a JSONPath expression

 

Syntax:

ApptigentPowerTools.QueryJson ([Optional]inputDataQuery inputDataQuery)

 

Parameters:

Name

Type

Summary

Required

Related Action

inputDataQuery

inputDataQuery

 

 

False

 

Returns:

          Type:outputString

 

QueryXml

Summary: Data - Query XML

Description: Query an XML string using an XPath expression

 

Syntax:

ApptigentPowerTools.QueryXml ([Optional]inputDataQuery inputDataQuery)

 

Parameters:

Name

Type

Summary

Required

Related Action

inputDataQuery

inputDataQuery

 

 

False

 

Returns:

          Type:outputString

 

ConvertImage

Summary: Files - Convert Image

Description: Convert an image from one format to another

 

Syntax:

ApptigentPowerTools.ConvertImage (string format, file file)

 

Parameters:

Name

Type

Summary

Required

Related Action

format

string

(Format)Values: [PNG, JPG, GIF, BMP, TIF]

Output file format

True

file

file

(File)

Source image file

True

 

Returns:

          Type:file

 

ResizeImage

Summary: Files - Resize Image

Description: Resize an image

 

Syntax:

ApptigentPowerTools.ResizeImage (string algorithm, string units, [Optional]number height, [Optional]number width, file file)

 

Parameters:

Name

Type

Summary

Required

Related Action

algorithm

string

(Resampling Algorithm)Values: [Bicubic (default), Bilinear, Cubic (Box), Cubic (Catmull-Rom), Cubic (Hermite), Cubic (Spline), Nearest Neighbor, Sinc (Lanczos2), Sinc (Lanczos3), Sinc (Lanczos5), Sinc (Lanczos8), Robidoux, Robidoux Sharp]

Optimize output quality of the target image

True

units

string

(Units)Values: [Pixels, Percent]

Image adjustment units

True

height

number

(Height)

Image height (pixels or percent)

False

width

number

(Width)

Image width (pixels or percent)

False

file

file

(File)

Source image file

True

 

Returns:

          Type:file

 

RotateImage

Summary: Files - Rotate Image

Description: Rotate an image by specified number of degrees

 

Syntax:

ApptigentPowerTools.RotateImage (string degrees, file file)

 

Parameters:

Name

Type

Summary

Required

Related Action

degrees

string

(Degrees)

Number of degrees

True

file

file

(File)

Source image file

True

 

Returns:

          Type:file

 

FlipImage

Summary: Files - Flip Image

Description: Flip an image (horizontal or vertical)

 

Syntax:

ApptigentPowerTools.FlipImage (string orientation, file file)

 

Parameters:

Name

Type

Summary

Required

Related Action

orientation

string

(Orientation)Values: [Horizontal, Vertical]

Horizontal or Vertical

True

file

file

(File)

Source image file

True

 

Returns:

          Type:file

 

WatermarkImage

Summary: Files - Watermark Image

Description: Add watermark text to an image

 

Syntax:

ApptigentPowerTools.WatermarkImage (string text, string font, number size, string color, string horizontal, string vertical, file file)

 

Parameters:

Name

Type

Summary

Required

Related Action

text

string

(Text)

Watermark text

True

font

string

(Font)Values: [Arial, Arial Black, Arial Narrow, Book Antiqua, Britannic Bold, Brush Script MT, Calisto MT, Century Gothic, Century Schoolbook, Colonna MT, Comic Sans MS, Cooper Black, Copperplate Gothic Bold, Copperplate Gothic Light, Courier New, Edwardian Script ITC, Engravers MT, Franklin Gothic Demi, Franklin Gothic Heavy, Franklin Gothic Medium, Garamond, Georgia, Gill Sans MT, Gill Sans MT Condensed, Gill Sans Ultra Bold, Gill Sans Ultra Bold Condensed, Goudy Old Style, Haettenschweiler, Holidays MT, Impact, Lucida Calligraphy, Lucida Console, Lucida Handwriting, Lucida Sans Typewriter, Lucida Sans Unicode, Marlett, Microsoft Sans Serif, MS Outlook, Palace Script MT, Palatino Linotype, Papyrus, Playbill, Rockwell, Rockwell Condensed, Rockwell Extra Bold, Script MT Bold, Stencil, Symbol, Tahoma, Times New Roman, Trebuchet MS, Verdana, Vivaldi, Webdings, Wingdings 1, Wingdings 2, Wingdings 3]

Text font

True

size

number

(Font Size)

Font size (points)

True

color

string

(Text Color)

Text color hex value

True

horizontal

string

(Horizontal)Values: [Left, Center, Right]

Horizontal alignment

True

vertical

string

(Vertical)Values: [Top, Center, Bottom]

Vertical alignment

True

file

file

(File)

Source image file

True

 

Returns:

          Type:file

 

CropImage

Summary: Files - Crop Image

Description: Crop an image

 

Syntax:

ApptigentPowerTools.CropImage (string position, number Width, number Height, file file)

 

Parameters:

Name

Type

Summary

Required

Related Action

position

string

(Position)Values: [TopLeft, TopCenter, TopRight, MiddleLeft, MiddleCenter, MiddleRight, BottomLeft, BottomCenter, BottomRight]

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

True

Width

number

(Width)

Width (X-axis right, negative to reverse)

True

Height

number

(Height)

Height (Y-axis down, negative to reverse)

True

file

file

(File)

Source image file

True

 

Returns:

          Type:file

 

GenerateQRCode

Summary: Files - Generate QR code

Description: Generate a QR code image

 

Syntax:

ApptigentPowerTools.GenerateQRCode ([Optional]inputQRCode inputQRCode)

 

Parameters:

Name

Type

Summary

Required

Related Action

inputQRCode

inputQRCode

 

 

False

 

Returns:

          Type:file

 

FileToString

Summary: Files - File to string

Description: Convert a file to a Base64 string

 

Syntax:

ApptigentPowerTools.FileToString (file file)

 

Parameters:

Name

Type

Summary

Required

Related Action

file

file

(File)

Source file (10MB limit)

True

 

Returns:

          Type:outputString

 

StringToFile

Summary: Text - String to File

Description: Convert text string to file

 

Syntax:

ApptigentPowerTools.StringToFile ([Optional]inputStringToFile inputStringToFile)

 

Parameters:

Name

Type

Summary

Required

Related Action

inputStringToFile

inputStringToFile

 

 

False

 

Returns:

          Type:file

 


 

DecodeStringParameterStringInput

Summary:

Description:

 

          Properties:

Name

Type

Summary

source

string

Source

Encoded string variable or text value


 

file

Summary: File

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

 

          Properties:

Name

Type

Summary


 

inputCalculateMinMax

Summary:

Description:

 

          Properties:

Name

Type

Summary

input

array of (number)

Values

Colllection of values to calculate

type

string

Min or Max

Minimum or Maximum  Values: [Minimum, Maximum]


 

inputCalculateNumber

Summary:

Description:

 

          Properties:

Name

Type

Summary

input

number

Value

Numeric value to calculate

decimals

number

Decimal Places

Round to number of decimal places


 

inputCalculateNumbers

Summary:

Description:

 

          Properties:

Name

Type

Summary

input

number

Primary Value

Numeric value

value

number

Secondary Value

Addend, subtrahend, factor, divisor or radicand

decimals

number

Decimal Places

Round to number of decimal places


 

inputCalculatePower

Summary:

Description:

 

          Properties:

Name

Type

Summary

input

number

Number

Number to raise

power

number

Power

Power

decimals

number

Decimal Places

Round to number of decimal places


 

inputCalculateSeries

Summary:

Description:

 

          Properties:

Name

Type

Summary

input

array of (number)

Values

Colllection of values to calculate

decimals

number

Decimal Places

Round to number of decimal places


 

inputCaseConversion

Summary:

Description:

 

          Properties:

Name

Type

Summary

input

string

Value

String containing the text to convert

alphacase

string

Case

Case of conversion result  Values: [Upper, Lower, Title]


 

inputCollectionConversion

Summary:

Description:

 

          Properties:

Name

Type

Summary

input

array of (string)

Values

Collection containing strings to convert

name

string

Name

Collection name


 

inputCollectionConversionXML

Summary:

Description:

 

          Properties:

Name

Type

Summary

input

array of (string)

Values

Collection containing strings to convert

root

string

Root Node Name

Name of root XML node

child

string

Child Node Name

Name of child XML node(s)


 

inputCollectionCount

Summary:

Description:

 

          Properties:

Name

Type

Summary

input

array of (string)

Collection

Collection of items to count


 

inputCollectionFilter

Summary:

Description:

 

          Properties:

Name

Type

Summary

input

array of (string)

Collection

Collection of strings to filter

match

string

Match

Match type  Values: [Any, All, None]

keywords

string

Keywords

Keywords (separate multiple values with commas)


 

inputCollectionModify

Summary:

Description:

 

          Properties:

Name

Type

Summary

input

array of (string)

Collection

Collection of values or objects to modify

item

string

Item

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

items

array of (string)

Items

Items (Collection, for a single item leave blank and use Item)

index

string

Index

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


 

inputCollectionReplace

Summary:

Description:

 

          Properties:

Name

Type

Summary

input

array of (string)

Collection

Collection of strings

match

string

Match value

Match value

replacement

string

Replacement value

Replacement value

ignoreCase

string

Ignore case

Ignore case  Values: [True, False]


 

inputCollectionSearch

Summary:

Description:

 

          Properties:

Name

Type

Summary

input

array of (string)

Values

Collection of strings to search

match

string

Text

Text to match

trim

string

Trim

Trim white space from comparison string  Values: [True, False]

ignorecase

string

Ignore Case

Ignore case when performing comparison  Values: [True, False]


 

inputCollectionSearchNumeric

Summary:

Description:

 

          Properties:

Name

Type

Summary

input

array of (number)

Values

Collection of strings to search

match

number

Number

Number to match

type

string

Number Type

Type of number - integer or decimal  Values: [Integer, Decimal]


 

inputCollectionSort

Summary:

Description:

 

          Properties:

Name

Type

Summary

input

array of (string)

Collection

Collection of strings to sort

order

string

Order

Sort order  Values: [Ascending, Descending]


 

inputCollectionSplit

Summary:

Description:

 

          Properties:

Name

Type

Summary

input

array of (string)

Collection

Collection of items to split

match

string

Match Value

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

index

string

Index

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


 

inputConvertAngle

Summary:

Description:

 

          Properties:

Name

Type

Summary

input

number

Measurement value

 

source

string

Source measurement

Values: [Arcminute, Arcsecond, Centiradian, Deciradian, Degree, Gradian, Microdegree, Microradian, Millidegree, Milliradian, Nanodegree, Nanoradian, Radian, Revolution]

target

string

Target measurement

Values: [Arcminute, Arcsecond, Centiradian, Deciradian, Degree, Gradian, Microdegree, Microradian, Millidegree, Milliradian, Nanodegree, Nanoradian, Radian, Revolution]


 

inputConvertArea

Summary:

Description:

 

          Properties:

Name

Type

Summary

input

number

Measurement value

 

source

string

Source measurement

Values: [Acre, Hectare, SquareCentimeter, SquareDecimeter, SquareFoot, SquareInch, SquareKilometer, SquareMeter, SquareMicrometer, SquareMile, SquareMillimeter, SquareYard]

target

string

Target measurement

Values: [Acre, Hectare, SquareCentimeter, SquareDecimeter, SquareFoot, SquareInch, SquareKilometer, SquareMeter, SquareMicrometer, SquareMile, SquareMillimeter, SquareYard]


 

inputConvertDistance

Summary:

Description:

 

          Properties:

Name

Type

Summary

input

number

Measurement value

 

source

string

Source measurement

Values: [Centimeter, Decimeter, Fathom, Foot, Hectometer, Inch, Kilometer, LightYear, Meter, Micrometer, Mile, Millimeter, Nanometer, NauticalMile, Yard]

target

string

Target measurement

Values: [Centimeter, Decimeter, Fathom, Foot, Hectometer, Inch, Kilometer, LightYear, Meter, Micrometer, Mile, Millimeter, Nanometer, NauticalMile, Yard]


 

inputConvertDuration

Summary:

Description:

 

          Properties:

Name

Type

Summary

input

number

Measurement value

 

source

string

Source measurement

Values: [Day, Hour, Microsecond, Millisecond, Minute, Month, Nanosecond, Second, Week, Year]

target

string

Target measurement

Values: [Day, Hour, Microsecond, Millisecond, Minute, Month, Nanosecond, Second, Week, Year]


 

inputConvertEnergy

Summary:

Description:

 

          Properties:

Name

Type

Summary

input

number

Measurement value

 

source

string

Source measurement

Values: [BritishThermalUnit, Calorie, ElectronVolt, FootPound, GigawattHour, Joule, Kilocalorie, Kilojoule, KilowattHour, Megajoule, MegawattHour, TerawattHour, Therm (EU), Therm (UK), Therm (US), WattHour]

target

string

Target measurement

Values: [BritishThermalUnit, Calorie, ElectronVolt, FootPound, GigawattHour, Joule, Kilocalorie, Kilojoule, KilowattHour, Megajoule, MegawattHour, TerawattHour, Therm (EU), Therm (UK), Therm (US), WattHour]


 

inputConvertPower

Summary:

Description:

 

          Properties:

Name

Type

Summary

input

number

Measurement value

 

source

string

Source measurement

Values: [BritishThermalUnitPerHour, Decawatt, Deciwatt, ElectricalHorsepower, Femtowatt, Gigawatt, HydraulicHorsepower, Kilowatt, MechanicalHorsepower, Megawatt, Microwatt, Milliwatt, Nanowatt, Petawatt, Picowatt, Terawatt, Watt]

target

string

Target measurement

Values: [BritishThermalUnitPerHour, Decawatt, Deciwatt, ElectricalHorsepower, Femtowatt, Gigawatt, HydraulicHorsepower, Kilowatt, MechanicalHorsepower, Megawatt, Microwatt, Milliwatt, Nanowatt, Petawatt, Picowatt, Terawatt, Watt]


 

inputConvertSpeed

Summary:

Description:

 

          Properties:

Name

Type

Summary

input

number

Measurement value

 

source

string

Source measurement

Values: [CentimeterPerHour, CentimeterPerMinute, CentimeterPerSecond, DecimeterPerMinute, DecimeterPerSecond, FootPerHour, FootPerMinute, FootPerSecond, InchPerHour, InchPerMinute, InchPerSecond, KilometerPerHour, KilometerPerMinute, KilometerPerSecond, Knot, MeterPerHour, MeterPerMinute, MeterPerSecond, MicrometerPerMinute, MicrometerPerSecond, MilePerHour, MillimeterPerHour, MillimeterPerMinute, MillimeterPerSecond, NanometerPerMinute, NanometerPerSecond, YardPerHour, YardPerMinute, YardPerSecond]

target

string

Target measurement

Values: [CentimeterPerHour, CentimeterPerMinute, CentimeterPerSecond, DecimeterPerMinute, DecimeterPerSecond, FootPerHour, FootPerMinute, FootPerSecond, InchPerHour, InchPerMinute, InchPerSecond, KilometerPerHour, KilometerPerMinute, KilometerPerSecond, Knot, MeterPerHour, MeterPerMinute, MeterPerSecond, MicrometerPerMinute, MicrometerPerSecond, MilePerHour, MillimeterPerHour, MillimeterPerMinute, MillimeterPerSecond, NanometerPerMinute, NanometerPerSecond, YardPerHour, YardPerMinute, YardPerSecond]


 

inputConvertTemperature

Summary:

Description:

 

          Properties:

Name

Type

Summary

input

number

Measurement value

 

source

string

Source measurement

Values: [Celsius, Fahrenheit, Newton, Kelvin]

target

string

Target measurement

Values: [Celsius, Fahrenheit, Newton, Kelvin]


 

inputConvertVolume

Summary:

Description:

 

          Properties:

Name

Type

Summary

input

number

Measurement value

 

source

string

Source measurement

Values: [Centiliter, CubicCentimeter, CubicDecimeter, CubicFoot, CubicHectometer, CubicInch, CubicKilometer, CubicMeter, CubicMillimeter, CubicYard, Deciliter, ImperialBeerBarrel, ImperialGallon, ImperialOunce, ImperialPint, Kiloliter, Liter, Microliter, Milliliter, Gallon, Cup, Ounce, Pint, Quart, Tablespoon, Teaspoon]

target

string

Target measurement

Values: [Centiliter, CubicCentimeter, CubicDecimeter, CubicFoot, CubicHectometer, CubicInch, CubicKilometer, CubicMeter, CubicMillimeter, CubicYard, Deciliter, ImperialBeerBarrel, ImperialGallon, ImperialOunce, ImperialPint, Kiloliter, Liter, Microliter, Milliliter, Gallon, Cup, Ounce, Pint, Quart, Tablespoon, Teaspoon]


 

inputConvertWeight

Summary:

Description:

 

          Properties:

Name

Type

Summary

input

number

Measurement value

 

source

string

Source measurement

Values: [Centigram, Decagram, Decigram, Grain, Gram, Hectogram, Kilogram, Microgram, Milligram, Nanogram, Ounce, Pound, Stone, Solar Mass, Earth Mass, Slug, Short Ton, Long Ton, Ton, Megaton, Short Hundredweight, Long Hundredweight]

target

string

Target measurement

Values: [Centigram, Decagram, Decigram, Grain, Gram, Hectogram, Kilogram, Microgram, Milligram, Nanogram, Ounce, Pound, Stone, Ton]


 

inputCsvConversionJSON

Summary:

Description:

 

          Properties:

Name

Type

Summary

input

string

Value

CSV string

header

boolean

Header

Include header row


 

inputCurrencyConversion

Summary:

Description:

 

          Properties:

Name

Type

Summary

input

number

Value

Amount to convert

source

string

Source currency

Values: [USD, AUD, BGN, BRL, CAD, CHF, CNY, CZK, DKK, EUR, GBP, HKD, HRK, HUF, IDR, ILS, INR, ISK, JPY, KRW, MXN, MYR, NOK, NZD, PHP, PLN, RON, RUB, SGD, SEK, THB, TRY, ZAR]

target

string

Target currency

Values: [USD, AUD, BGN, BRL, CAD, CHF, CNY, CZK, DKK, EUR, GBP, HKD, HRK, HUF, IDR, ILS, INR, ISK, JPY, KRW, MXN, MYR, NOK, NZD, PHP, PLN, RON, RUB, SGD, SEK, THB, TRY, ZAR]


 

inputCurrencyFormat

Summary:

Description:

 

          Properties:

Name

Type

Summary

input

number

Value

Amount to format

target

string

Target currency

Values: [USD, AUD, BGN, BRL, CAD, CHF, CNY, CZK, DKK, EUR, GBP, HKD, HRK, HUF, IDR, ILS, INR, ISK, JPY, KRW, MXN, MYR, NOK, NZD, PHP, PLN, RON, RUB, SGD, SEK, THB, TRY, ZAR]


 

inputDataQuery

Summary:

Description:

 

          Properties:

Name

Type

Summary

input

string

Value

XML or JSON string

query

string

Query

XPath or JSONPath query


 

inputDateTimeConversion

Summary:

Description:

 

          Properties:

Name

Type

Summary

input

string

Value

Source date and time

source

string

Source Time Zone

Values: [GMT Standard Time - (GMT) Greenwich Mean Time : Dublin, Edinburgh, Lisbon, London, Greenwich Standard Time - (GMT) Monrovia, Reykjavik, W. Europe Standard Time - (GMT+01:00) Amsterdam, Berlin, Bern, Rome, Stockholm, Vienna, Central Europe Standard Time - (GMT+01:00) Belgrade, Bratislava, Budapest, Ljubljana, Prague, Central European Standard Time - (GMT+01:00) Sarajevo, Skopje, Warsaw, Zagreb, W. Central Africa Standard Time - (GMT+01:00) West Central Africa, GTB Standard Time - (GMT+02:00) Athens, Bucharest, Istanbul, Middle East Standard Time - (GMT+02:00) Beirut, Egypt Standard Time - (GMT+02:00) Cairo, South Africa Standard Time - (GMT+02:00) Harare, Pretoria, FLE Standard Time - (GMT+02:00) Helsinki, Kyiv, Riga, Sofia, Tallinn, Vilnius, Israel Standard Time - (GMT+02:00) Jerusalem, E. Europe Standard Time - (GMT+02:00) Minsk, Namibia Standard Time - (GMT+02:00) Windhoek, Arabic Standard Time - (GMT+03:00) Baghdad, Arab Standard Time - (GMT+03:00) Kuwait, Riyadh, Russian Standard Time - (GMT+03:00) Moscow, St. Petersburg, Volgograd, E. Africa Standard Time - (GMT+03:00) Nairobi, Georgian Standard Time - (GMT+03:00) Tbilisi, Iran Standard Time - (GMT+03:30) Tehran, Arabian Standard Time - (GMT+04:00) Abu Dhabi, Muscat, Azerbaijan Standard Time - (GMT+04:00) Baku, Mauritius Standard Time - (GMT+04:00) Port Louis, Caucasus Standard Time - (GMT+04:00) Yerevan, Afghanistan Standard Time - (GMT+04:30) Kabul, Ekaterinburg Standard Time - (GMT+05:00) Ekaterinburg, Pakistan Standard Time - (GMT+05:00) Islamabad, Karachi, West Asia Standard Time - (GMT+05:00) Tashkent, India Standard Time - (GMT+05:30) Chennai, Kolkata, Mumbai, New Delhi, Sri Lanka Standard Time - (GMT+05:30) Sri Jayawardenepura, Nepal Standard Time - (GMT+05:45) Kathmandu, N. Central Asia Standard Time - (GMT+06:00) Almaty, Novosibirsk, Central Asia Standard Time - (GMT+06:00) Astana, Dhaka, Myanmar Standard Time - (GMT+06:30) Yangon (Rangoon), SE Asia Standard Time - (GMT+07:00) Bangkok, Hanoi, Jakarta, North Asia Standard Time - (GMT+07:00) Krasnoyarsk, China Standard Time - (GMT+08:00) Beijing, Chongqing, Hong Kong, Urumqi, North Asia East Standard Time - (GMT+08:00) Irkutsk, Ulaan Bataar, Singapore Standard Time - (GMT+08:00) Kuala Lumpur, Singapore, W. Australia Standard Time - (GMT+08:00) Perth, Taipei Standard Time - (GMT+08:00) Taipei, Tokyo Standard Time - (GMT+09:00) Osaka, Sapporo, Tokyo, Korea Standard Time - (GMT+09:00) Seoul, Yakutsk Standard Time - (GMT+09:00) Yakutsk, Cen. Australia Standard Time - (GMT+09:30) Adelaide, AUS Central Standard Time - (GMT+09:30) Darwin, E. Australia Standard Time - (GMT+10:00) Brisbane, AUS Eastern Standard Time - (GMT+10:00) Canberra, Melbourne, Sydney, West Pacific Standard Time - (GMT+10:00) Guam, Port Moresby, Tasmania Standard Time - (GMT+10:00) Hobart, Vladivostok Standard Time - (GMT+10:00) Vladivostok, Central Pacific Standard Time - (GMT+11:00) Magadan, Solomon Is., New Caledonia, New Zealand Standard Time - (GMT+12:00) Auckland, Wellington, Fiji Standard Time - (GMT+12:00) Fiji, Kamchatka, Marshall Is., Tonga Standard Time - (GMT+13:00) Nuku'alofa, Azores Standard Time - (GMT-01:00) Azores, Cape Verde Standard Time - (GMT-01:00) Cape Verde Is., Mid-Atlantic Standard Time - (GMT-02:00) Mid-Atlantic, E. South America Standard Time - (GMT-03:00) Brasilia, Argentina Standard Time - (GMT-03:00) Buenos Aires, SA Eastern Standard Time - (GMT-03:00) Georgetown, Greenland Standard Time - (GMT-03:00) Greenland, Montevideo Standard Time - (GMT-03:00) Montevideo, Newfoundland Standard Time - (GMT-03:30) Newfoundland, Atlantic Standard Time - (GMT-04:00) Atlantic Time (Canada), SA Western Standard Time - (GMT-04:00) La Paz, Central Brazilian Standard Time - (GMT-04:00) Manaus, Pacific SA Standard Time - (GMT-04:00) Santiago, Venezuela Standard Time - (GMT-04:30) Caracas, SA Pacific Standard Time - (GMT-05:00) Bogota, Lima, Quito, Rio Branco, Eastern Standard Time - (GMT-05:00) Eastern Time (US & Canada), US Eastern Standard Time - (GMT-05:00) Indiana (East), Central America Standard Time - (GMT-06:00) Central America, Central Standard Time - (GMT-06:00) Central Time (US & Canada), Central Standard Time (Mexico) - (GMT-06:00) Guadalajara, Mexico City, Monterrey, Canada Central Standard Time - (GMT-06:00) Saskatchewan, US Mountain Standard Time - (GMT-07:00) Arizona, Mountain Standard Time (Mexico) - (GMT-07:00) Chihuahua, La Paz, Mazatlan, Mountain Standard Time - (GMT-07:00) Mountain Time (US & Canada), Pacific Standard Time - (GMT-08:00) Pacific Time (US & Canada), Pacific Standard Time (Mexico) - (GMT-08:00) Tijuana, Baja California, Alaskan Standard Time - (GMT-09:00) Alaska, Hawaiian Standard Time - (GMT-10:00) Hawaii, Samoa Standard Time - (GMT-11:00) Midway Island, Samoa, Dateline Standard Time - (GMT-12:00) International Date Line West]

target

string

Target Time Zone

Values: [GMT Standard Time - (GMT) Greenwich Mean Time : Dublin, Edinburgh, Lisbon, London, Greenwich Standard Time - (GMT) Monrovia, Reykjavik, W. Europe Standard Time - (GMT+01:00) Amsterdam, Berlin, Bern, Rome, Stockholm, Vienna, Central Europe Standard Time - (GMT+01:00) Belgrade, Bratislava, Budapest, Ljubljana, Prague, Central European Standard Time - (GMT+01:00) Sarajevo, Skopje, Warsaw, Zagreb, W. Central Africa Standard Time - (GMT+01:00) West Central Africa, GTB Standard Time - (GMT+02:00) Athens, Bucharest, Istanbul, Middle East Standard Time - (GMT+02:00) Beirut, Egypt Standard Time - (GMT+02:00) Cairo, South Africa Standard Time - (GMT+02:00) Harare, Pretoria, FLE Standard Time - (GMT+02:00) Helsinki, Kyiv, Riga, Sofia, Tallinn, Vilnius, Israel Standard Time - (GMT+02:00) Jerusalem, E. Europe Standard Time - (GMT+02:00) Minsk, Namibia Standard Time - (GMT+02:00) Windhoek, Arabic Standard Time - (GMT+03:00) Baghdad, Arab Standard Time - (GMT+03:00) Kuwait, Riyadh, Russian Standard Time - (GMT+03:00) Moscow, St. Petersburg, Volgograd, E. Africa Standard Time - (GMT+03:00) Nairobi, Georgian Standard Time - (GMT+03:00) Tbilisi, Iran Standard Time - (GMT+03:30) Tehran, Arabian Standard Time - (GMT+04:00) Abu Dhabi, Muscat, Azerbaijan Standard Time - (GMT+04:00) Baku, Mauritius Standard Time - (GMT+04:00) Port Louis, Caucasus Standard Time - (GMT+04:00) Yerevan, Afghanistan Standard Time - (GMT+04:30) Kabul, Ekaterinburg Standard Time - (GMT+05:00) Ekaterinburg, Pakistan Standard Time - (GMT+05:00) Islamabad, Karachi, West Asia Standard Time - (GMT+05:00) Tashkent, India Standard Time - (GMT+05:30) Chennai, Kolkata, Mumbai, New Delhi, Sri Lanka Standard Time - (GMT+05:30) Sri Jayawardenepura, Nepal Standard Time - (GMT+05:45) Kathmandu, N. Central Asia Standard Time - (GMT+06:00) Almaty, Novosibirsk, Central Asia Standard Time - (GMT+06:00) Astana, Dhaka, Myanmar Standard Time - (GMT+06:30) Yangon (Rangoon), SE Asia Standard Time - (GMT+07:00) Bangkok, Hanoi, Jakarta, North Asia Standard Time - (GMT+07:00) Krasnoyarsk, China Standard Time - (GMT+08:00) Beijing, Chongqing, Hong Kong, Urumqi, North Asia East Standard Time - (GMT+08:00) Irkutsk, Ulaan Bataar, Singapore Standard Time - (GMT+08:00) Kuala Lumpur, Singapore, W. Australia Standard Time - (GMT+08:00) Perth, Taipei Standard Time - (GMT+08:00) Taipei, Tokyo Standard Time - (GMT+09:00) Osaka, Sapporo, Tokyo, Korea Standard Time - (GMT+09:00) Seoul, Yakutsk Standard Time - (GMT+09:00) Yakutsk, Cen. Australia Standard Time - (GMT+09:30) Adelaide, AUS Central Standard Time - (GMT+09:30) Darwin, E. Australia Standard Time - (GMT+10:00) Brisbane, AUS Eastern Standard Time - (GMT+10:00) Canberra, Melbourne, Sydney, West Pacific Standard Time - (GMT+10:00) Guam, Port Moresby, Tasmania Standard Time - (GMT+10:00) Hobart, Vladivostok Standard Time - (GMT+10:00) Vladivostok, Central Pacific Standard Time - (GMT+11:00) Magadan, Solomon Is., New Caledonia, New Zealand Standard Time - (GMT+12:00) Auckland, Wellington, Fiji Standard Time - (GMT+12:00) Fiji, Kamchatka, Marshall Is., Tonga Standard Time - (GMT+13:00) Nuku'alofa, Azores Standard Time - (GMT-01:00) Azores, Cape Verde Standard Time - (GMT-01:00) Cape Verde Is., Mid-Atlantic Standard Time - (GMT-02:00) Mid-Atlantic, E. South America Standard Time - (GMT-03:00) Brasilia, Argentina Standard Time - (GMT-03:00) Buenos Aires, SA Eastern Standard Time - (GMT-03:00) Georgetown, Greenland Standard Time - (GMT-03:00) Greenland, Montevideo Standard Time - (GMT-03:00) Montevideo, Newfoundland Standard Time - (GMT-03:30) Newfoundland, Atlantic Standard Time - (GMT-04:00) Atlantic Time (Canada), SA Western Standard Time - (GMT-04:00) La Paz, Central Brazilian Standard Time - (GMT-04:00) Manaus, Pacific SA Standard Time - (GMT-04:00) Santiago, Venezuela Standard Time - (GMT-04:30) Caracas, SA Pacific Standard Time - (GMT-05:00) Bogota, Lima, Quito, Rio Branco, Eastern Standard Time - (GMT-05:00) Eastern Time (US & Canada), US Eastern Standard Time - (GMT-05:00) Indiana (East), Central America Standard Time - (GMT-06:00) Central America, Central Standard Time - (GMT-06:00) Central Time (US & Canada), Central Standard Time (Mexico) - (GMT-06:00) Guadalajara, Mexico City, Monterrey, Canada Central Standard Time - (GMT-06:00) Saskatchewan, US Mountain Standard Time - (GMT-07:00) Arizona, Mountain Standard Time (Mexico) - (GMT-07:00) Chihuahua, La Paz, Mazatlan, Mountain Standard Time - (GMT-07:00) Mountain Time (US & Canada), Pacific Standard Time - (GMT-08:00) Pacific Time (US & Canada), Pacific Standard Time (Mexico) - (GMT-08:00) Tijuana, Baja California, Alaskan Standard Time - (GMT-09:00) Alaska, Hawaiian Standard Time - (GMT-10:00) Hawaii, Samoa Standard Time - (GMT-11:00) Midway Island, Samoa, Dateline Standard Time - (GMT-12:00) International Date Line West]

format

string

Format

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


 

inputDateTimeDifference

Summary:

Description:

 

          Properties:

Name

Type

Summary

dateTime1

string

First date/time value

First date/time value

dateTime2

string

Second date/time value

Second date/time value


 

inputDateTimeFormat

Summary:

Description:

 

          Properties:

Name

Type

Summary

input

string

Value

Source date and time

culture

string

Culture

Language culture  Values: [en-US, af-ZA, ar-AE, ar-BH, ar-DZ, ar-EG, ar-IQ, ar-JO, ar-KW, ar-LB, ar-LY, ar-MA, ar-OM, ar-QA, ar-SA, ar-SY, ar-TN, ar-YE, az-AZ, be-BY, bg-BG, bs-BA, ca-ES, cs-CZ, cy-GB, da-DK, de-AT, de-CH, de-DE, de-LI, de-LU, el-GR, en-AU, en-BZ, en-CA, en-CB, en-GB, en-IE, en-JM, en-NZ, en-PH, en-TT, en-ZA, en-ZW, es-AR, es-BO, es-CL, es-CO, es-CR, es-DO, es-EC, es-ES, es-GT, es-HN, es-MX, es-NI, es-PA, es-PE, es-PR, es-PY, es-SV, es-UY, es-VE, et-EE, eu-ES, fa-IR, fi-FI, fo-FO, fr-BE, fr-CA, fr-CH, fr-FR, fr-LU, fr-MC, gl-ES, gu-IN, he-IL, hi-IN, hr-BA, hr-HR, hu-HU, hy-AM, id-ID, is-IS, it-CH, it-IT, ja-JP, ka-GE, kk-KZ, kn-IN, ko-KR, ky-KG, lt-LT, lv-LV, mi-NZ, mn-MN, mr-IN, ms-BN, ms-MY, mt-MT, nl-BE, nl-NL, nn-NO, ns-ZA, pa-IN, pl-PL, ps-AR, pt-BR, pt-PT, ro-RO, ru-RU, sa-IN, sk-SK, sl-SI, sq-AL, sr-BA, sr-SP, sv-FI, sv-SE, sw-KE, ta-IN, te-IN, th-TH, tl-PH, tn-ZA, tr-TR, uk-UA, ur-PK, uz-UZ, vi-VN, zh-CN, zh-HK, zh-MO, zh-SG, zh-TW, zu-ZA]

format

string

Format

Output format


 

inputDateTimeInfo

Summary:

Description:

 

          Properties:

Name

Type

Summary

input

string

Value

Source date and time

culture

string

Culture

Language culture  Values: [en-US, af-ZA, ar-AE, ar-BH, ar-DZ, ar-EG, ar-IQ, ar-JO, ar-KW, ar-LB, ar-LY, ar-MA, ar-OM, ar-QA, ar-SA, ar-SY, ar-TN, ar-YE, az-AZ, be-BY, bg-BG, bs-BA, ca-ES, cs-CZ, cy-GB, da-DK, de-AT, de-CH, de-DE, de-LI, de-LU, el-GR, en-AU, en-BZ, en-CA, en-CB, en-GB, en-IE, en-JM, en-NZ, en-PH, en-TT, en-ZA, en-ZW, es-AR, es-BO, es-CL, es-CO, es-CR, es-DO, es-EC, es-ES, es-GT, es-HN, es-MX, es-NI, es-PA, es-PE, es-PR, es-PY, es-SV, es-UY, es-VE, et-EE, eu-ES, fa-IR, fi-FI, fo-FO, fr-BE, fr-CA, fr-CH, fr-FR, fr-LU, fr-MC, gl-ES, gu-IN, he-IL, hi-IN, hr-BA, hr-HR, hu-HU, hy-AM, id-ID, is-IS, it-CH, it-IT, ja-JP, ka-GE, kk-KZ, kn-IN, ko-KR, ky-KG, lt-LT, lv-LV, mi-NZ, mn-MN, mr-IN, ms-BN, ms-MY, mt-MT, nl-BE, nl-NL, nn-NO, ns-ZA, pa-IN, pl-PL, ps-AR, pt-BR, pt-PT, ro-RO, ru-RU, sa-IN, sk-SK, sl-SI, sq-AL, sr-BA, sr-SP, sv-FI, sv-SE, sw-KE, ta-IN, te-IN, th-TH, tl-PH, tn-ZA, tr-TR, uk-UA, ur-PK, uz-UZ, vi-VN, zh-CN, zh-HK, zh-MO, zh-SG, zh-TW, zu-ZA]


 

inputGenerateHash

Summary:

Description:

 

          Properties:

Name

Type

Summary

input

string

Input

Hash source string

algorithm

string

Algorithm

Hash algorithm  Values: [MD5, SHA1, SHA256, SHA384, SHA512]


 

inputGenerateUniqueID

Summary:

Description:

 

          Properties:

Name

Type

Summary

uppercase

string

Uppercase

All uppercase alpha characters  Values: [True, False]


 

inputJoinStrings

Summary:

Description:

 

          Properties:

Name

Type

Summary

input

array of (string)

Values

Collection of strings to be joined

separator

string

Separator

Separator character

lower

string

Lowercase

Convert strings in collection to lowercase  Values: [True, False]

trim

string

Trim

Trim strings in collection  Values: [True, False]


 

inputJsonConversionCSV

Summary:

Description:

 

          Properties:

Name

Type

Summary

input

string

Value

JSON array object

header

boolean

Header

Include header row

omit

string

Omit Columns

Columns to omit (comma separated)

order

string

Order

Column order (comma separated)


 

inputJsonConversionHTML

Summary:

Description:

 

          Properties:

Name

Type

Summary

input

string

Value

JSON array object

header

boolean

Header

Include header row

alternate

string

Alternate Header

Alternate header row markup

attributes

string

Table Attributes

Optional table attributes (single quoted values)

omit

string

Omit Columns

Columns to omit (comma separated)

order

string

Order

Column order (comma separated)


 

inputJsonConversionXML

Summary:

Description:

 

          Properties:

Name

Type

Summary

input

string

Value

JSON array object

root

string

Root Name

Name of root node


 

inputMarketIndex

Summary:

Description:

 

          Properties:

Name

Type

Summary

symbol

string

Index

Market index  Values: [DJA.INDX (Dow Jones Composite Average), DJI.INDX (Dow Jones Industrial Average), DJT.INDX (Dow Jones Transportation), DJUS.INDX (Dow Jones US), DXY.INDX (US Dollar Index), GDOW.INDX (Global Dow USD), NY.INDX (NYSE US 100 Index), NYA.INDX (NYSE Composite), IXIC.INDX (NASDAQ Composite), NDX.INDX (NASDAQ 100), GSPC.INDX (S&P 500), ES.INDX (S&P 500 Futures), MID.INDX (S&P Midcap 400), GPTSE.INDX (S&P TSX Composite Index [Canada]), FTSE.INDX (FTSE 100 Index [UK]), CDAXX.INDX (DAX Composite Index [Germany]), GDAXI.INDX (DAX Index [Germany]), HSCE.INDX (Hang Seng China Enterprise (CEI)), HSI.INDX (Hang Seng Index [Hong Kong]), N100.INDX (EuroNext 100), N225.INDX (Nikkei 225 Index), RTSI.INDX (RTSI Index [Russia]), SSEC.INDX (Shanghai Composite), SSMI.INDX (Swiss Market Index)]

date

string

Date

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


 

inputNumberRange

Summary:

Description:

 

          Properties:

Name

Type

Summary

start

number

Start

Start of range

end

number

End

End of range


 

inputQRCode

Summary:

Description:

 

          Properties:

Name

Type

Summary

input

string

Value

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

payload

string

Type

Payload type  Values: [Plain Text (string), Bitcoin Payment (address|amount|label|message), Bookmark (url|title), Calendar Event (subject|description|location|start|end|allDayEvent['true' or 'false']|format ['universal' or 'iCal']), Geolocation (latitude|longitude), Mail (recipient|subject|message), Phone Number (string), SMS (number|message), URL (string), WiFi (ssid|password|authenticationMode ['WEP', 'WPA' or 'WPA2'])]


 

inputRedactString

Summary:

Description:

 

          Properties:

Name

Type

Summary

source

string

Source String

String containing the complete text

value

string

Value

Individual string to redact

values

array of (string)

-OR- Values Collection

Collection of strings to redact

regex

string

-OR- Regular Expression

Regular expression pattern for matching strings


 

inputReplaceString

Summary:

Description:

 

          Properties:

Name

Type

Summary

source

string

Source

String containing the text to be replaced

value

string

Value

Text to replace

replacement

string

Replacement

Replacement text


 

inputSplitString

Summary:

Description:

 

          Properties:

Name

Type

Summary

input

string

Value

Text to split

characters

string

Character(s)

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


 

inputStockPrices

Summary:

Description:

 

          Properties:

Name

Type

Summary

symbols

string

Symbols

Stock ticker symbols (comma-separated, max 20)

date

string

Date

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

exchange

string

Exchange

Stock exchange  Values: [XNYS (New York Stock Exchange), XNAS (NASDAQ Stock Exchange), XBRU (Euronext Brussels), XTSE (Toronto Stock Exchange), XCNQ (Candadian Securities Exchange), XSHG (Shanghai Stock Exchange), XCSE (Copenhagen Stock Exchange), XPAR (Euronext Paris), XFRA (Deutsche Borse), XHKG (Hong Kong Stock Exchange), XNSE (National Stock Exchange India), XTAE (Tel Aviv Stock Exchange), XNGO (Nagoya Stock Exchange), XFKA (Fukuoka Stock Exchange), XSAP (Sapporo Stock Exchange), XMEX (Mexican Stock Exchange), XNZE (New Zealand Stock Exchange), XLIS (Euronext Lisbon), MISX (Moscow Stock Exchange), XSES (Singapore Stock Exchange), XLON (London Stock Exchange), XASE (American Stock Exchange), XASX (Australia Stock Exchange), XDFM (Dubai Financial Market), XBKK (Stock Exchange of Thailand), XSWX (SIX Swiss Exchange), XSTO (Stockholm Stock Exchange), BMEX (Bolsas y Mercados Españoles), XJSE (Johannesburg Stock Exchange)]


 

inputString

Summary:

Description:

 

          Properties:

Name

Type

Summary

source

string

Source

String variable or text value


 

inputStringComparison

Summary:

Description:

 

          Properties:

Name

Type

Summary

input

string

Source

Original string

compare

string

Target

Comparison string

lower

string

Lowercase

Convert strings to lowercase before comparison  Values: [True, False]

trim

string

Trim

Trim strings before comparison  Values: [True, False]


 

inputStringContains

Summary:

Description:

 

          Properties:

Name

Type

Summary

find

string

Value

Text to match

input

string

Target

Text to search

lower

string

Lowercase

Convert strings to lowercase  Values: [True, False]


 

inputStringToFile

Summary:

Description:

 

          Properties:

Name

Type

Summary

input

string

Value

Text string (body of file)

extension

string

Extension

File extension  Values: [TXT, CSV, HTML, XML, CSS, JSON, JS]

filename

string

Filename

Name of file (without extension)


 

inputTextToSpeech

Summary:

Description:

 

          Properties:

Name

Type

Summary

text

string

Text

Text to convert (10,000 characters max)

type

string

Text or file type

Text or file type  Values: [PlainText, SSML]

voice

string

Voice

Voice locale (must match language of input text)  Values: [ar-EG, Hoda (Female), ar-SA, Naayf (Male), bg-BG, Ivan (Male), ca-ES, Herena (Female), cs-CZ, Jakub (Male), da-DK, Helle (Female), de-AT, Michael (Male), de-CH, Karsten (Male), de-DE, Hedda (Female), de-DE, Stefan (Male), el-GR, Stefanos (Male), en-AU, Catherine (Female), en-AU, Hayley (Female), en-CA, Heather (Female), en-CA, Linda (Female), en-GB, George (Male), en-GB, Hazel (Female), en-GB, Susan (Female), en-IE, Sean (Male), en-IN, Heera (Female), en-IN, Priya (Female), en-IN, Ravi (Male), en-US, Aria (Female), en-US, Benjamin (Male), en-US, Guy (Male), en-US, Zira (Female), es-ES, Helena (Female), es-ES, Laura (Female), es-ES, Pablo (Male), es-MX, Hilda (Female), es-MX, Raul (Male), fi-FI, Heidi (Female), fr-CA, Caroline (Female), fr-CA, Harmonie (Female), fr-CH, Guillaume (Male), fr-FR, Hortense (Female), fr-FR, Julie (Female), fr-FR, Paul (Male), he-IL, Asaf (Male), hi-IN, Hemant (Male), hi-IN, Kalpana (Female), hr-HR, Matej (Male), hu-HU, Szabolcs (Male), id-ID, Andika (Male), it-IT, Cosimo (Male), it-IT, Lucia (Female), ja-JP, Ayumi (Female), ja-JP, Haruka (Female), ja-JP, Ichiro (Male), ko-KR, Heami (Female), ms-MY, Rizwan (Male), nb-NO, Hulda (Female), nl-NL, Hanna (Female), pl-PL, Paulina (Female), pt-BR, Daniel (Male), pt-BR, Heloisa (Female), pt-PT, Helia (Female), ro-RO, Andrei (Male), ru-RU, Ekaterina (Female), ru-RU, Irina (Female), ru-RU, Pavel (Male), sk-SK, Filip (Male), sl-SI, Lado (Male), sv-SE, Hedvig (Female), ta-IN, Valluvar (Male), te-IN, Chitra (Female), th-TH, Pattara (Male), tr-TR, Seda (Female), vi-VN, An (Male), zh-CN, Huihui (Female), zh-CN, Kangkang (Male), zh-CN, Yaoyao (Female), zh-HK, Danny (Male), zh-HK, Tracy (Female), zh-TW, HanHan (Female), zh-TW, Yating (Female), zh-TW, Zhiwei (Male)]


 

inputTranslateString

Summary:

Description:

 

          Properties:

Name

Type

Summary

input

string

Value

String containing the text to be translated

language

string

Language

Translation language  Values: [Arabic, Chinese (Simplified), Czech, Danish, Dutch, English, Finnish, French, German, Greek, Hindi, Hungarian, Italian, Japanese, Klingon, Korean, Norweigan, Polish, Portuguese, Russian, Spanish, Swedish, Turkish, Vietnamese, Welsh]


 

inputTrimString

Summary:

Description:

 

          Properties:

Name

Type

Summary

source

string

Source

String containing the text to be trimmed

type

string

Type

Type of white space to remove  Values: [Start, End, Both]


 

inputVerifyHash

Summary:

Description:

 

          Properties:

Name

Type

Summary

input

string

Input

Original source string

algorithm

string

Algorithm

Hash algorithm  Values: [MD5, SHA1, SHA256, SHA384, SHA512]

hash

string

Hash

Hashed result


 

inputXmlConversionJSON

Summary:

Description:

 

          Properties:

Name

Type

Summary

input

string

Value

XML string


 

outputBoolean

Summary:

Description:

 

          Properties:

Name

Type

Summary

result

boolean

Result

Result


 

outputCollectionNumber

Summary:

Description:

 

          Properties:

Name

Type

Summary

status

boolean

Success

Success

item

number

First Value

First Value

items

array of (number)

All Values

All Values


 

outputCollectionResult

Summary:

Description:

 

          Properties:

Name

Type

Summary

result

array of (string)

Modified collection result

Modified collection result


 

outputCollectionString

Summary:

Description:

 

          Properties:

Name

Type

Summary

status

boolean

Success

Success

item

string

First Value

First Value

items

array of (string)

All Values

All Values


 

outputDateDifference

Summary:

Description:

 

          Properties:

Name

Type

Summary

years

number

Years

Years

months

number

Months

Months

days

number

Days

Days

hours

number

Hours

Hours

minutes

number

Minutes

Minutes

milliseconds

number

Milliseconds

Milliseconds

totalYears

number(double)

Total Years

Total Years

totalMonths

number(double)

Total Months

Total Months

totalDays

number(double)

Total Days

Total Days

totalHours

number(double)

Total Hours

Total Hours

totalMinutes

number(double)

Total Minutes

Total Minutes

totalSeconds

number(double)

Total Seconds

Total Seconds

totalMilliseconds

number(double)

Total Milliseconds

Total Milliseconds

ticks

number

Ticks

Ticks


 

outputDateInfo

Summary:

Description:

 

          Properties:

Name

Type

Summary

DayOfYear

number

DayOfYear

DayOfYear

DayOfWeek

number

DayOfWeek

DayOfWeek

WeekOfYear

number

WeekOfYear

WeekOfYear

SecondsInDay

number

SecondsInDay

SecondsInDay

MinutesInDay

number

MinutesInDay

MinutesInDay

Ticks

number

Ticks

Ticks


 

outputMarketIndex

Summary:

Description:

 

          Properties:

Name

Type

Summary

date

string

Date

Date

symbol

string

Symbol

Index symbol

exchange

string

Exchange

Market exchange

open

number

Open

Open value

high

number

High

High value

low

number

Low

Low value

close

number

Close

Close value

volume

number

Volume

Trading volume

adj_open

number

Adjusted Open

Adjusted open value

adj_high

number

Adjusted High

Adjusted high value

adj_low

number

Adjusted Low

Adjusted low value

adj_close

number

Adjusted Close

Adjusted close value

adj_volume

number

Adjusted Volume

Adjusted trading volume


 

outputMultiCollection

Summary:

Description:

 

          Properties:

Name

Type

Summary

result1

array of (string)

First collection result

First collection result

result2

array of (string)

Second collection result

Second collection result


 

outputNumber

Summary:

Description:

 

          Properties:

Name

Type

Summary

result

number

Result

Result


 

outputStockPrice

Summary:

Description:

 

          Properties:

Name

Type

Summary

result

array of (ResultItem)

Stock price information

Stock price information

 

ResultItem

Summary:

Description:

 

          Properties:

Name

Type

Summary

date

string

Date

Date

symbol

string

Symbol

Ticker symbol

exchange

string

Exchange

Stock exchange

open

number

Open

Open

high

number

High

High

low

number

Low

Low

close

number

Close

Close

volume

number

Volume

Volume

 


 

outputString

Summary:

Description:

 

          Properties:

Name

Type

Summary

result

string

Result

Result


 

outputStringArray

Summary:

Description:

 

          Properties:

Name

Type

Summary

data

array of (string)

data

data


 

ShortenLinkParameterStringInput

Summary:

Description:

 

          Properties:

Name

Type

Summary

source

string

Source

String variable or text value


 

UrlDecodeParameterStringInput

Summary:

Description:

 

          Properties:

Name

Type

Summary

source

string

Source

Encoded string variable or text value


 

ValidateEmailParameterStringInput

Summary:

Description:

 

          Properties:

Name

Type

Summary

source

string

Source

String variable or text value