Import Set API with multi row variable set

[Shruti12]

I am trying to send a multi-row variable set to the Import set API and transform it to sc_task using the SC Task API staging table. Does import set api support multi-row variable sets? I tried using a column with string and list types with reference to Variable set table but it didn't work.

Any suggestions?

[Dr Atul G- LNG]

Hi @Shruti12 

https://www.servicenow.com/community/developer-forum/service-catalog-script-api-and-multi-row-variab...

https://www.servicenow.com/community/itsm-forum/how-to-insert-values-of-multi-row-variables-through-...

[Shruti12]

Thanks for the response Atul. I am looking for a specific OOTB API - 'Import Set API' to work with MRVS. The incoming payload is staged and then transformed to the respective table and I don't see an option to make it work with MRVS except staging that variable as a string and then converting to JSON object on the script before transforming. 

Please let me know if you know a better way of achieving it.

Thanks,

Shruti

[Dr Atul G- LNG]

Hi @Shruti12 

I think this is the only solution.