My requirement is to bulk import records into a custom table. The table does not have all the fields created which the client requires so we created a record producer pointing to the custom table, and we did not map the fields of record producer to any fields on the custom table. So all the variables are stored in the record producer and not on the custom table.
I do understand that using REST API to submit an MRVS, we use a JSON Encoding like below:
{"variables":{
"var1": "value0",
"mrvs": [
{"mrv_var1": "value1"},
{"mrv_var2": "value2"}
]
}}
My question is what is the best way for the bulk import to happen, right from taking the excel sheet from the client to creating multiple records in the custom table using record producer. I am very confused on the optimal way to gather information from clients in excel sheet to writing transform maps, REST API scripts in ServiceNow. Please do define a clear way of achieving this functionality.
