How can we create variable in service catalog using transform map importing data from excel

is_12
Tera Contributor

Hello Community,

 

I need to automate the variable creation of the catalog item

If anyone know the refer video or the wiki, please share, it would be helpful 

 

Thanks,

1 ACCEPTED SOLUTION

@is_12 

In that case you can have 1 excel with multiple columns and have 1 transform map and handle everything via onBefore transform script

1) in that transform script, create catalog item, create variables and link with your catalog item

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

View solution in original post

6 REPLIES 6

is_12
Tera Contributor

Hi @Ankur Bawiskar

As off now I have created two transform maps, one for catalog item creation & one for variable's creation

I have created all the catalog items using transform. And as part of variable creation trail, I have added 2 of the variable in the excel for one item, then created a variables using transform map. It was working fine

but when I created the variables for multiple items using same import set & transform which I created for trails

Variables are creating but when I try to click on try it variables are not visible 

 

Can you please help me with that

 

Thanks In advance.

 

@is_12 

it means variables are not correctly associated with the catalog item.

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader