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.
To establish a connection to Paymo, you must specify the API Key.
To obtain the API Key, you have to log in to Paymo and perform the following actions:
- Click the user icon in the bottom left corner of the page and select My settings.
Select API Keys and click + Generate New Key.
Name the new API Key and click Generate.
- 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.
Paste the obtained value into the API Key box in Skyvia.
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”.
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.
To successfully insert records to this object, you must map either ProjectId or TasklistId.
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
|INSERT, UPDATE, DELETE||ClientContacts, Clients, Discussions, Estimates, EstimateTemplates, Expenses, InvoicePayments, Invoices, InvoiceTemplates, Milestones, Projects, ProjectTemplates, Reports, TaskLists, Tasks, TimeEntries, Users, Workflows, WorkflowStatuses|
Skyvia supports all the common actions for Paymo.