API Data Provider - Online Help
Paymo Profile
Connecting to Paymo
Using the Profile
ADO.NET
JDBC
ODBC
PowerBI
SSIS
Excel
SQL Compliance
SELECT Statements
SQL Functions
String Functions
Date Functions
Math Functions
EXECUTE Statements
Schema Discovery
ADO.NET
JDBC
System Tables
sys_tables
sys_tablecolumns
sys_procedures
Tables
ClientContacts
Clients
ClientTimeEntries
CommentFiles
Comments
Company
DiscussionFiles
Discussions
DiscussionThreads
Estimates
EstimateTemplates
EstimateTemplatesGallery
Expenses
FileThreads
InvoicePayments
Invoices
InvoiceTemplates
InvoiceTemplatesGallery
Milestones
ProjectBookings
ProjectFiles
Projects
ProjectStatuses
ProjectTemplates
ProjectThreads
ProjectTimeEntries
Reports
Sessions
Subtasks
TaskBookings
TaskFiles
Tasklists
TaskRecurringProfiles
Tasks
TaskTaskAssignments
TaskThreads
TaskTimeEntries
UserBookings
Users
UserTaskAssignments
UserTaskBookings
UserTimeEntries
Workflows
WorkflowStatuses
Paymo Stored Procedures