Integration Toolbox (Preview)
The Integration Toolbox provides a set of operations which transform data in various ways.
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 | Integration Toolbox support |
| URL | https://www.integration-toolbox.com |
| info@integration-toolbox.com |
| Connector Metadata | |
|---|---|
| Publisher | LF Software Engineering |
| Website | https://www.integration-toolbox.com |
| Privacy policy | https://web.integration-toolbox.com/privacy |
| Categories | Content and Files;Data |
Prerequisites
A subscription from integration-toolbox.com is needed to use this connector.
How to get credentials
After you have subscribed on integration-toolbox.com you will receive an API key that should be used when creating a new connection to Integration Toolbox in the Azure portal.
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 | Get an API Key from https://www.integration-toolbox.com | True |
Throttling Limits
| Name | Calls | Renewal Period |
|---|---|---|
| API calls per connection | 100 | 60 seconds |
Actions
| Compress data |
Compress data using GZip, Brotli, or Deflate. |
| Convert encoding |
Convert from one encoding to another. |
| CSV to JSON |
Convert CSV to JSON. |
| Decompress data |
Decompress data compressed with Gzip, Brotli, or Deflate. |
| Fixed width to JSON |
Convert fixed width text to JSON. |
| PGP decrypt |
Decrypt data encrypted with PGP. |
| PGP encrypt |
Encrypt data with PGP. |
| PGP generate keys |
Generate a PGP public and private key. |
| Sort JSON |
Sort JSON. |
Compress data
Compress data using GZip, Brotli, or Deflate.
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Compression Type
|
compressionType | True | string |
The compression algorithm to use. |
|
body
|
body | True |
Data to compress. |
Convert encoding
Convert from one encoding to another.
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Input Encoding
|
inputEncoding | True | string |
The encoding of the request body. |
|
Output Encoding
|
outputEncoding | True | string |
The wanted output encoding. |
|
Add Byte Order Mark (BOM)
|
addByteOrderMark | boolean |
Add byte order mark (BOM) to the output. Only applicable for UTF8, UTF16, UTF32. |
|
|
Body
|
Body | True |
Data to convert. |
CSV to JSON
Convert CSV to JSON.
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Delimiter
|
delimiter | True | string |
The delimiter to use when parsing the csv file. |
|
Has Header Record
|
hasHeaderRecord | True | boolean |
The first line of the csv file contains a header with column names. |
|
Has Fields Enclosed In Quotes
|
hasFieldsEnclosedInQuotes | True | boolean |
The fields in the csv file are enclosed in quotes. |
|
Body
|
Body | True |
CSV data. |
Decompress data
Decompress data compressed with Gzip, Brotli, or Deflate.
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Compression Type
|
compressionType | True | string |
The compression algorithm to use. |
|
body
|
body | True |
Data to decompress. |
Fixed width to JSON
Convert fixed width text to JSON.
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Field Widths
|
fieldWidths | True | string |
A comma separated list of integers containing the width of every field in the file. |
|
Has Header Record
|
hasHeaderRecord | True | boolean |
The first line of the csv file contains a header with column names. |
|
Body
|
Body | True |
Fixed width data. |
PGP decrypt
Decrypt data encrypted with PGP.
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Private Key
|
privateKey | True | string |
The PGP private key to use when decrypting the request body. |
|
Passphrase
|
passPhrase | string |
The passphrase to use when decrypting the request body. |
|
|
Body
|
Body | True |
Data to decrypt. |
PGP encrypt
Encrypt data with PGP.
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Public Key
|
publicKey | True | string |
The PGP public key to use when encrypting the request body. |
|
Body
|
Body | True |
Data to encrypt. |
PGP generate keys
Generate a PGP public and private key.
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Passphrase
|
passPhrase | string |
The passphrase to use when generating keys. |
|
|
Username
|
username | string |
The username to use when generating keys. |
Sort JSON
Sort JSON.
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Direction
|
direction | True | string |
Sorting direction. |
|
Sort Key
|
sortKey | string |
The name of the element to sort by, required when sorting objects. |
|
|
Body
|
Body | True |
JSON data. |