What table are the custom variables value stored

[John H1]

We are in the process of building our first Recipe from Workato. We are having problems access the values from custom variables from our Catalog item forms. How and where are these values stored.

[Niklas Peterson]

Hi,

Catalog Item variables are stored in the Option [sc_item_option] table which in turn works together with the Variable Ownership [sc_item_option_mtom] table that connect the variable value with a parent record.

Regards,
Niklas

[John H1]

I appreciate the information but still at a loss on how we can map fields between ServiceNow and Jira using Workato

[Prabu Velayutha]

@John H1 Check if the Custom Variable values are cascaded to the RITM Service catalogs tasks and you can access those fields with values mapped. If the Catalog variable values are not cascaded or mapped to the RITM SC Task then what is the purpose of those variables to display on the Catalog form for the user input? Can you provide some examples of those variables?

In common we integrate only Request ITEM Service Catalog Tasks with external tools. You can check these field SC catalog task table.

 I'm not sure if you have any specific use case, if you can share?

If my response helps to solve your issue. Kindly mark it as helpful & correct.

[Niklas Peterson]

Well, you asked for where the values are stored and thats where they are stored. How to integrate ServiceNow with Jira using Workato is another question. And I guess that totatally depends on how Workato works. I'm sorry but I have no knowledge on Workato.

Maybe someone else can answer that question?

Regards,
Niklas