How to include Catalog Variables when exporting RITM/SC Task records to Excel or CSV?

[aparnaravi]

Hi Team,

We have a requirement to include Catalog Variables when exporting RITM (sc_req_item) and SC Task (sc_task) records.

Currently, when we use the standard Export option (Excel/CSV) from either the list view or a single record, only the table fields are exported. The catalog variables are not included, as they are stored separately.

Our requirement is:

• Export should include both the standard table fields (e.g., Number, State, Requested For, Opened By, etc.) and the catalog variables as additional columns.

• Ideally, this should work when exporting a single RITM from the form as well as from the list view.

I understand that one approach is to build a custom "Export with Variables" solution using a UI Action and server-side script.

I have a few questions:

1. Has anyone implemented a similar solution?

2. What is the recommended approach to generate an Excel/CSV that includes both table fields and catalog variables?

3. Is there any out-of-the-box functionality or existing API that supports exporting catalog variables along with the record details?

4. If a custom solution is required, what would be the best practice for generating the export file?

Any suggestions, sample implementations, or best practices would be greatly appreciated.

Thank you

[Dr Atul G- LNG]

Hi  

You can create a report using a variable. and download in excel.

https://www.servicenow.com/docs/r/yokohama/now-intelligence/reporting/rep-service-catalog-variables....

https://www.servicenow.com/docs/r/yokohama/now-intelligence/reporting/use-service-catalog-variables-...

[aparnaravi]

Thank you for your response.

I also tried exporting an individual RITM and SCTASK record to PDF using the standard Export → PDF option. However, I noticed that the catalog variables are not included in the generated PDF either.

It seems that the standard PDF export only captures the table fields and not the associated catalog variables. Could you please confirm if this is the expected behavior? If so, is there any out-of-the-box way to include catalog variables in the exported PDF, or would a custom solution be required

[Ankur Bawiskar]

@aparnaravi 

there is no out of the box way to include them in list view in native

But here are some links which uses workaround and then you can export them from list itself

Article #19 - How to show Catalog Variables on RIT... - ServiceNow Community

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏

[aparnaravi]

Thank you for your response.

I also tried exporting an individual RITM and SCTASK record to PDF using the standard Export → PDF option. However, I noticed that the catalog variables are not included in the generated PDF either.

It seems that the standard PDF export only captures the table fields and not the associated catalog variables. Could you please confirm if this is the expected behavior? If so, is there any out-of-the-box way to include catalog variables in the exported PDF, or would a custom solution be required?