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]

I retrieve rows asking for "duration" but not for "business_duration", in the ServiceNow UI I can see values in both fields.

Are they giving the same values? If duration is giving the same value as business_duration, then using duration may solve the issue.

Also, in the UI where you see business_duration, are you actually seeing the field name or the label "Business Duration"? Can you post a screenshot?

[Michael Ritchie]

I believe he is referring to the "metric_instance" table and not definition_instance as that table doesn't exist out of the box.   There is a business duration field on the metric_instance table but in my demo instance that field has no values but duration does.

[tableauwdc]

Yes, I mean "metric_instance"

[drjohnchun]

Thanks michael.ritchie for clarification.

[tableauwdc]

No they have different values.

I see the lable "Business Duration", of the Incidents, I'm wondering, is the same field that I see in the incident table, what I should see in the metric_instance table?