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.
The 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, 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 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 is 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:
oConversations and Integrations objects support only insert operation.
oFiles object supports only the update operation.
oForms and Organizations objects don't support the delete operation.
oViews object supports only insert and delete operations.


Podio Connections

When creating a Podio connection you simply log in with Podio, and 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:

1.Open the Connections page by clicking Connections in the menu on the left side of the page.
2.Сlick the New button.
3.In the opened pane click Podio.
4.In the opened New Connection dialog box, specify a connection Name that will be used to identify the connection.
5.Click Log In with Podio.
6.Enter your Podio credentials and click Sign in.
7.Podio will display the list of privileges, required for Skyvia. Scroll the page to the bottom and click Authorize.
8.Wait until the necessary data are transmitted, and then Save the connection.