Ah, is the entire input_json escaped with slashes, or only the Status array? Or is it the data in the Status array?
Chances are you probably only need to run one of the above through JSON.parse again. This is all guesswork without seeing the recipe and the payload, but it might be worth a quick try.
Any chance you can share a redacted screenshot or copy/paste of the input_json?
const createRecord = (employee) => {
row = {}
// Map top level fields - simple
row.FirstName = employee.FirstName
row.LastName = employee.LastName
row.EmployeeId = employee.EmployeeId
// Map name - nested array
// ====== UPDATES HERE ======
//try this first
row.regulation = JSON.parse(employee.Status)[0].Regulation
//maybe try this is the above doesn't work
//row.regulation = JSON.parse(employee.Status[0]).Regulation
return row
}
exports.main = ({input_json}) => {
const input = JSON.parse(input_json)
const rows = []
input.forEach(employee => {
rows.push(createRecord(employee))
})
return {
rows: rows
}
}
