Apptigent PowerTools LITE

Reference

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!

This connector is available in the following products and regions:

Service	Class	Regions
Logic Apps	Standard	All Logic Apps regions except the following: - Azure Government regions - Azure China regions - US Department of Defense (DoD)
Power Automate	Premium	All Power Automate regions except the following: - US Government (GCC) - US Government (GCC High) - China Cloud operated by 21Vianet - US Department of Defense (DoD)
Power Apps	Premium	All Power Apps regions except the following: - US Government (GCC) - US Government (GCC High) - China Cloud operated by 21Vianet - US Department of Defense (DoD)

Contact
Name	Customer Support
URL	https://www.apptigent.com/help/
Email	[email protected]

Connector Metadata
Publisher	Apptigent Limited
Website	https://www.apptigent.com
Privacy policy	https://www.apptigent.com/help/privacy-policy/
Categories	Productivity;Business Management

Create user-driven solutions that solve everyday business problems in a fraction of the time with the ultimate FREE power user toolkit. Manipulate text, modify collections, format dates and times, convert currency, perform advanced mathematical calculations, shorten URL's, encode strings, and more in just a few clicks. No need to learn complex formulas or expression syntax, PowerTools takes care of all the heavy lifting so users can be instantly more productive. With a powerful toolkit of advanced capabilities at their disposal, every user in the organization will have the ability to deliver outstanding results.

Prerequisites

Create an account and subscribe to PowerTools Community Edition. It's completely free! Learn more at https://portal.apptigent.com/start.

How to get credentials

Generate an API key by following these simple steps:

Open https://portal.apptigent.com in your browser, click "Create an account" and follow the prompts.
Login with your new credentials and select the "Apps" link from the main menu.
Click the "Create new App" button.
Enter a Title and optional description (such as "Power Automate App") then click "Submit".
On successful submission, the App details page will be shown with your new credentials. Click the "Show" checkbox next to the Client ID field and copy the value - this is the key you will use in the "API Key" field to authorize a new connector.
Browse to "API Products", select "PowerTools LITE (Community Edition)", then click Subscribe under the Default plan.
Select the app name created in Step 4 and click "Subscribe" to finish.

Known issues and limitations

The Community Edition plan includes 50 free action calls per day. Visit our Subscriptions page at https://www.apptigent.com/solutions/power-tools/subscription-plans/ to learn more about plans with higher limits and advanced capabilities.

Creating a connection

The connector supports the following authentication types:


Default	Parameters for creating connection.	All regions	Not shareable

Default

Applicable: All regions

Parameters for creating connection.

This is not shareable connection. If the power app is shared with another user, another user will be prompted to create new connection explicitly.

Name	Type	Description	Required
API Key	securestring	PowerTools LITE (Community Edition) License Key	True

Throttling Limits

Name	Calls	Renewal Period
API calls per connection	100	60 seconds

Actions

