Podio
Podio is a cloud collaboration service for organizing team communication, automating workflows, task management, etc.
Data integration: Skyvia supports importing data to and from Podio, exporting Podio data to CSV files, and replicating Podio data to relational databases.
Backup: Skyvia Backup supports Podio backup.
Query: Skyvia Query supports Podio.
Podio-Specific Features and Limitations
Skyvia has the following limitations for Podio:
-
Skyvia splits the OwnShares object into two objects AppStore_AppOwnShares and AppStore_PackOwnShares for records of type “app” and “pack” respectively.
-
Items object has a required field “fields”, which stores information in the JSON format. This format depends on the type of the application, the item is related to. So when loading data to the Items object, you must provide JSON values for this field, which is valid for the corresponding application types.
-
Podio does not return any information about record deletion success and record update success for most objects. Thus, when Skyvia deletes records or updates records in some objects, these records are displayed as failed, even though they are successfully updated or deleted. Deleted records are always displayed as failed, and updated records are displayed as failed for the following objects: Applications, Files, Organizations, Spaces.
-
Skyvia does not support the following Podio objects: Comments, Flows, Hooks, Ratings, Recurrence, Grants.
-
Synchronization is not supported for Podio.
-
Skyvia Backup is very limited in restoring Podio data. When querying data via Podio API, for many objects Podio returns not all the data that are required for inserting a corresponding record to Podio, or Podio requires data for the record in different format than it returns. So, for most of the Podio objects Skyvia cannot directly restore backed up records.
-
Podio API allows querying tasks only filtered by an Id of the task or of a related object, like organization, workspace, application, or a user that created, completed, or is responsible for the task. When reading Podio tasks, Skyvia queries them by their parent organizations. This means that tasks, not attached to any workspace or item are read by Skyvia only when querying a task by its id. They are not read in all other cases.
-
Not all Podio objects support all the DML operations:
- Conversations and Integrations objects support only insert operation.
- Files object supports only the update operation.
- Forms and Organizations objects do not support the delete operation.
- Views object supports only insert and delete operations.
Podio Connections
When creating a Podio connection, you simply log in with Podio. The OAuth authentication token is stored on the Skyvia server. Your Podio account login and password are not stored on the Skyvia server.
To create a Podio connection, perform the following steps:
- Click +NEW in the top menu.
- Open the Select Connector page by clicking Connection in the menu on the left.
- In the opened pane, click Podio.
-
In the Connection Editor page, specify a connection name that will be used to identify the connection.
- Click Sign In with Podio.
-
Enter your Podio credentials and click Sign in.
-
Podio will display the list of privileges required for Skyvia. Scroll the page to the bottom and click Grant access.
- Optionally, you can select the Suppress Extended Requests checkbox to reduce the number of API calls. However, beforehand read more about this option below.
- When everything is ready, use the Test Connection button to make sure that the connection is successful and then click Create Connection.
Suppressing Extended Requests
For some objects, Podio API returns only part of the fields when querying multiple records. In order to query values of additional fields, Skyvia performs additional extended requests. Such API requests can be performed for each record of such object. However, this can decrease performance and significantly increase the number of API calls used.
To reduce the number of API calls, you can select the Suppress Extended Requests checkbox. However, please note that some of the fields in such objects will not be available in Skyvia (will return empty values) even if they have values in Podio because Podio API does not return them without extended requests.
Supported Actions and Actions Specifics
Podio connector supports the following actions:
- Execute Command in Source, Lookup, and Target Data Flow components and in Import and Export tasks in the Advanced mode.
-
Execute Query in Source Data Flow components and in Import and Export tasks in the Advanced mode.
- Lookup in Lookup Data Flow components.
- Insert in Target Data Flow components.
- Update in Target Data Flow components.
- Delete in Target Data Flow components.