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.
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/.
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.
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.
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.
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
https://support.zippydoc.de/en/faqs/
The connector supports the following authentication types:
Default | Parameters for creating connection. | All regions | Not shareable |
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 |
Name | Calls | Renewal Period |
---|---|---|
API calls per connection | 100 | 60 seconds |
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 |
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. |
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 |
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 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
On table changed |
Triggers flow when any table is modified. |
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 |
This is the basic data type 'integer'.