How can I export the catalog item variables
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-14-2017 02:17 AM
Hello,
When I created a request from the service portal, the request is saved in the "Requested Item" table and i display the variables entered like below:
How can i export all this variables to external systems ?
I use "System Export Set" module :
But, i can't find the variables when i defined the export using "Requested Item" table ?
Would you have an idea how to export these variables ? using mid-server or other ?
Thanks for your help
Regards
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-07-2025 06:48 AM
Hello,
It appears that the current setup does not allow Export Set functionality to dot-walk to the tables where catalog item variables are stored—specifically, sc_item_option and sc_item_option_mtom. While it's possible to run exports directly on these tables, the results often include sys_id values instead of the actual variable names or values, which can be difficult to interpret.
As a workaround, we created a custom table and used a script to extract and store the relevant request data in a readable format. This allows the export to pull clean data from the custom table. Alternatively, you could use Flow Designer to automate the export process to the table.