Related Task Details in Table API

[Vijay151]

Hi,

Good day! By using https://docs.servicenow.com/bundle/geneva-servicenow-platform/page/integrate/inbound_rest/reference/... Table API, we need to get the table data. It works well when we try like that https://dev71739.service-now.com/api/now/table/incident?number=INC0009009 (Method GET), but it does not return the details of the related task. How can we get the details of the related tasks by using table API? Thanks!

[Ankur Bawiskar]

Hi Vijay,

the data for the related tasks should be on incident_task table; I think you are checking for this table; if yes then you can use Table API on that incident_task table and use this query

https://dev71739.service-now.com/api/now/table/incident_task?sysparm_query=parent.number=INC0000001

Mark ✅ Correct if this solves your issue and also mark 👍 Helpful if you find my response worthy based on the impact.
Thanks
Ankur

[Vijay151]

Ankur, thanks for your reply

My Actual requirement is,

This is my account page,

WWhen I execute https://dev71739.service-now.com/api/now/table/customer_account?number=ACCT0010001, it throw response like below

We need the account team members (related data) details in the response. How can we make a URL to get the related tasks details also when we call the table API? Please suggest me

[Ashutosh Munot1]

Hi,

If you only want one URL and you want data for both parent ticket and task to it then go for scripted rest api.

If you really dont have that requirement then use two seperate API one for parent and one for task.

Thanks,

Ashutosh

[Vijay151]

Okay, so we do not have the table API to get the both the parent and related tasks details in single table API call. Am I right?