How can I export the catalog item variables

jaouad_essabir
Mega Contributor

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:

find_real_file.png

How can i export all this variables to external systems ?

I use "System Export Set" module :

find_real_file.png

But, i can't find the variables when i defined the export using "Requested Item" table ?

find_real_file.png

Would you have an idea how to export these variables ? using mid-server or other ?

Thanks for your help

Regards

5 REPLIES 5

Jonathan Brown
Kilo Guru

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.