Collections - Add to collection	Add an item to a collection
Collections - Contains number	Determine if a collection contains a specific number
Collections - Contains string	Determine if any items in a collection contain a specific string
Collections - Count collection	Count a collection of items
Collections - Ends with string	Determine if any items in a collection end with a specific string
Collections - Filter collection	Filter a collection of strings by keyword
Collections - Remove duplicates from collection	Remove duplicate items from a collection
Collections - Remove from collection	Remove an item from a collection
Collections - Replace values in collection	Replace whole or partial strings in a collection
Collections - Sort collection	Sort a collection of strings
Collections - Split collection	Split a collection of items by matching value or index
Collections - Starts with string	Determine if any items in a collection start with a specific string
DateTime - DateTime difference	Calculate the difference between two dates
DateTime - Format date and time	Create a date/time string in a specific format
DateTime - Get world time	Convert date and time from one time zone to another
Math - Calculate Absolute	Calculate the absolute value of a number
Math - Calculate Addition	Calculate the sum of two numbers
Math - Calculate average	Calculate the average of two or more numbers
Math - Calculate Cosine	Calculate the cosine value of an angle
Math - Calculate Division	Calculate the quotient of two numbers
Math - Calculate Logarithm	Calculate the logarithm of a number
Math - Calculate median	Calculate the median of two or more numbers
Math - Calculate minimum or maximum	Calculate the minimum or maximum value in a sequence of numbers
Math - Calculate Modulo	Calculate the remainder of dividing two numbers
Math - Calculate Multiplication	Calculate the product of two numbers
Math - Calculate Nth Root	Calculate the n-th root of a number
Math - Calculate power	Raise number to a specified power
Math - Calculate Sine	Calculate the sine value of an angle
Math - Calculate Square Root	Calculate the square root of a number
Math - Calculate standard deviation	Calculate the standard deviation of two or more numbers
Math - Calculate Subtraction	Calculate the difference between two numbers
Math - Calculate sum	Calculate the sum of two or more numbers
Math - Calculate Tangent	Calculate the tangent value of an angle
Math - Calculate variance	Calculate the statistical variance of two or more numbers
Math - Convert angle	Convert value from one angle measurement to another
Math - Convert area	Convert value from one area measurement to another
Math - Convert distance	Convert value from one distance measurement to another
Math - Convert duration	Convert value from one duration measurement to another
Math - Convert energy	Convert value from one energy measurement to another
Math - Convert power	Convert value from one power measurement to another
Math - Convert speed	Convert value from one speed measurement to another
Math - Convert temperature	Convert value from one temperature measurement to another
Math - Convert volume	Convert value from one volume measurement to another
Math - Convert weight	Convert value from one weight measurement to another
Math - Random number	Generate a random number within a specified range
Math - Round number	Round a numeric value up or down
Text - Compare strings	Perform a comparison of two strings
Text - Contains string	Determine if a string contains another string
Text - Convert case	Convert string to upper, lower or title case
Text - Decode string	Decode a string encoded with Base64 encoding
Text - Decode URL	Decode an encoded URL
Text - Encode string	Encode a string using Base64 encoding
Text - Encode URL	Generate an encoded string from a complex hyperlink
Text - Generate GUID	Generate a globally unique identifier
Text - Join strings	Join a collection of strings
Text - Redact string	Redact a strng containing sensitive content
Text - Replace string	Replace one value with another in a string
Text - Split string	Split a string based upon one or more characters
Text - Trim string	Trim leading or trailing whitespace from a string

Collections - Add to collection

Operation ID:: AddToCollection

Add an item to a collection

Parameters

Name	Key	Required	Type	Description
Collection	input	True	array of string	Collection of values or objects to modify
Item	item		string	Item (for multiple items, leave blank and use Items)
Items	items		array of string	Items (Collection, for a single item leave blank and use Item)
Index	index		string	Index position for operation (leave blank to specify end of collection)

Returns

Body: outputCollectionResult

Collections - Contains number

Operation ID:: CollectionContainsNumber

Determine if a collection contains a specific number

Parameters

Name	Key	Required	Type	Description
Values	input	True	array of number	Collection of strings to search
Number	match	True	number	Number to match
Number Type	type		string	Type of number - integer or decimal

Returns

Body: outputCollectionNumber

Collections - Contains string

Operation ID:: CollectionContainsString

Determine if any items in a collection contain a specific string

Parameters

Name	Key	Required	Type	Description
Values	input	True	array of string	Collection of strings to search
Text	match	True	string	Text to match
Trim	trim		string	Trim white space from comparison string
Ignore Case	ignorecase		string	Ignore case when performing comparison

Returns

Body: outputCollectionString

Collections - Count collection

Operation ID:: CountCollection

Count a collection of items

Parameters

Name	Key	Required	Type	Description
Collection	input	True	array of string	Collection of items to count

Returns

Body: outputNumber

Collections - Ends with string

Operation ID:: CollectionEndsWithString

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

Parameters

Name	Key	Required	Type	Description
Values	input	True	array of string	Collection of strings to search
Text	match	True	string	Text to match
Trim	trim		string	Trim white space from comparison string
Ignore Case	ignorecase		string	Ignore case when performing comparison

Returns

Body: outputCollectionString

Collections - Filter collection

Operation ID:: FilterCollection

Filter a collection of strings by keyword

Parameters

Name	Key	Required	Type	Description
Collection	input	True	array of string	Collection of strings to filter
Match	match	True	string	Match type
Keywords	keywords	True	string	Keywords (separate multiple values with commas)

Returns

Body: outputCollectionResult

Collections - Remove duplicates from collection

