APIs to fetch the dependencies on columns within a table

MohanM55255301
Giga Contributor

In the Incident table, the 'subcategory' column depends on the 'category' column. I would like to obtain the dependency information along with the list values using an API call. The API call below is intended to return the column names 'category' and 'subcategory', along with their list values and dependent values. However, it is missing the "dependent on field".

https://<instanceid>.service-now.com/api/now/table/sys_choice?sysparm_query=name=incident^element=category^ORname=incident^element=subcategory&sysparm_fields=name,element,label,value,dependent_value

In my example, I used 'category' and 'subcategory' (please see the screenshot), but there are other columns that depend on each other that I want to retrieve using an API call. I am open to making multiple API calls if necessary. Could you please share API queries to fetch this kind of dependency information between columns within a table?

0 REPLIES 0