Getting activity log of specific incident through the REST API
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-14-2017 08:06 AM
I would like to know how to get the activity log of a specific incident through the REST API. I have looked at a similar post in this forums and it didn't help me out. I am using Service NOW Helsinki. Please let me know the table name by which I can get the activity logs of a specific incident.
Thanks in advance,
Swamy
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-14-2017 08:12 AM
The table is sys_history_line.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-14-2017 08:19 AM
Is that table accessible under Helsinki?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-14-2017 08:23 AM
Sure. Just be sure to get your sysparm_query right so you have the 'set' field pulling from the right record or you could get a LOT of information for all records. Take a look at the table and field structure to understand it and ensure you get the information you want.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-16-2017 08:16 PM
I am able to access the table but I cannot understand the information returned from the API. I apologize but I am quite new the Service Now. How do I access the activity log by the incident number? Like you mentioned, how can I access the table and the field structure?
I looked at the DEV instance of the Service Now and I am not able to see the table sys_history_line
