Table API to get data from /table/definition_instance

[tableauwdc]

Hi, I'm using the Table API to get data from /table/definition_instance, it's working fine but the field "business duration" has no values in any row.

If I check the data in the Service Now application I can see the values.

Any idea? can I check anything else?

Thanks,

Guillermo

[drjohnchun]

Can you do this to see what may be going on behind the scenes?

1. Set a filter value for both Business Duration and Duration; any condition will do - all we're trying to do is to get the actual field names and table name.
2. After running #1, Right-Click on the breadcrumb (which now shows the filter conditions from #1) and click on "Copy URL"
3. Post the URL here.

Then we'll see what's really going on here.

[tableauwdc]

This is for Incidents lists

https://dev24473.service-now.com/incident_list.do?sysparm_query=business_duration%3Ejavascript%3Ags....

And this is for Metric Instances list

https://dev24473.service-now.com/metric_instance_list.do?sysparm_query=business_duration%3Ejavascrip...

I think the API is working fine, because I have the same data as in the UI, but I don't know how populate the "Business duration" field in Metric Instance table.

[tableauwdc]

Nevermind!!

I found how set the values for Business duration in the metric instance, it's not the same that in the Incident.

Thanks a lot for your time drjohnchun

[drjohnchun · Accepted solution]

Yes, now it makes sense that we've been dealing with two separate tables and the Business Duration field in the Metrics table was never populated.

Would you mark replies as Answer / Helpful as appropriate. Thanks.