Export variables from a request item with export definitions

[KB15]

I'm currently looking for a solution that would allow for exporting of variables from a request item. We're currently on Helsinki and I saw that there's a relatively new feature called Export sets. I've tried to create an export definition from the requested item table however the ability to export variables isn't functioning. I can select variables but it doesn't give me the option to select the columns I need as you would in a standard report. Selecting just the variables option (if it appears) disappears after saving it or previewing it.

I'm looking at this solution because the data has to go to an FTP site, unless there's a way to do it from a scheduled report.

[samiul1]

Hi kkim,

I had the almost same requirement, managed to get the variables by attaching them on the tickets via workflow.

I followed this article : Attach variable inputs to a file and then attach the file to change   as my reference.

Please have a go and advise further.

Regards,

Samiul

[KB15]

Similar however I don't think there's a provision to send this to an external location which is a requirement. I'll look through it again to see if there's anything I can use.

Thanks!

[KB15 · Accepted solution]

I've contacted ServiceNow about this and the export set only supports the export of whole tables and not its relationships to others. Variables are not included in this export method either unlike a standard report.

So, would it make sense to export the contents of a request item into a separate table and then export that via export set? If it is, would the action of copying the data to the new table require scripting or is there something simpler that could accomplish this?

The goal here is to export the variables selected by a user and have that data sent to an external FTP site to be processed. Ultimately updated data would be fed back into SN via scheduled import to process a service catalog item's workflow automatically.

(Update: The approach taken is to create another table when you can dump all the results out of what you're trying to capture and have that exported out using export sets.)

[jmoore]

Hi,

Do you dump the records to the newly created table each time the export is scheduled to run? Or as a pre-export script for example? I am trying to accomplish the same thing, and am wondering if you can provide some detail on the approach you took.

(Update: The approach taken is to create another table when you can dump all the results out of what you're trying to capture and have that exported out using export sets.)

Any help would be greatly appreciated.

Thanks!
Jessica