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

Community

Connector Improvement: ServiceNow Columns Addition

Answered
Corey Neilson User

For the ServiceNow connector we need to use some fields that are not available in the FiveTran connector but are available in the ServiceNow table.  These columns are listed below:

pm_project table:
  1. start_date
  2. end_date
  3. status
  4. phase_type
 
pm_project_task table:
  1. start_date
  2. end_date
  3. status

 

Please sign in to leave a comment.

Comments

3 comments

Date Votes
  • Official comment
    Frank Fivetranner

    Hi Corey, 

    Can you check if the fields in the planned_task table can be joined to these tables to get the fields? ServiceNow follows a table hierarchy so certain fields are available only through their parent table.

    Thanks, 

    Frank 

  • Corey Neilson User

    Hey Frank!  It looks like the planned_task table might give us everything we need with the exception of the phase_type column.  Is there another table that we might be able to find that in?

    Where is the documentation that would allow us to see this.  I don't see these tables in the Fivetran ERD documentation that is provided in the UI.  Is there somewhere else to access this?

  • Frank Fivetranner

    Hi Corey, 

    You can use the sys_dictionary provided by ServiceNow to view fields and find their related tables. Hope that helps!

    Frank