Operation ID:: RemoveDuplicates

Remove duplicate items from a collection

Parameters

Name	Key	Required	Type	Description
Collection	Collection		object

Returns

Body: outputCollectionResult

Collections - Remove from collection

Operation ID:: RemoveFromCollection

Remove an item from a collection

Parameters

Name	Key	Required	Type	Description
Collection	input	True	array of string	Collection of values or objects to modify
Item	item		string	Item (for multiple items, leave blank and use Items)
Items	items		array of string	Items (Collection, for a single item leave blank and use Item)
Index	index		string	Index position for operation (leave blank to specify end of collection)

Returns

Body: outputCollectionResult

Collections - Replace values in collection

Operation ID:: ReplaceValuesInCollection

Replace whole or partial strings in a collection

Parameters

Name	Key	Required	Type	Description
Collection	input	True	array of string	Collection of strings
Match value	match	True	string	Match value
Replacement value	replacement	True	string	Replacement value
Ignore case	ignoreCase	True	string	Ignore case

Returns

Body: outputCollectionResult

Collections - Sort collection

Operation ID:: SortCollection

Sort a collection of strings

Parameters

Name	Key	Required	Type	Description
Collection	input	True	array of string	Collection of strings to sort
Order	order	True	string	Sort order

Returns

Body: outputCollectionResult

Collections - Split collection

Operation ID:: SplitCollection

Split a collection of items by matching value or index

Parameters

Name	Key	Required	Type	Description
Collection	input	True	array of string	Collection of items to split
Match Value	match		string	String to match (explicit, case-insensitive, leave empty to use Index)
Index	index		string	Index location to split (leave empty to use Match value)

Returns

Body: outputMultiCollection

Collections - Starts with string

Operation ID:: CollectionStartsWithString

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

Parameters

Name	Key	Required	Type	Description
Values	input	True	array of string	Collection of strings to search
Text	match	True	string	Text to match
Trim	trim		string	Trim white space from comparison string
Ignore Case	ignorecase		string	Ignore case when performing comparison

Returns

Body: outputCollectionString

DateTime - DateTime difference

Operation ID:: DateTimeDifference

Calculate the difference between two dates

Parameters

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

Returns

Body: outputDateDifference

DateTime - Format date and time

Operation ID:: FormatDateTime

Create a date/time string in a specific format

Parameters

Name	Key	Required	Type	Description
Value	input	True	string	Source date and time
Culture	culture	True	string	Language culture
Format	format	True	string	Output format

Returns

Body: outputString

DateTime - Get world time

Operation ID:: WorldTime

Convert date and time from one time zone to another

Parameters

Name	Key	Required	Type	Description
Value	input	True	string	Source date and time
Source Time Zone	source	True	string
Target Time Zone	target	True	string
Format	format		string	Display format (defaults to 'yyyy-MM-dd HH:mm:ss')

Returns

Body: outputString

Math - Calculate Absolute

Operation ID:: CalculateAbsolute

Calculate the absolute value of a number

Parameters

Name	Key	Required	Type	Description
Value	input	True	number	Numeric value to calculate
Decimal Places	decimals	True	number	Round to number of decimal places

Returns

Body: outputNumber

Math - Calculate Addition

Operation ID:: CalculateAddition

Calculate the sum of two numbers

Parameters

Name	Key	Required	Type	Description
Primary Value	input	True	number	Numeric value
Secondary Value	value	True	number	Addend, subtrahend, factor, divisor or radicand
Decimal Places	decimals	True	number	Round to number of decimal places

Returns

Body: outputNumber

Math - Calculate average

Operation ID:: CalculateAverage

Calculate the average of two or more numbers

Parameters

Name	Key	Required	Type	Description
Values	input	True	array of number	Collection of values to calculate
Decimal Places	decimals	True	number	Round to number of decimal places

Returns

Body: outputNumber

Math - Calculate Cosine

Operation ID:: CalculateCosine

Calculate the cosine value of an angle

Parameters

Name	Key	Required	Type	Description
Value	input	True	number	Numeric value to calculate
Decimal Places	decimals	True	number	Round to number of decimal places

Returns

Body: outputNumber

Math - Calculate Division

Operation ID:: CalculateDivision

Calculate the quotient of two numbers

Parameters

