Paymo Tables
The provider models the data in API as a list of tables in a relational database that can be queried using standard SQL statements.
Paymo Tables
| Name | Description |
| ClientContacts | Returns client contacts for the account. |
| Clients | Returns clients for the account. |
| ClientTimeEntries | Returns timesheet entries for a given client. |
| CommentFiles | Returns files attached to a given comment. |
| Comments | Returns comments for a specific thread. |
| Company | Returns company info. |
| DiscussionFiles | Returns files attached to a given discussion. |
| Discussions | Returns discussions. |
| DiscussionThreads | Returns comment threads for given discussion. |
| Estimates | Returns estimates. |
| EstimateTemplates | Returns estimate templates. |
| EstimateTemplatesGallery | Returns all available templates in the Paymo library. |
| Expenses | Returns expenses. |
| FileThreads | Returns comment threads for given file. |
| InvoicePayments | Returns invoice payments. |
| Invoices | Returns invoices. |
| InvoiceTemplates | Returns invoice templates. |
| InvoiceTemplatesGallery | Returns a list of all available templates in the Paymo library. |
| Milestones | Returns milestones. |
| ProjectBookings | Returns bookings for a giver Project. |
| ProjectFiles | Returns files from a given project. |
| Projects | Returns projects. |
| ProjectStatuses | Returns project statuses. |
| ProjectTemplates | Returns project templates. |
| ProjectThreads | Returns comment threads for given project. |
| ProjectTimeEntries | Returns timesheet entries for a given project. |
| Reports | Returns reports. |
| Sessions | Returns sessions |
| Subtasks | Returns subtasks for a given task. |
| TaskBookings | Returns bookings for a giver task. |
| TaskFiles | Returns files attached to a given task. |
| Tasklists | Returns task lists |
| TaskRecurringProfiles | Returns task recurring profiles. |
| Tasks | Returns tasks. |
| TaskTaskAssignments | Returns task assignments for a given task. |
| TaskThreads | Returns comment threads for given task. |
| TaskTimeEntries | Returns timesheet entries for a given task. |
| UserBookings | Returns bookings for a giver User. |
| Users | Returns users for the account. |
| UserTaskAssignments | Returns task assignments for a given user. |
| UserTaskBookings | Returns bookings for a giver UserTaskId. |
| UserTimeEntries | Returns timesheet entries for a given user. |
| Workflows | Returns workflows. |
| WorkflowStatuses | Returns workflow statuses. |