I need to map a nested JSON request body, to the specific columns defined in the excel.
I have tried using the .
notation, but it is not working.
For parsing the input file, I am using the following -
var transform = function(inputJson) {
var input = JSON.parse(inputJson);
var request = {
method: 'POST',
url: '{{API_url}}',
httpVersion: 'HTTP/1.1',
cookies: [],
headers: [{
"name": "",
"value": "",
"comment": ""
}],
queryString: [],
postData: {
"mimeType": "application/json;charset=UTF-8",
"text": JSON.stringify(convert(input))
}
};
return JSON.stringify(request);
}