Name	Key	Required	Type	Description
Primary Value	input	True	number	Numeric value
Secondary Value	value	True	number	Addend, subtrahend, factor, divisor or radicand
Decimal Places	decimals	True	number	Round to number of decimal places

Returns

Body: outputNumber

Math - Calculate Logarithm

Operation ID:: CalculateLogarithm

Calculate the logarithm of a number

Parameters

Name	Key	Required	Type	Description
Value	input	True	number	Numeric value to calculate
Decimal Places	decimals	True	number	Round to number of decimal places

Returns

Body: outputNumber

Math - Calculate median

Operation ID:: CalculateMedian

Calculate the median of two or more numbers

Parameters

Name	Key	Required	Type	Description
Values	input	True	array of number	Collection of values to calculate
Decimal Places	decimals	True	number	Round to number of decimal places

Returns

Body: outputNumber

Math - Calculate minimum or maximum

Operation ID:: CalculateMinMax

Calculate the minimum or maximum value in a sequence of numbers

Parameters

Name	Key	Required	Type	Description
Values	input	True	array of number	Collection of values to calculate
Min or Max	type	True	string	Minimum or Maximum

Returns

Body: outputNumber

Math - Calculate Modulo

Operation ID:: CalculateModulo

Calculate the remainder of dividing two numbers

Parameters

Name	Key	Required	Type	Description
Primary Value	input	True	number	Numeric value
Secondary Value	value	True	number	Addend, subtrahend, factor, divisor or radicand
Decimal Places	decimals	True	number	Round to number of decimal places

Returns

Body: outputNumber

Math - Calculate Multiplication

Operation ID:: CalculateMultiplication

Calculate the product of two numbers

Parameters

Name	Key	Required	Type	Description
Primary Value	input	True	number	Numeric value
Secondary Value	value	True	number	Addend, subtrahend, factor, divisor or radicand
Decimal Places	decimals	True	number	Round to number of decimal places

Returns

Body: outputNumber

Math - Calculate Nth Root

Operation ID:: CalculateNthRoot

Calculate the n-th root of a number

Parameters

Name	Key	Required	Type	Description
Primary Value	input	True	number	Numeric value
Secondary Value	value	True	number	Addend, subtrahend, factor, divisor or radicand
Decimal Places	decimals	True	number	Round to number of decimal places

Returns

Body: outputNumber

Math - Calculate power

Operation ID:: CalculatePower

Raise number to a specified power

Parameters

Name	Key	Required	Type	Description
Number	input	True	number	Number to raise
Power	power	True	number	Power
Decimal Places	decimals	True	number	Round to number of decimal places

Returns

Body: outputNumber

Math - Calculate Sine

Operation ID:: CalculateSine

Calculate the sine value of an angle

Parameters

Name	Key	Required	Type	Description
Value	input	True	number	Numeric value to calculate
Decimal Places	decimals	True	number	Round to number of decimal places

Returns

Body: outputNumber

Math - Calculate Square Root

Operation ID:: CalculateSquareRoot

Calculate the square root of a number

Parameters

Name	Key	Required	Type	Description
Value	input	True	number	Numeric value to calculate
Decimal Places	decimals	True	number	Round to number of decimal places

Returns

Body: outputNumber

Math - Calculate standard deviation

Operation ID:: StandardDeviation

Calculate the standard deviation of two or more numbers

Parameters

Name	Key	Required	Type	Description
Values	input	True	array of number	Collection of values to calculate
Decimal Places	decimals	True	number	Round to number of decimal places

Returns

Body: outputNumber

Math - Calculate Subtraction

Operation ID:: CalculateSubtraction

Calculate the difference between two numbers

Parameters

Name	Key	Required	Type	Description
Primary Value	input	True	number	Numeric value
Secondary Value	value	True	number	Addend, subtrahend, factor, divisor or radicand
Decimal Places	decimals	True	number	Round to number of decimal places

Returns

Body: outputNumber

Math - Calculate sum

Operation ID:: CalculateSum

Calculate the sum of two or more numbers

Parameters

Name	Key	Required	Type	Description
Values	input	True	array of number	Collection of values to calculate
Decimal Places	decimals	True	number	Round to number of decimal places

Returns

Body: outputNumber

Math - Calculate Tangent

Operation ID:: CalculateTangent

Calculate the tangent value of an angle

Parameters

Name	Key	Required	Type	Description
Value	input	True	number	Numeric value to calculate
Decimal Places	decimals	True	number	Round to number of decimal places

Returns

Body: outputNumber

Math - Calculate variance

Operation ID:: CalculateVariance

Calculate the statistical variance of two or more numbers

Parameters

Name	Key	Required	Type	Description
Values	input	True	array of number	Collection of values to calculate
Decimal Places	decimals	True	number	Round to number of decimal places

Returns

Body: outputNumber

Math - Convert angle

Operation ID:: ConvertAngle

Convert value from one angle measurement to another

Parameters

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

Returns

Body: outputNumber

Math - Convert area

Operation ID:: ConvertArea

Convert value from one area measurement to another

Parameters

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

Returns

Body: outputNumber

Math - Convert distance

Operation ID:: ConvertDistance

Convert value from one distance measurement to another

Parameters

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

Returns

Body: outputNumber

Math - Convert duration

Operation ID:: ConvertDuration

Convert value from one duration measurement to another

Parameters

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

Returns

Body: outputNumber

Math - Convert energy

Operation ID:: ConvertEnergy

Convert value from one energy measurement to another

Parameters

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

Returns

Body: outputNumber

Math - Convert power

Operation ID:: ConvertPower

Convert value from one power measurement to another

Parameters

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

Returns

Body: outputNumber

Math - Convert speed

Operation ID:: ConvertSpeed

Convert value from one speed measurement to another

Parameters

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

Returns

Body: outputNumber

Math - Convert temperature

Operation ID:: ConvertTemperature

Convert value from one temperature measurement to another

Parameters

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

Returns

Body: outputNumber

Math - Convert volume

Operation ID:: ConvertVolume

Convert value from one volume measurement to another

Parameters

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

Returns

Body: outputNumber

Math - Convert weight

Operation ID:: ConvertWeight

Convert value from one weight measurement to another

Parameters

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

Returns

Body: outputNumber

Math - Random number

Operation ID:: RandomNumber

Generate a random number within a specified range

Parameters

Name	Key	Required	Type	Description
Start	start	True	number	Start of range
End	end	True	number	End of range

Returns

Body: outputNumber

Math - Round number

Operation ID:: RoundNumber

Round a numeric value up or down

Parameters

Name	Key	Required	Type	Description
Value	input	True	number	Numeric value to calculate
Decimal Places	decimals	True	number	Round to number of decimal places

Returns

Body: outputNumber

Text - Compare strings

Operation ID:: CompareStrings

Perform a comparison of two strings

Parameters

Name	Key	Required	Type	Description
Source	input	True	string	Original string
Target	compare	True	string	Comparison string
Lowercase	lower	True	string	Convert strings to lowercase before comparison
Trim	trim	True	string	Trim strings before comparison

Returns

Body: outputString

Text - Contains string

Operation ID:: ContainsString

Determine if a string contains another string

Parameters

Name	Key	Required	Type	Description
Value	find	True	string	Text to match
Target	input	True	string	Text to search
Lowercase	lower	True	string	Convert strings to lowercase

Returns

Body: outputString

Text - Convert case

Operation ID:: ConvertCase

Convert string to upper, lower or title case

Parameters

Name	Key	Required	Type	Description
Value	input	True	string	String containing the text to convert
Case	alphacase	True	string	Case of conversion result

Returns

Body: outputString

Text - Decode string

Operation ID:: DecodeString

Decode a string encoded with Base64 encoding

Parameters

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

Returns

Body: outputString

Text - Decode URL

Operation ID:: UrlDecode

Decode an encoded URL

Parameters

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

Returns

Body: outputString

Text - Encode string

Operation ID:: EncodeString

Encode a string using Base64 encoding

Parameters

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

Returns

Body: outputString

Text - Encode URL

Operation ID:: UrlEncode

Generate an encoded string from a complex hyperlink

Parameters

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

Returns

Body: outputString

Text - Generate GUID

Operation ID:: GenerateGuid

Generate a globally unique identifier

Parameters

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

Returns

Body: outputString

Text - Join strings

Operation ID:: JoinStrings

Join a collection of strings

Parameters

