API Data Provider - Online Help
JobcanExpenses Profile
Connecting to JobcanExpenses
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
Companies
Forms
GenericMasteItems
GenericMasters
Groups
Positions
Projects
RequestApprovalProcessSteps
RequestCustomizedItems
RequestDetails
RequestModifyLogs
Requests
Users
Projects
Generated schema file.
Columns
Name
Type
References
ProjectCode
String
ProjectName
String