URI for sys_report_template

[knowledgeenthus]

HI,

i am looking to figure out a URI for a specific corelation id in a report..

I have tried this

https://instance.com/sys_report_remplate.do?CSV&jvar_report_id=sdfdsfdsfdsf&sysparm_query=u_correlation_id%3Esdfsdsdasdasd"

but it looks like sysparm_query does not work in report_template_do.

Is it a different variable i need to use to get it?

In this example i am saying anything greater than (%3E) a specific u_correlation_id

Any thoughts?

[adamjgreenberg]

Umair,

If you're looking to view a report based on the system ID of said report, you are on the right path.

However, the sys_report_template table does not have searchable fields like u_correlation_id (I'm assuming you're looking for all reports that use u_correlation_id)

My guess here without understanding the full scope of what you're trying to accomplish or the instance you're trying to get this info from is that you want to use the following URI

https://instance.service-now.com/sys_report_list.do?sysparm_query=titleSTARTSWITHyourtitlename&syspa...

If that doesn't work for you, feel free to provide more details and I'll do my best to help find you an answer.

[knowledgeenthus]

Hi Adam,

This is just giving me a list of all report names and its info but not the content of the report which is what i am looking for.

I am essentially looking to get a report exported to a csv and i only want to extract records 1 through 500 and then in the second csv i want to extract the next 500 records. This requires me to be able to query using the corelation id or any other field in the report. I am having trouble using sysparm_query to specify a certain column and getting certain values.

Does that help understand the scope?

[adamjgreenberg]

Umair,

If I'm reading your update correctly you want to extract records based on a report name. Is this correct?

Have you read through this? - Export directly from the URL