Sparse Power Box Tools (Preview)
Introducing the Sparse Power Box Tools. This connector gives Low-Code developers a set of tools to enhance your Power Platform capabilites. With these powerful tools you can build custom apps and automate workflows with ease.
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 | Sparse Support |
| URL | https://sparsedevelopment.nl/en/ |
| service@sparse.dev |
| Connector Metadata | |
|---|---|
| Publisher | Sparse Development |
| Website | https://sparsedevelopment.nl/en/ |
| Privacy policy | https://sparsedevelopment.nl/en/privacy-policy/ |
| Categories | Content and Files;Data |
Prerequisites
You will need the following to proceed:
- An Sparse subscription to use the Power Box connector
- An Sparse API key requested from https://sparsedevelopment.nl/en/power-box/apikey
How to get credentials
An Sparse API key can be requested from https://sparsedevelopment.nl/en/power-box/apikey. Fill in this contact form and we will contact you with the necessary details to obtain an API key.
Get started with your connector
To deploy the Sparse Power Box Tools connector as a custom connector, please follow these instructions:
- In Power Automate, search for the "Sparse Power Box" connector.
- Enter name for connection
- Fill in the API key
Known issues and limitations
There are currently no known issues or limitations with the Sparse Power Box Tools connector.
Common errors and remedies
There are currently no known issues or limitations with the Sparse Power Box Tools connector.
FAQ
Q: How can we contact Sparse Development?
A: You can contact Sparse Developtment using the contactform on the website https://sparsedevelopment.nl/en/contact/
Q: What are the costs of an API key?
A: We are currently calculating the price of an API key. Contact us and we make an personal offer.
Q: I want to add a tool to the Power Box Tools connector. Is this possible?
A: Yes! This is possibe. Contact us so we can obtain all the necessary requirements and build this tool for you.
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 - https://www.sparsedevelopment.nl/en/power-box/apikey | True |
Throttling Limits
| Name | Calls | Renewal Period |
|---|---|---|
| API calls per connection | 100 | 60 seconds |
Actions
| Add EXIF information to an image |
Add EXIF tags to an image |
| Add image stamp to PDF |
Add custom stamps to your PDF files. |
| Add rows to Excel |
Easily add multiple rows to an existing Excel file. |
| Add text stamp to image |
Add a text stamp to an image. |
| Add text stamp to PDF |
Add a text as a stamp to a PDF file. |
| Convert CSV to JSON |
This powerful tool allows users to convert CSV files to JSON data. |
| Convert HTML to PDF |
An HTML file (.html) is converted into a PDF file. |
| Convert URL to PDF |
Easily save a website url as a PDF file. |
| Fill a PDF form |
Populates the PDF Form provided with the JSON form data provided. |
| Get PDF form data |
Extracts data from a filled in PDF file and returns the data in JSON format allowing further actions. |
| Merge a set of PDF files to one PDF (Simple) |
Merge multiple pdf files |
| Merge images |
Makes it easy to merge images together. |
| Resize Image |
Resize Image |
| Slit PDF |
Easily split a PDF file into multiple PDF files. |
Add EXIF information to an image
Add EXIF tags to an image
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Image
|
image | byte |
Image |
|
|
Tags
|
tags | array of string |
Tags |
|
|
Location of the stamp
|
location | string |
Location of the stamp |
|
|
Fontcolor
|
fontColor | string |
Fontcolor |
|
|
Fontsize
|
fontSize | integer |
Fontsize |
|
|
Print TagName
|
printTagName | boolean |
Print TagName |
Returns
Add image stamp to PDF
Add custom stamps to your PDF files.
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
PDF
|
True | byte |
PDF file |
|
|
Image
|
image | True | byte |
Image that will be stamped |
|
Opacity
|
opacity | number |
Adjust the scale of the image |
|
|
Scale
|
scale | number |
Adjust the scale of the image |
|
|
Rotate
|
rotate | integer |
Rotate the image with degrees |
|
|
Y-Offset
|
yOffset | integer |
Y-Offset |
|
|
Start of Y-Offset
|
yOffsetStart | string |
Start of Y-Offset bottom or top |
|
|
X-Offset
|
xOffset | integer |
X-Offset |
Returns
Add rows to Excel
Easily add multiple rows to an existing Excel file.
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Sheetname
|
sheet | True | string |
Name of the sheet |
|
Data
|
Data | object | ||
|
Excel
|
excelFile | True | byte |
Excel file |
Returns
Add text stamp to image
Add a text stamp to an image.
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Image
|
image | byte |
Image |
|
|
Text to Stamp
|
text | string |
Text to Stamp |
|
|
Location of the stamp
|
location | string |
Location of the stamp |
|
|
Fontcolor
|
fontColor | string |
Fontcolor |
|
|
Fontsize
|
fontSize | integer |
Fontsize |
Returns
Add text stamp to PDF
Add a text as a stamp to a PDF file.
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
PDF
|
True | byte |
PDF file |
|
|
Text
|
text | True | string |
Text that will be stamped |
|
Font Color
|
color | string |
Color of the font |
|
|
Font Size
|
size | integer |
Size of the font |
|
|
Rotate
|
rotate | integer |
Rotate the text with degrees |
|
|
Y-Offset
|
yOffset | integer |
Y-Offset |
|
|
Start of Y-Offset
|
yOffsetStart | string |
Start of Y-Offset bottom or top |
|
|
X-Offset
|
xOffset | integer |
X-Offset |
Returns
Convert CSV to JSON
This powerful tool allows users to convert CSV files to JSON data.
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
CSV
|
csv | True | byte |
Comma seperated values (CSV) file |
|
Has headers
|
hasHeaders | True | boolean |
Does the first row contain headers |
|
Delimiter
|
delimiter | True | string |
Delimiter for splitting values |
Returns
- Body
- resp-200-csv-to-json
Convert HTML to PDF
An HTML file (.html) is converted into a PDF file.
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
HTML
|
content | True | string |
A valid HTML string. Use {{ property }} from data-property to replace values in HTML string with Liquid. |
|
Data
|
data | object |
Can be a JSON object. Use {{ property }} from data-property to replace values in HTML string with Liquid. |
|
|
MediaType
|
mediaType | string |
MediaType when printing HTML to PDF |
|
|
Page format
|
format | string |
Page Format of the PDF. Can be A4, A5 or A3 |
|
|
Landscape
|
landscape | boolean |
Print landscape or portrait |
|
|
Margin Left
|
left | string |
Margin Left |
|
|
Margin Right
|
right | string |
Margin Right |
|
|
Margin Top
|
top | string |
Margin Top |
|
|
Margin Bottom
|
bottom | string |
Margin Bottom |
Returns
Convert URL to PDF
Easily save a website url as a PDF file.
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Url
|
url | True | string |
A valid url |
|
MediaType
|
mediaType | string |
MediaType when printing HTML to PDF |
|
|
Page format
|
format | string |
Page format of the PDF. Can be A4, A5 or A3 |
|
|
Landscape
|
landscape | boolean |
Print landscape or portrait |
|
|
Margin Left
|
left | string |
Margin Left |
|
|
Margin Right
|
right | string |
Margin Right |
|
|
Margin Top
|
top | string |
Margin Top |
|
|
Margin Bottom
|
bottom | string |
Margin Bottom |
Returns
Fill a PDF form
Populates the PDF Form provided with the JSON form data provided.
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
PDF-file
|
byte |
PDF-file with form |
||
|
Data
|
data | object |
Can be a JSON object.The data-property must match to the name of the element you want to fill in form. |
Returns
Get PDF form data
Extracts data from a filled in PDF file and returns the data in JSON format allowing further actions.
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
PDF-file
|
byte |
PDF-file with form |
Returns
Merge a set of PDF files to one PDF (Simple)
Merge multiple pdf files
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
PDF-file
|
pdfs | array of byte |
PDF-file |
Returns
Merge images
Makes it easy to merge images together.
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Background
|
background | True | byte |
Background image |
|
Drawing
|
drawing | True | byte |
Drawing image (should have transparent background) |
Returns
Resize Image
Resize Image
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Image
|
image | byte |
Image |
|
|
Width
|
width | integer |
Width of the image |
|
|
Height
|
height | integer |
Height of the image |
|
|
Ignore the Aspect Ration
|
ignoreAspectRation | boolean |
Ignore the Aspect Ration |
Returns
Slit PDF
Easily split a PDF file into multiple PDF files.
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
PDF-file
|
byte |
PDF-file |
||
|
Number of Pages
|
numberOfPages | number |
Splits PDF documents by the number of pages specified. |
Returns
Definitions
resp-200-image-merge-drawing
| Name | Path | Type | Description |
|---|---|---|---|
|
Merged Image
|
result | byte |
Merged image with background and drawing |
resp-200-csv-to-json
| Name | Path | Type | Description |
|---|---|---|---|
|
Records
|
records | array of object |
Records from CSV |
|
items
|
records | object |
resp-200-image-resize
| Name | Path | Type | Description |
|---|---|---|---|
|
Resized image
|
result | byte |
Resized image |
resp-200-image-stamp-text
| Name | Path | Type | Description |
|---|---|---|---|
|
Stamped image
|
result | byte |
Stamped image |
resp-200-pdf-split-by-page
| Name | Path | Type | Description |
|---|---|---|---|
|
PDF-file
|
results | array of byte |
PDF-file |
resp-200-image-stamp-exif
| Name | Path | Type | Description |
|---|---|---|---|
|
Stamped image
|
result | byte |
Stamped image |
|
Printed Tags
|
printedTags | array of string |
Printed Tags |
resp-200-pdf-stamp-text
| Name | Path | Type | Description |
|---|---|---|---|
|
PDF-file
|
result | byte |
PDf-file with stamped text |
resp-200-pdf-stamp-image
| Name | Path | Type | Description |
|---|---|---|---|
|
PDF-file
|
result | byte |
PDf-file with stamped image |
resp-200-pdf-create-by-url
| Name | Path | Type | Description |
|---|---|---|---|
|
PDF-file
|
result | byte |
Created PDF-file |
resp-200-pdf-create-by-html
| Name | Path | Type | Description |
|---|---|---|---|
|
PDF-file
|
result | byte |
Created PDF-file |
resp-200-pdf-get-form-data
| Name | Path | Type | Description |
|---|---|---|---|
|
Form Data
|
result | object |
A JSON object. The properties of the JSON object references the name of the field of the form in the PDF |
resp-200-excel-sheet-add-rows
| Name | Path | Type | Description |
|---|---|---|---|
|
Excel-sheet
|
result | byte |
Excel-sheet with added rows |
resp-200-pdf-fill-form
| Name | Path | Type | Description |
|---|---|---|---|
|
PDF-file
|
result | byte |
PDF-file with filled form |
resp-200-pdf-merge-simple
| Name | Path | Type | Description |
|---|---|---|---|
|
PDF-file
|
result | byte |
PDF-file from merged PDF-files |