Name	Key	Required	Type	Description
Values	input	True	array of string	Collection of strings to be joined
Separator	separator	True	string	Separator character
Lowercase	lower	True	string	Convert strings in collection to lowercase
Trim	trim	True	string	Trim strings in collection

Returns

Body: outputString

Text - Redact string

Operation ID:: RedactString

Redact a strng containing sensitive content

Parameters

Name	Key	Required	Type	Description
Source String	source	True	string	String containing the complete text
Value	value		string	Individual string to redact
-OR- Values Collection	values		array of string	Collection of strings to redact
-OR- Regular Expression	regex		string	Regular expression pattern for matching strings

Returns

Body: outputString

Text - Replace string

Operation ID:: ReplaceString

Replace one value with another in a string

Parameters

Name	Key	Required	Type	Description
Source	source	True	string	String containing the text to be replaced
Value	value	True	string	Text to replace
Replacement	replacement	True	string	Replacement text

Returns

Body: outputString

Text - Split string

Operation ID:: SplitString

Split a string based upon one or more characters

Parameters

Name	Key	Required	Type	Description
Value	input	True	string	Text to split
Character(s)	characters	True	string	One or more characters that will be used to split the text

Returns

Body: outputStringArray

Text - Trim string

Operation ID:: TrimString

Trim leading or trailing whitespace from a string

Parameters

Name	Key	Required	Type	Description
Source	source	True	string	String containing the text to be trimmed
Type	type	True	string	Type of white space to remove

Returns

Body: outputString

Definitions

outputStringArray

Name	Path	Type	Description
data	data	array of string	data

outputDateDifference

Name	Path	Type	Description
Years	years	number	Years
Months	months	number	Months
Days	days	number	Days
Hours	hours	number	Hours
Minutes	minutes	number	Minutes
Milliseconds	milliseconds	number	Milliseconds
Total Years	totalYears	double	Total Years
Total Months	totalMonths	double	Total Months
Total Days	totalDays	double	Total Days
Total Hours	totalHours	double	Total Hours
Total Minutes	totalMinutes	double	Total Minutes
Total Seconds	totalSeconds	double	Total Seconds
Total Milliseconds	totalMilliseconds	double	Total Milliseconds
Ticks	ticks	number	Ticks

outputCollectionNumber

Name	Path	Type	Description
Success	status	boolean	Success
First Value	item	number	First Value
All Values	items	array of number	All Values

outputCollectionResult

Name	Path	Type	Description
Modified collection result	result	array of string	Modified collection result

outputCollectionString

Name	Path	Type	Description
Success	status	boolean	Success
First Value	item	string	First Value
All Values	items	array of string	All Values

outputMultiCollection

Name	Path	Type	Description
First collection result	result1	array of string	First collection result
Second collection result	result2	array of string	Second collection result

outputString

Name	Path	Type	Description
Result	result	string	Result

outputNumber

Name	Path	Type	Description
Result	result	number	Result

Поделиться через

Apptigent PowerTools LITE

Prerequisites

How to get credentials

Known issues and limitations

Creating a connection

Default

Throttling Limits

Actions

Collections - Add to collection

Parameters

Returns

Collections - Contains number

Parameters

Returns

Collections - Contains string

Parameters

Returns

Collections - Count collection

Parameters

Returns

Collections - Ends with string

Parameters

Returns

Collections - Filter collection

Parameters

Returns

Collections - Remove duplicates from collection

Parameters

Returns

Collections - Remove from collection

Parameters

Returns

Collections - Replace values in collection

Parameters

Returns

Collections - Sort collection

Parameters

Returns

Collections - Split collection

Parameters

Returns

Collections - Starts with string

Parameters

Returns

DateTime - DateTime difference

Parameters

Returns

DateTime - Format date and time

Parameters

Returns

DateTime - Get world time

Parameters

Returns

Math - Calculate Absolute

Parameters

Returns

Math - Calculate Addition

Parameters

Returns

Math - Calculate average

Parameters

Returns

Math - Calculate Cosine

Parameters

Returns

Math - Calculate Division

Parameters

Returns

Math - Calculate Logarithm

Parameters

Returns

Math - Calculate median

Parameters

Returns

Math - Calculate minimum or maximum

Parameters

Returns

Math - Calculate Modulo

Parameters