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