Connecting to RestAPI from Excel or PowerBI and getting all fields in security incident to display

R34rvi3w
Mega Expert

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:

error on line 6935 at column 2893: Opening and ending tag mismatch: result line 0 and response

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

1 ACCEPTED SOLUTION

Alex Cox
ServiceNow Employee
ServiceNow Employee
6 REPLIES 6

Alex Cox
ServiceNow Employee
ServiceNow Employee

Eric Feron
Moderator
Moderator

I will close this thread as "answered".

R34rvi3w, let us know if you need more.

Cheers.