is there any rest api end point to fetch raw reporting data ?

[bipul singh]

I need to fetch raw reporting data through rest api end points . Is there any documentation with details about the response from the end points .

I know table apis are available but there is no detail documentation regarding api response and which specific table to use?

[Olyn Dabbs]

What exactly are you trying to report on?  It's hard to say what endpoints would be useful without knowing what end result you are going for.  The two that come to mind are the Table API and Aggregate API.

Table API: https://developer.servicenow.com/app.do#!/rest_api_doc?v=london&id=c_TableAPI

Aggregate API: https://developer.servicenow.com/app.do#!/rest_api_doc?v=london&id=c_AggregateAPI

[bipul singh]

I am using https://instance.service-now.com/api/now/reporting api endpoint , the response contains a link to an UI . I want to get the data present in the UI .

How can i get the raw data shown in the UI?Is there any specific api end points available?

[SanjivMeher]

The reporting API https://instance.service-now.com/api/now/reporting only gives you the list of reports you have in your servicenow instance

]

 "result": {
    "reports": [
      {
        "url": "/report_viewer.do?jvar_report_id=024825220a0a0b5300e711a1a595d384",
        "id": "024825220a0a0b5300e711a1a595d384",
        "title": " KPI - Average Work Effort for Resolving Incidents by Category",
        "type": "pivot",
        "typeDisplayValue": "Pivot Table",
        "table": "incident_time_worked",
        "tableDisplayValue": "Incident Time Worked",
        "updatedOn": "2018-08-31 14:47:02",
        "editable": true,
        "published": false,
        "valid": true,
        "favorite": false
      },
      {
        "url": "/report_viewer.do?jvar_report_id=6ba85161df23210068c37a0d3df263e2",
        "id": "6ba85161df23210068c37a0d3df263e2",
        "title": "${App_Label} Catalog Usage",
        "type": "donut",
        "typeDisplayValue": "Donut",
        "table": "sm_order",
        "tableDisplayValue": "Service Order",
        "updatedOn": "2014-10-03 16:20:33",
        "editable": true,
        "published": false,
        "valid": true,
        "favorite": false
      },

To get the response of a specific report, you my use the end point as

https://instance.service-now.com/api/now/reporting?sysparm_contains=KPI%20-%20Average%20Work%20Effort%20for%20Resolving%20Incidents%20by%20Category

The the URL should in the response should give you the required data.

[bipul singh]

Ok . 

Is there any other api end points from where I can fetch data of my reports ?