Sparse Power Box Tools (Preview)

  • Reference

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/
Email 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:

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:

  1. In Power Automate, search for the "Sparse Power Box" connector.
  2. Enter name for connection
  3. 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

Operation ID:
image-stamp-exif

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

Body
resp-200-image-stamp-exif

Add image stamp to PDF

Operation ID:
pdf-stamp-image

Add custom stamps to your PDF files.

Parameters

Name Key Required Type Description
PDF
 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

Body
resp-200-pdf-stamp-image

Add rows to Excel

Operation ID:
excel-sheet-add-rows

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

Body
resp-200-excel-sheet-add-rows

Add text stamp to image

Operation ID:
image-stamp-text

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

Body
resp-200-image-stamp-text

Add text stamp to PDF

Operation ID:
pdf-stamp-text

Add a text as a stamp to a PDF file.

Parameters

Name Key Required Type Description
PDF
 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

Body
resp-200-pdf-stamp-text

Convert CSV to JSON

Operation ID:
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

Operation ID:
pdf-create-by-html

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

Body
resp-200-pdf-create-by-html

Convert URL to PDF

Operation ID:
pdf-create-by-url

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

Body
resp-200-pdf-create-by-url

Fill a PDF form

Operation ID:
pdf-fill-form

Populates the PDF Form provided with the JSON form data provided.

Parameters

Name Key Required Type Description
PDF-file
 pdf 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

Body
resp-200-pdf-fill-form

Get PDF form data

Operation ID:
pdf-get-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
 pdf byte

PDF-file with form

Returns

Body
resp-200-pdf-get-form-data

Merge a set of PDF files to one PDF (Simple)

Operation ID:
pdf-merge-simple

Merge multiple pdf files

Parameters

Name Key Required Type Description
PDF-file
 pdfs array of byte

PDF-file

Returns

Body
resp-200-pdf-merge-simple

Merge images

Operation ID:
image-merge-drawing

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

Body
resp-200-image-merge-drawing

Resize Image

Operation ID:
image-resize

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

Body
resp-200-image-resize

Slit PDF

Operation ID:
pdf-split-by-page

Easily split a PDF file into multiple PDF files.

Parameters

Name Key Required Type Description
PDF-file
 pdf byte

PDF-file
Number of Pages
 numberOfPages number

Splits PDF documents by the number of pages specified.

Returns

Body
resp-200-pdf-split-by-page

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