API Data Provider - Online Help
Tickspot Profile
Connecting to Tickspot
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
Clients
ClosedProjects
ClosedTasks
Entries
ProjectClosedTasks
ProjectEntries
Projects
Roles
TaskEntries
Tasks
UserEntries
Users
Roles
.
Columns
Name
Type
References
SubscriptionId [KEY]
String
Company
String
ApiToken
String