- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-03-2019 11:14 AM
Hello all,
I have a requirement to bring in all ServiceNow Security Incident Records and any available fields that could be selected into Microsoft Power BI. This is really no different that Excel Power Query but I'm running into issues and getting a JSON error (possibly because I'm unsure of params). What endpoint should I use and what params to show all security incidents and related metrics (all records, no limit) but ensure they are structured so that they can be parsed/mapped?
I tried https://(instance name).service-now.com/api/now/table/sn_si_incident and data was displayed, however I received the following:
This page contains the following errors:
Below is a rendering of the page up to the first error.
I read something about this a few days ago, but doesn't seem to work for me here. I'm not really interested in exploring the params in detail because I can get PowerBI to clean all that up. I just need to return all SI records ever created, preferably at a start point like (01JAN2019) and ensure any fields that were selected/used/manadatory are there in the data set. How do I get this to work without errors?
Am I supposed to use this and if so, why does this not return data?
https://<instance-name>.service-now.com/api/now/table/sn_si_security_incident_view
Thank you!
Brian
Solved! Go to Solution.
- Labels:
-
Security Incident Response
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-05-2019 09:51 AM
Hey there,
Encoded queries are more intricate but can be helpful for more complex requests - this example may be helpful:
Alex
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-05-2019 09:51 AM
Hey there,
Encoded queries are more intricate but can be helpful for more complex requests - this example may be helpful:
Alex

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-08-2019 10:29 AM
I will close this thread as "answered".
R34rvi3w, let us know if you need more.
Cheers.