Apptigent PowerTools MCP connector

Apptigent PowerTools Developer Edition is a suite of API endpoints for text manipulation, collection modification, date formatting, currency conversion, and mathematical calculations. The Apptigent PowerTools MCP connector allows AI agents to transform data formats like CSV to JSON, perform mathematical operations including trigonometric and statistical functions, and manipulate text strings and collections. It also supports currency conversions, date and time formatting, and complex calculations such as averages, medians, and logarithms.

Authentication type

• API Key - Requires a static API key to be configured before the agent can connect to the service.

Uses

Use the Apptigent PowerTools MCP connector to perform the following actions:

• Transform CSV data into JSON format for downstream system integration
• Perform complex mathematical calculations across large datasets automatically
• Convert currencies in real-time for multi-region financial workflows
• Manipulate text strings to standardize customer data formats
• Validate and compare collection contents against business rules
• Format dates consistently across different time zones and locales
• Calculate statistical metrics like averages, medians, and variance for reporting

Example prompts

Use the following example prompts to invoke Apptigent PowerTools MCP connector tools from your AI assistant or Boomi Connect workflow:

• Convert this CSV file to JSON using Apptigent PowerTools.
• Calculate the average of these sales figures with Apptigent PowerTools.
• Transform all customer names to uppercase in Apptigent PowerTools.
• Check if this list contains a specific product ID using Apptigent PowerTools.
• Convert 100 USD to EUR with Apptigent PowerTools.
• Split this comma-separated string into individual items with Apptigent PowerTools.
• Find the maximum value in this dataset using Apptigent PowerTools.
• Format these dates to match our standard in Apptigent PowerTools.
• Calculate the sum of all transaction amounts with Apptigent PowerTools.
• Check if these two email addresses match using Apptigent PowerTools.

Apptigent PowerTools MCP connector tools

The Apptigent PowerTools MCP connector provides the following tools. Each tool maps to a specific action you can invoke from your AI agent or automation.

Tool	Description
AddToCollection	Adds an item to an existing collection.
CsvToJson	Converts data from CSV format into JSON format.
CalculateAbsolute	Calculates the absolute value of a number.
CalculateAddition	Adds two or more numbers together.
CalculateAverage	Computes the average of a set of numbers.
CalculateCosine	Calculates the cosine of an angle.
CalculateDivision	Divides one number by another.
CalculateLogarithm	Calculates the logarithm of a number.
CalculateMedian	Finds the middle value in a set of numbers.
CalculateMinMax	Identifies the smallest or largest value in a dataset.
CalculateModulo	Calculates the remainder after division.
CalculateMultiplication	Multiplies two or more numbers together.
CalculateNthRoot	Calculates the nth root of a number.
CalculatePower	Raises a number to a specified exponent.
CalculateSine	Calculates the sine of an angle.
CalculateSquareRoot	Calculates the square root of a number.
CalculateSubtraction	Subtracts one number from another.
CalculateSum	Adds all values in a set of numbers.
CalculateTangent	Calculates the tangent of an angle.
CalculateVariance	Measures how spread out numbers are in a dataset.
CollectionContainsNumber	Checks if a collection includes a specific number.
CollectionContainsString	Checks if a collection includes a specific text value.
CollectionEndsWithString	Checks if a collection ends with a specific text value.
CollectionStartsWithString	Checks if a collection starts with a specific text value.
CollectionToJSON	Converts a collection into JSON format.
CollectionToXml	Converts a collection into XML format.
CompareStrings	Compares two text values for equality or differences.
ContainsString	Checks if text contains a specific substring.
ConvertAngle	Converts angle measurements between different units.
ConvertArea	Converts area measurements between different units.
ConvertCase	Text - Convert case.
ConvertCurrency	Currency - Convert currency.
ConvertDistance	Math - Convert distance.
ConvertDuration	Math - Convert duration.
ConvertEnergy	Math - Convert energy.
ConvertPower	Math - Convert power.
ConvertSpeed	Math - Convert speed.
ConvertTemperature	Math - Convert temperature.
ConvertVolume	Math - Convert volume.
ConvertWeight	Math - Convert weight.
CountCollection	Collections - Count collection.
DateTimeDifference	DateTime - DateTime difference.
DateTimeInfo	DateTime - Get date and time information.
DecodeString	Text - Decode string.
EncodeString	Text - Encode string.
FilterCollection	Collections - Filter collection.
FormatCurrency	Currency - Format currency.
FormatDateTime	DateTime - Format date and time.
GenerateGuid	Text - Generate GUID.
GenerateHash	Text - Generate hash.
GenerateQRCode	Files - Generate QR code.
JsonToCsv	Data - JSON to CSV.
JsonToHtml	Data - JSON to HTML Table.
JsonToXml	Data - JSON to XML.
JoinStrings	Text - Join strings.
MarketIndex	Finance - Market index.
QueryJson	Data - Query JSON.
QueryXml	Data - Query XML.
RandomNumber	Math - Random number.
RedactString	Text - Redact string.
RemoveFromCollection	Collections - Remove from collection.
ReplaceString	Text - Replace string.
ReplaceValuesInCollection	Collections - Replace values in collection.
RoundNumber	Math - Round number.
ShortenLink	Text - Shorten hyperlink.
SortCollection	Collections - Sort collection.
SplitCollection	Collections - Split collection.
SplitString	Text - Split string.
StandardDeviation	Math - Calculate standard deviation.
StockPrices	Finance - Stock prices.
StringToFile	Text - String to File.
TextToSpeech	Text - Text to Speech.
TranslateString	Text - Translate string.
TrimString	Text - Trim string.
UrlDecode	Text - Decode URL.
UrlEncode	Text - Encode URL.
ValidateEmail	Text - Validate email.
VerifyHash	Text - Verify hash.
WorldTime	DateTime - Get world time.
XmlToJson	Data - XML to JSON.