Connecting to 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 and Replication with Incremental Updates are 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.
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 Log 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.
- Wait until the necessary data are transmitted and then click Create Connection.