Import catalog variables data into SQL Server Management Studio

[Mahesh Pydisett]

Hi everyone,

Can anyone please help me on this requirement i.e., Import the catalog item variables data into SQL Server Managment Database.

If anybody has done this, please let me know how can i achieve?

Thanks in Advance!!

[Amit Verma]

Hi @Mahesh Pydisett 

If I understood your requirement clearly, you want to insert catalog item variables data into a SQL database. If yes, you can create a flow in ServiceNow with trigger as Service Catalog. Inside the flow, you can make use of Get Catalog Item Variables action to gather the variable values followed by an action with JDBC step to insert data into the MSSQL database. Refer https://docs.servicenow.com/bundle/washingtondc-build-workflows/page/administer/flow-designer/refere...

You could also refer the below post for alternative approaches https://www.servicenow.com/community/developer-forum/how-to-send-catalog-item-variable-value-to-thir...

Thanks and Regards

Amit Verma