Export variables from a request item with export definitions

KB15 · ‎11-17-2016

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.

KB15 · ‎12-28-2016

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.)

View solution in original post

KB15 · ‎01-19-2018

Hi Jessica,

Yes, that's correct. I have a script in a workflow that will copy the variables into a completely separate table to hold the data after every insert. I'm not running a job to accomplish here but I imagine it can be done that way as well.

After that, an export set (running at an interval of 15 minutes) is setup to compare the export's last run vs the record's insert time to determine which ones to send out so it doesn't send out all table data on every run. For example, if the last run was at 12PM, any records after 12PM would be exported.

Let me know if this makes sense.

jmoore · ‎01-19-2018

Thank you for this info!

Community Alums · ‎01-10-2020

Hi,

You can do it by exporting the many to many table: "variable ownership sc_item_option_mtom", so in th fields use the dot walking to select the variables and thier values (question - value), after that use the filter to precise the Item and the variables you want to export.

Lyes

Hope this helps.

kathy_eskandari · ‎01-16-2020

Exactly what I was looking for. Thank you!!

magnuspersson · ‎03-30-2020

Hi.

This is great! Thank you so much for this.

I have tried it and it works perfectly, the only thing I can't figure out is how to handle reference fields. When I try to export a variable collected in a reference field I can only get the sys_id, not the actual display value.

Have you encountered this and if so did you find a workaround?

Kind regards

Magnus