ZIPPYDOC (Preview)

This connector allows you to run preconfigured data transformations on the ZIPPYDOC business automation platform. You can either select a third-party data transformer and have it transform your data, or alternatively you can create your own data transformer on the ZIPPYDOC platform. ZIPPYDOC and its community offers a wide range of pre-built transformations for tables, text and code.

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 ZIPPYDOC support
URL https://support.zippydoc.de
Email support@zippydoc.eu
Connector Metadata
Publisher ZippyDoc GmbH
Website https://zippydoc.de/
Privacy policy https://zippydoc.de/datenschutzrichtlinie/
Categories Data;Website

The value this connector offers to its users is to transform large datasets, especially lists, tables, code or text files easily. It allows users to share data and transformations with others and enrich the users data with metadata. The connector supports to pass data from/to the ZIPPYDOC business automation platform and to connect to Excel via its Add-In for Excel.

Prerequisites

To use this connector, the user must register with ZIPPYDOC under https://zippydoc.de/en/register/ or login to ZIPPYDOC via the users Microsoft Account. For continuous use, the user needs to a buy a license as outlined in https://zippydoc.de/en/tariffs/.

How to get credentials

ZIPPYDOC connector uses API key authentication. To get API key you'll need to go select "User Info/Get Power Automate Key" menu within the ZIPPYDOC App, after that the key will be copied to your clipboard.

Get started with your connector

After having established a connection between Power Automate and ZIPPYDOC (see FAQ Power Automate (https://support.zippydoc.de/en/faqs/) - How to get credentials), you can start creating your integrated data flow. Find below examples of getting started. A) Post a message on change of a ZIPPYDOC Table Step 1: Add a tag to the ZIPPDOC table called "power-automate" Step 2-4: Setup a Power-Automate Flow Step 2: Select ZIPPYDOC Trigger ON_TABLE_CHANGE trigger in Power Automate Step 3: Select ZIPPYDOC Action GET TABLE BY NAME or GET TABLE BY ID in Power Automate Step 4: Select the BODY of above selected Table to post it e.g. to a TEAMS channel.

B) Run a ZIPPYDOC Transformer on a Table Step 1: Select a Table within you Power Automate Flow Step 2: Upload the selected table into a ZIPPYDOC Flow by Selecting UPLOAD TABLE Step 3: Run the ZIPPYDOC Transformer by Selecting EXECUTE and specifying your ZIPPYDOC flow name Step 4: Get the resulting table by Selecting GET TABLE BY NAME Step 5: Use the transformed table in your Power Automate flow, e.g. to post it into an E-MAIL.

Known issues and limitations

The ZIPPYDOC service is not designed for high trigger frequencies. Please configure your connections with a trigger frequency of not more than 1 time in 20 seconds.

Common errors and remedies

In case not enough rescource usage points are available, the ZIPPYDOC service will return a PAYMENT_REQUIRED error. To overcome this issue, the user is required to either buy additional points https://zippydoc.de/en/pricing/ or to opt for a pay as you go payment model. The on table changed trigger is only executed, if the ZIPPYDOC notification table is tagged with the tag: power-automate

FAQ

https://support.zippydoc.de/en/faqs/

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 The API Key for this api True

Throttling Limits

Name Calls Renewal Period
API calls per connection 100 60 seconds

Actions

Execute

Executes all tasks in defined flow.

Get Table By ID

Retrieves table content in JSON format

Get Table By Name

Retrieves table content in JSON format

Upload Table

Upload table in JSON format to ZIPPYDOC system

Execute

Executes all tasks in defined flow.

Parameters

Name Key Required Type Description
Name of the flow that should execute all of its tasks.
name True string

Name of the flow that should execute all of its tasks.

Get Table By ID

Retrieves table content in JSON format

Parameters

Name Key Required Type Description
ID of the table
tableId True integer

ID of the table in ZIPPYDOC system

Returns

Name Path Type Description
array of

Get Table By Name

Retrieves table content in JSON format

Parameters

Name Key Required Type Description
Name of the table
name True string

Name of the table in ZIPPYDOC system

Returns

Name Path Type Description
array of

Upload Table

Upload table in JSON format to ZIPPYDOC system

Parameters

Name Key Required Type Description
Table Name
name string

Table name

Table Content
content array of

Table content

Description
description string

Table description

Flow name
documentName string

Name of the flow to which the table will be added

Replace
replace boolean

Replace table

Table tags
tags array of

Table tags

Returns

response
integer

Triggers

On table changed

Triggers flow when any table is modified.

On table changed

Triggers flow when any table is modified.

Parameters

Name Key Required Type Description
Trigger type
type string

type

Returns

Name Path Type Description
tableId
tableId integer

ID of the table in ZIPPYDOC system

Definitions

integer

This is the basic data type 'integer'.