Delen via


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

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
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
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

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
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

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
pdf 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
pdf 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