Is there is any OOB API to check for the reports and the data

[Santhosh23]

Is there is any OOB API to check for the reports and the data

[Rahul Kumar17]

Hi Santhosh,

Yes, ServiceNow provides a set of REST APIs that can be used to interact with report data. You can use the "sys_report" table to retrieve a list of available reports and their associated data, and the "sys_report_run" table to retrieve data from a specific run of a report.

Here's an example REST API call to retrieve the data from a specific run of a report:

GET /api/now/v1/table/sys_report_run/{sys_id}/result

Replace {sys_id} with the sys_id of the report run you want to retrieve the data from. The response will contain the data in the format specified by the report.

You can find more information about the ServiceNow REST APIs in the official documentation: https://developer.servicenow.com/dev.do#!/reference/api/rome/rest/c_RESTAPIReference.rome.doc/APITab....

Thanks,

Rahul Kumar

[Ankur Bawiskar]

@Santhosh23 

it would be nice if you share your business requirement.

[Santhosh23]

@Ankur Bawiskar we are having one report which will store ritm number and variables. one of third party team going to use that report and the variables stored in the report.

[Ankur Bawiskar]

@Santhosh23 

not possible.

why not create a scripted rest api and ask them to give RITM number

you can give the variable information as API response

If my response helped please mark it correct and close the thread so that it benefits future readers.