Skip to main content
Docs
Feature Requests Onboarding Trust Center Status Page

Community

Connector Improvement: ServiceTitan - Additional Tables and Columns

Answered
Libby Reynolds User

Operations-related tables listed below in order of priority. Without these, our team cannot provide a full picture of operational performance in reporting.

  1. Job Timesheets (https://developer.servicetitan.io/api-details/#api=tenant-payroll-v2&operation=Timesheets_GetJobTimesheetsByJobs)
  2. Timesheet Codes (https://developer.servicetitan.io/api-details/#api=tenant-payroll-v2&operation=TimesheetCodes_GetList)
  3. Teams (https://developer.servicetitan.io/api-details/#api=tenant-dispatch-v2&operation=Team_GetList)
  4. Form Submissions (https://developer.servicetitan.io/api-details/#api=tenant-forms-v2&operation=FormSubmission_GetFormSubmissions)
  5. Purchase Orders (https://developer.servicetitan.io/api-details/#api=tenant-inventory-v2&operation=PurchaseOrders_GetList)
  6. Call Reasons (https://developer.servicetitan.io/api-details/#api=tenant-jbce-v2&operation=CallReasons_Get)
  7. Job Cancel Reasons (https://developer.servicetitan.io/api-details/#api=tenant-jpm-v2&operation=JobCancelReasons_GetList)
  8. Job Cancel Log (https://developer.servicetitan.io/api-details/#api=tenant-jpm-v2&operation=Jobs_GetJobCanceledLogs)
  9. Payrolls (https://developer.servicetitan.io/api-details/#api=tenant-payroll-v2&operation=Payrolls_GetList)
  10. Payroll Adjustments (https://developer.servicetitan.io/api-details/#api=tenant-payroll-v2&operation=PayrollAdjustments_GetList)
  11. Tag Types (https://developer.servicetitan.io/api-details/#api=tenant-settings-v2&operation=TagTypes_GetList)

Please sign in to leave a comment.

Comments

6 comments

Date Votes
  • Official comment
    Sanjeevv Maniram T Fivetranner

    Hi Libby Reynolds,

    Thank you for sharing your request for additional tables and columns in the ServiceTitan connector. We have added this feature to our backlog, and it will be prioritized based on customer demand. We understand the importance of these tables for your operational reporting and will keep you updated on any progress. 

    Best,  
    Sanjeevv Maniram

  • Chris Penoyer User

    Seconded! Would be very nice to have these tables included in the connector.

  • Chris Sebastian User

    +1! Adding the tables that we currently need (only overlap with OP's request is tag_types)

      • membership_types (/tenant/{tenant}/export/membership-types)
      • recurring_services (/tenant/{tenant}/export/recurring-services)
      • recurring_service_events (/tenant/{tenant}/export/recurring-service-events)
      • recurring_service_types (/tenant/{tenant}/export/recurring-service-types)
      • tag_types (/tenant/{tenant}/export/tag-types)
  • Ant Couzens User

    This is also a requirement for our organisation.  I have had to report back we cannot facilitate business needs due to missing Purchase Orders, and the other tables named here are also crucial for our success.

  • David Burns User
    • Edited

    Jumping onboard here, Utilising Fivetran specifically for the ease of extracting data from ServiceTitan connector but finding nemerous key tables currently missing that are listed in this Feature Request. Of particular interest to us is Timesheets, Payroll and Purchase Orders. I am going to have to build a bespoke solution for these outside of Fivetran unfortunately

  • Paden Mason User

    You have timesheets now but i can't see if an item is paid or not. Need to access Gross pay endpoint to get what we need
    https://developer.servicetitan.io/api-details/#api=tenant-payroll-v2&operation=GrossPayItems_GetList