Export RITM with variables

[Snow Developer4]

Hello All,

I want to export 500 latest requests for a specific catalog item into a excel with RITM fields and 100 Variables in it. I tried doing so by creating a report but I think there is a limitation of variables which can be added to reports and getting an error for that. I have almost 100 of variables on the catalog item.

Can anyone suggest how to achieve this?

Thanks in advance!

[Maik Skoddow]

Hi @Snow Developer 

did you really read my first answer? I will repeat it for you:

To my mind, the only solution is to implement a custom exporter via Scripted REST API. Why that way? The reason is, that it is not possible anymore to create processors and a Scripted REST API offers the possibility to set a custom "content-type" header.

Please read the following article which explains the approach and all the pitfalls: https://snprotips.com/blog/2022/2/7/how-to-return-a-csv-file-from-a-servicenow-scripted-rest-api

Kind regards
Maik

[Snow Developer4 · Accepted solution]

Ended up creating a report with 25 variables at a time and exported it to excel. Changed variables in each go and at last merged all 4 excel into one to get all 100 variables in one sheet.

Dind't wanted to put much effort since this was the only one time stuff.