Excel Rest API templates

[VL10]

Hi,

I'd like to extract some data to Excel, like for my CMDB Application list, to make it easier for people to access.   I don't want to reinvent the wheel, is there anywhere I can obtain some templates from that I can extend?

Rest API Explorer doesn't generate VBA code otherwise I could have used that.

[Roger Poore]

So you want to write some code inside of Excel to get data from ServiceNow?  Just wondering what the need for VBA is.  Rest API Explorer has a template for PowerShell and you can interact with Excel over COM with PowerShell.  

Another approach might be to use the ServiceNow ODBC driver and access ServiceNow data through Excel that way.  Seems doable.  No promises.

[Amit Verma]

Hi @VL10 

Do you want to extract data from ServiceNow tables in an excel file ? If yes, you can make use of Export functionality being offered OOB from ServiceNow. Please refer below snip :

Thanks & Regards

Amit Verma