Power Assist
Built to accelerate your Power Platform development, Power Assist provides a wide array of endpoints to quickly and easily manipulate your data.
350 subscribers
2.2/10 popularity
290 ms avg latency
21% success rate
41 endpoints
The in-depth APIMemo review for this API hasn't been published yet —
the data below comes straight from the public marketplace listing.
Power Assist endpoints
| Method | Endpoint | Description |
|---|---|---|
| Strings | ||
| POST |
Chop /api/string/chop |
Chop the string into an Array based on an interval, which defines the size of the pieces. |
| POST |
CountInstances /api/string/countInstances |
Get the number of occurrences of a substring within a string. |
| POST |
UnescapeHtml /api/string/unescapeHtml |
Convert entity characters (for example, <) to HTML equivalents (for example, |
| POST |
EscapeHtml /api/string/escapeHtml |
Convert HTML special characters, like < and >, to their entity equivalents (for example < and >). This action supports cent, yen, euro, pound, lt, gt, copy, reg, quote,… |
| POST |
CleanDiacritics /api/string/cleanDiacritics |
Replace all diacritic characters (letters with glyphs) in a string with the closest ASCII equivalents. |
| POST |
Clean Whitespace /api/string/clean |
Trim and replace multiple spaces with a single space. (This includes whitespace characters like \t and \n.) For cleaning special characters out of a string for a URL, use Slugify. |
| POST |
StripHtml /api/string/stripHtml |
Remove all HTML and XML tags from a string. |
| POST |
WordCount /api/string/wordCount |
Count the words in a String by a delimiter (String or RegEx pattern). The delimiter is whitespace by default. If using RegEx, include the leading and trailing '/' in your pattern… |
| POST |
Words /api/string/words |
Split string by delimiter (String or RegEx pattern). The action splits by whitespace by default. If using RegEx, include the leading and trailing '/' in your pattern and… |
| POST |
Slugify /api/string/slugify |
Transform text into an ASCII slug which can be used in safely in URLs. Replaces whitespaces, accentuated, and special characters with a dash. Many non-ASCII characters are… |
| POST |
TrimEnd /api/string/trimEnd |
Trim whitespace (by default) or specified characters from the end of a string. |
| POST |
TrimStart /api/string/trimStart |
Trim whitespace (the default) or specified characters only at the start of a string. |
| POST |
RegexReplace /api/string/regexReplace |
Find and replace within a String using a RegEx pattern. Include the leading and trailing '/' in your pattern and optionally append flags. If the /g flag is used, it will replace… |
| POST |
Trim /api/string/trim |
Trims leading and trailing whitespace (the default) or specified characters from a string. |
| POST |
Capitalize /api/string/capitalize |
Sets the first character of the string to upper case, and all subsequent characters to lower case. |
| POST |
ReplaceAll /api/string/replaceAll |
In a string, find and replace all instances of a substring. This action is case sensitive. Does not accept RegEx. To use RegEx and control case sensitivity, see the "String RegEx… |
| Arrays | ||
| POST |
FindFirst /api/array/findFirst |
Accepts an array of any data type, including objects. Returns the first item that matches the specified condition. If no item matches the condition, Null is returned. Use the… |
| POST |
GroupBy /api/array/groupBy |
Group an Array of items. Accepts an Array of any data type. Returns a "Result" Object with keys that reflect the values of the provided propertyName. Under each key are the items… |
| POST |
RemoveFirst /api/array/removeFirst |
Accepts an Array of any data type. Returns an Array with the first Item that matches the specified condition removed. If no Item matches the condition, the entire Array is… |
| POST |
Every /api/array/every |
This action returns True if all of the items in an array match a specified condition; otherwise, it returns False. |
| POST |
Any /api/array/any |
This action returns True if any of the items in an array match a specified condition; otherwise, it returns False. If the array consists of a simple data type such as String,… |
| POST |
Prepend /api/array/prepend |
Given an Array and a Value, this action adds the Value as the first item in the Array and returns the resulting Array. If an Array is supplied as the Value, a flat array will be… |
| POST |
Filter /api/array/filter |
Filter an Array of any data type (except nested Arrays) based on a specified condition. If the array consists of a simple data type such as String, Integer, or Boolean, use the… |
| POST |
SortByProperty /api/array/sortByProperty |
Accepts an Array of Objects and sorts it by the object Property specified. If any objects lack the specified property, it will still perform the sort. Optionally accepts the… |
| POST |
Reverse /api/array/reverse |
Reverse the order of an Array of any data type and returns it. |
| POST |
Sort /api/array/sort |
Perform a simple sort on an Array of any data type and returns it. If an empty Array is provided, it will be returned. |
| POST |
ObjectToArray /api/array/objectToArray |
Accepts an Object and returns an Array based on the Object's keys, allowing looping on the Object. If Null or an empty object is passed in, an empty Array will be returned. |
| Math | ||
| POST |
Random /api/math/random |
Generates a pseudo-random number between the minimum of 0 and the specified maximum (maximum must be 1, 10, 100, 1000, 10000). |
| POST |
Mode /api/math/mode |
Calculates the mode (the number that occurs most often) from an Array of numbers. Strings that can be converted to numbers are allowed, but formatting such as commas are NOT… |
| POST |
Median /api/math/median |
Calculates the median from an Array of numbers. Strings that can be converted to numbers are allowed, but formatting such as commas are NOT supported. |
| POST |
Average /api/math/average |
Calculates the average (mean) from an Array of numbers. Strings that can be converted to numbers are allowed, but formatting such as commas are NOT supported. |
| POST |
Round /api/math/round |
Rounds a number to the nearest integer. If an integer is passed in, it will be returned unchanged. Supports numbers passed in as strings, but does NOT support commas or other… |
| POST |
Floor /api/math/floor |
Rounds a number down to the nearest integer. Supports numbers passed in as strings, but does NOT support commas or other formatting in number strings. If an integer is passed in,… |
| POST |
Ceil /api/math/ceil |
Rounds a number up to the nearest integer. Supports numbers passed in as strings, but does NOT support commas or other formatting in number strings. If an integer is passed in,… |
| Types | ||
| POST |
IsObject /api/types/isObject |
Validate whether a supplied Value is an Object. Empty Objects will evaluate to True. Arrays and other data types will evaluate to False. |
| POST |
IsNumber /api/types/isNumber |
Validates that a value is a Number. Numbers inside strings, such as "999" will be evaluated to False unless the "includeNumbersInStrings" parameter is set to True. |
| POST |
IsString /api/types/isString |
Validates whether a supplied value is of type String. |
| POST |
IsNullOrEmpty /api/types/isNullOrEmpty |
Check if value is null or empty. Can be used for Strings, Arrays, or Objects. |
| POST |
IsArray /api/types/isArray |
Validate whether a supplied Value is an Array. |
| Validation | ||
| POST |
Email /api/validate/email |
Validates that a String matches the common email format. Does NOT send an email. Returns True if the validation passes; otherwise, False. |
| POST |
Regex /api/validate/regex |
Validates that a String against a supplied RegEx pattern. Include the leading and trailing '/' in your RegEx pattern and optionally append flags. |
Power Assist pricing
| Plan | Price | Rate limit | Quotas |
|---|---|---|---|
| BASIC | Free | — |
|
| PRO | $14.95 / month | — |
|