Paymo

Paymo is a comprehensive platform for project management, tracking time, and billing.

Data integration: Skyvia supports importing data to and from Paymo, exporting Paymo data to CSV files, and replicating Paymo data to relational databases.

Backup: Skyvia Backup does not support Paymo backup.

Query: Skyvia Query supports Paymo.

Establishing Connection

To establish a connection to Paymo, you must specify the API Key.

Getting Credentials

To obtain the API Key, you have to log in to Paymo and perform the following actions:

  1. Click the user icon in the bottom left corner of the page and select My settings.

  2. Select API Keys and click + Generate New Key.

    api-settings

  3. Name the new API Key and click Generate.

    generate key

  4. Copy the newly generated API Key.

The API is visible only once when you generate it. You won’t be able to view it again.

api-key

Creating Connection

Paste the obtained value into the API Key box in Skyvia.

paymo connection

Connector Specifics

Object Peculiarities

Invoices and Estimates

The Discount field only accepts values greater than ‘0’ when inserting or updating. If you try to Insert the ‘0’ value to the Discount field, you get the error “Field ‘discount’ cannot be empty”.

TimeEntries

With the required TaskId field, you must also map one of the field pairs: the Date and Duration or the StartTime and EndTime when inserting records to this object.

Tasks

To successfully insert records to this object, you must map either ProjectId or TasklistId.

Reports

When selecting data from the Reports object, the Clients and Users fields may return the string values (for example, all_archived, all_active or all) or an array of existing customers or users Ids (for example [“286959”,”287126”]).

To successfully insert or update the records into this object, you have to map the Clients and Users fields to the existing Ids of the customers or users in the following format: 286959,287126 (no quotes, no square brackets).

Incremental Replication and Synchronization support

All Paymo objects support Incremental Replication.

The objects Company, EstimateLineItems, InvoiceLineItems, ProjectStatuses, DiscussionComments, and TaskComments do not support Synchronization.

DML Operations Supports

Operation Object
INSERT, UPDATE, DELETE ClientContacts, Clients, Discussions, Estimates, EstimateTemplates, Expenses, InvoicePayments, Invoices, InvoiceTemplates, Milestones, Projects, ProjectTemplates, Reports, TaskLists, Tasks, TimeEntries, Users, Workflows, WorkflowStatuses
UPDATE, DELETE ProjectStatuses
UPDATE Company

Supported Actions

Skyvia supports all the common actions for Paymo.

On This Page