API schema / relationship diagram?

[thedavegray]

Hi all, 

Can anyone please point me in the right direction for some kind of relationship diagram for the various endpoints/tables in the ServiceNow API? 

In particular I am looking for how I can join the data from the various Incident tables, for example one Incident will have many tasks and notes.  I have created an incident and added multiple notes, however looking down the json returned using Postman I cannot see an key field I could use to link the [Incident] to the [IncidentTask]

Also, am I missing a description of what the endpoints are for?  The API Explorer page does not really explain the purpose of these. 

Thanks 

[JP - Kyndryl · Accepted solution]

Hi Dave,

Go into Tables,  select the Incident table  and pick the Schema Map menu option:

Hopefully, you will find what you need there.

[thedavegray · Accepted solution]

Hi, 

When you say "go into tables", where do you mean?  This is what I'm seeing in the API Explorer page. 

Thanks 

[JP - Kyndryl · Accepted solution]

Hi Dave,

Go into Tables,  select the Incident table  and pick the Schema Map menu option:

Hopefully, you will find what you need there.

[thedavegray · Accepted solution]

Hi, 

When you say "go into tables", where do you mean?  This is what I'm seeing in the API Explorer page. 

Thanks 

[JP - Kyndryl · Accepted solution]

Hi Dave,

System Definition > Tables    in the ServiceNow navigator  (Admin role):

[thedavegray]

Thanks @JP - Kyndryl  

My exposure to ServiceNow has been responding to incidents up to now.  But as I'm working on consuming the API into SQL tables I have admin rights to our DEV instance - now realising  there's quite a lot to ServiceNow. 😀

Regards

Dave