Is there a way to link data to Excel only for information in specific tables?

miyu
Tera Guru

‎05-30-2023 12:56 AM

I would like to automatically link data from a specific table in ServiceNow to Excel.
Specifically, I would like to do the following
(1) Display all record information of ABC table [u_abc] in Excel
(2) Modify record information of ABC table [u_abc] in Excel
(3) Reflect the modification of (2) in ABC table [u_abc] in ServiceNow

I do not want to use the Export function in ServiceNow.
Also, I think it is possible to link data to Excel by using the ODBC driver, but I don't think it is possible to limit it to "only certain tables".
For example, I think that if we set it up, tables other than the ABC [u_abc] table (e.g., the EFG [u_efg] table, etc.) will also be linked to Excel.

Is there any way to achieve the above?

0 Helpfuls
  • 1,728 Views
1 REPLY 1

Ratnakar7
Mega Sage
Mega Sage

‎05-31-2023 03:56 AM

Hi @miyu ,

 

You can follow these steps:

  1. Open Excel and go to the "Data" tab.
  2. Click on "Data > Get & Transform > From Web".
  3. In the "From Web" dialog box, enter the URL of the ServiceNow instance followed by the API endpoint for the specific table you want to retrieve data from. For example, if your ServiceNow instance URL is "https://instance.service-now.com" and the table you want to retrieve data from is "u_abc", the URL would be "https://instance.service-now.com/api/now/table/u_abc".
  4. Click "OK" to connect to the specified URL.
  5. If prompted, enter your ServiceNow credentials to authenticate the connection.
  6. Excel will fetch the data from the specified ServiceNow table and display a preview.
  7. Select the desired data elements and click "Load" to import the data into Excel.
  8. Once the data is imported, you can work with it in Excel, including modifying records.
  9. To reflect the modifications back to ServiceNow, you would need to use the ServiceNow API and perform the necessary update operations.

Also, refer Import data from the web 

 

If my response was helpful in resolving the issue, please consider accepting it as a solution by clicking on the ✅Accept solution button and giving it a thumbs up 👍. This will benefit others who may have a similar question in the future.

 

Thank you!

Ratnakar

0 Helpfuls