Connectors Reference

Apptigent PowerTools LITE

Apptigent PowerTools LITE (Community Edition) is a FREE suite of essential utilities for enterprise workflow, forms and cloud applications. Manipulate text, modify collections, format dates and times, convert currency, perform advanced mathematical calculations, shorten URL's, encode strings, and more. PowerTools is the ultimate power user toolkit - FREE!

 

Status: Preview

Tier: Premium

Version: 2020.3.14

 

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

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 min or max

calculateSum ([Optional]inputCalculateSeries calculateSeries)

Math - Calculate sum

calculatePower ([Optional]inputCalculatePower calculatePower)

Math - Calculate power

calculateVariance ([Optional]inputCalculateSeries calculateSeries)

Math - Calculate variance

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

joinStrings ([Optional]inputJoinStrings joinStrings)

Text - Join strings

redactString ([Optional]inputRedactString redactString)

Text - Redact string

replaceString ([Optional]inputReplaceString replaceString)

Text - Replace string

splitString ([Optional]inputSplitString splitString)

Text - Split string

trimString ([Optional]inputTrimString trimString)

Text - Trim string

urlDecode ([Optional]urlDecodeParameterStringInput stringInput)

Text - Decode URL

urlEncode ([Optional]inputString stringInput)

Text - Encode URL

 

Triggers:

Name

Summary

 

Objects:

Name

Summary

decodeStringParameterStringInput

 

inputCalculateMinMax

 

inputCalculateNumber

 

inputCalculatePower

 

inputCalculateSeries

 

inputCaseConversion

 

inputCollectionCount

 

inputCollectionFilter

 

inputCollectionModify

 

inputCollectionReplace

 

inputCollectionSearch

 

inputCollectionSearchNumeric

 

inputCollectionSort

 

inputCollectionSplit

 

inputDateTimeConversion

 

inputDateTimeDifference

 

inputDateTimeFormat

 

inputGenerateUniqueID

 

inputJoinStrings

 

inputNumberRange

 

inputRedactString

 

inputReplaceString

 

inputSplitString

 

inputString

 

inputStringComparison

 

inputStringContains

 

inputTrimString

 

outputCollectionNumber

 

outputCollectionResult

 

outputCollectionString

 

outputDateDifference

 

outputMultiCollection

 

outputNumber

 

outputString

 

outputStringArray

 

urlDecodeParameterStringInput

 

 

Actions:

addToCollection

Summary: Collections - Add to collection

Description: Add an item to a collection

 

Syntax:

ApptigentPowerToolsLITE.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:

ApptigentPowerToolsLITE.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:

ApptigentPowerToolsLITE.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:

ApptigentPowerToolsLITE.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:

ApptigentPowerToolsLITE.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:

ApptigentPowerToolsLITE.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:

ApptigentPowerToolsLITE.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:

ApptigentPowerToolsLITE.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:

ApptigentPowerToolsLITE.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:

ApptigentPowerToolsLITE.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:

ApptigentPowerToolsLITE.collectionContainsNumber ([Optional]inputCollectionSearchNumeric collectionSearch)

 

Parameters:

Name

Type

Summary

Required

Related Action

collectionSearch

inputCollectionSearchNumeric

 

 

False

 

Returns:

          Type:outputCollectionNumber

 

dateTimeDifference

Summary: DateTime - DateTime difference

Description: Calculate the difference between two dates

 

Syntax:

ApptigentPowerToolsLITE.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:

ApptigentPowerToolsLITE.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:

ApptigentPowerToolsLITE.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:

ApptigentPowerToolsLITE.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:

ApptigentPowerToolsLITE.calculateMedian ([Optional]inputCalculateSeries calculateSeries)

 

Parameters:

Name

Type

Summary

Required

Related Action

calculateSeries

inputCalculateSeries

 

 

False

 

Returns:

          Type:outputNumber

 

calculateMinMax

Summary: Math - Calculate min or max

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

 

Syntax:

ApptigentPowerToolsLITE.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:

ApptigentPowerToolsLITE.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:

ApptigentPowerToolsLITE.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:

ApptigentPowerToolsLITE.calculateVariance ([Optional]inputCalculateSeries calculateSeries)

 

Parameters:

Name

Type

Summary

Required

Related Action

calculateSeries

inputCalculateSeries

 

 

False

 

Returns:

          Type:outputNumber

 

randomNumber

Summary: Math - Random number

Description: Generate a random number within a specified range

 

Syntax:

ApptigentPowerToolsLITE.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:

ApptigentPowerToolsLITE.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:

ApptigentPowerToolsLITE.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:

ApptigentPowerToolsLITE.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:

ApptigentPowerToolsLITE.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:

ApptigentPowerToolsLITE.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:

ApptigentPowerToolsLITE.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:

ApptigentPowerToolsLITE.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:

ApptigentPowerToolsLITE.generateGuid ([Optional]inputGenerateUniqueID generateUniqueID)

 

Parameters:

Name

Type

Summary

Required

Related Action

generateUniqueID

inputGenerateUniqueID

 

 

False

 

Returns:

          Type:outputString

 

joinStrings

Summary: Text - Join strings

Description: Join a collection of strings

 

Syntax:

ApptigentPowerToolsLITE.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:

ApptigentPowerToolsLITE.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:

ApptigentPowerToolsLITE.replaceString ([Optional]inputReplaceString replaceString)

 

Parameters:

Name

Type

Summary

Required

Related Action

replaceString

inputReplaceString

 

 

False

 

Returns:

          Type:outputString

 

splitString

Summary: Text - Split string

Description: Split a string based upon one or more characters

 

Syntax:

ApptigentPowerToolsLITE.splitString ([Optional]inputSplitString splitString)

 

Parameters:

Name

Type

Summary

Required

Related Action

splitString

inputSplitString

 

 

False

 

Returns:

          Type:outputStringArray

 

trimString

Summary: Text - Trim string

Description: Trim leading or trailing whitespace from a string

 

Syntax:

ApptigentPowerToolsLITE.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:

ApptigentPowerToolsLITE.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:

ApptigentPowerToolsLITE.urlEncode ([Optional]inputString stringInput)

 

Parameters:

Name

Type

Summary

Required

Related Action

stringInput

inputString

 

 

False

 

Returns:

          Type:outputString

 


 

decodeStringParameterStringInput

Summary:

Description:

 

          Properties:

Name

Type

Summary

source

string

Source

Encoded string variable or text value


 

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


 

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]


 

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)


 

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


 

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]


 

inputNumberRange

Summary:

Description:

 

          Properties:

Name

Type

Summary

start

number

Start

Start of range

end

number

End

End of range


 

inputRedactString

Summary:

Description:

 

          Properties:

Name

Type

Summary

value

string

Value

Individual string to redact

source

string

Source String

String containing the complete text

values

array of (string)

-OR- Values

Collection of strings to redact


 

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


 

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]


 

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]


 

outputCollectionNumber

Summary:

Description:

 

          Properties:

Name

Type

Summary

status

boolean

Success

Success

item

number

First Match

First matching value

items

array of (number)

All Matches

All matching 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


 

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


 

outputString

Summary:

Description:

 

          Properties:

Name

Type

Summary

result

string

Result

Result


 

outputStringArray

Summary:

Description:

 

          Properties:

Name

Type

Summary

data

array of (string)

data

data


 

urlDecodeParameterStringInput

Summary:

Description:

 

          Properties:

Name

Type

Summary

source

string

Source

Encoded string variable or text value