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 

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]

Thanks for your response Maik,

I was able to export around 25 variables from report but if I add variables more than that it shows an error

Is there any property or a script where the limitation is configured? I can modify that temporarily and revert once I'm done with the report since this is only once time report.

Thanks in advance!

[Maik Skoddow]

Hi @Snow Developer 

I cannot answer as only providing an error message is not enough to understand where you are stuck and what your coding approach is.

Therefore please provide all details to get an idea of your issue.

Kind regards
Maik

[Snow Developer4]

It's a report on sc_req_item table where I added variables in the list using choose column, till 25 variables it's all good but if I add variables more than 25 it shows an error. Please find the screenshot below for reference: