Forum Discussion

Ruairi_CloudP's avatar
Ruairi_CloudP
Regular Visitor
3 years ago

ServiceNow API - Pagination

Hello all,    We're currently building Power BI reporting for a client where we are using REST API endpoints to retreive data from their ServiceNow environment to report on.    The APIs in questi...
Need Help
  • Ruairi_CloudP's avatar
    Ruairi_CloudP
    Regular Visitor
    3 years ago

    Hello, 

     

    Thanks for the response, 

     

    We've looked at the articles you've linked and tried using them as a basline to use for our pagination, however we haven't been able to get it to work yet. 

     

    For the first link, we tried using this as a basis however we keep running into an error which is as the following: Web.Contents failed to get contents from "[URL Endpoint]" (406): Not Acceptable
    Details:
    DataSourceKind=Web
    DataSourcePath= "[URL Endpoint]"

    Url = "[URL Endpoint]"

     

    For the second link, we have an issue where the result is returning a blank row of lists like so:

     

    Any help with this? Thanks.

    • ams1's avatar
      ams1
      Responsive Resident
      3 years ago

      Hi Ruairi_CloudP 

       

      Do you still have this problem regarding connecting to service now?

      If yes, maybe I can try to help out - I would at least need from you the link to the service now API endpoint you'd like to use (ideally I would also like to see the query - AFTER you remove confidential information from it).