JavaScript Connector handling null values

[jharrison]

Has anyone had luck handling null values in a JavaScript Connector? I have tried all these below but the error remains "Cannot read properties of null (reading 'regulation')"

regulation = arrayValue.regulation
regulation = arrayValue.regulation || 0
regulation = arrayValue[0].regulation || 0
if(arrayValue.regulation === null){regulation = "null"} else {regulation = arrayValue.regulation}
if(arrayValue.regulation != null){regulation = arrayValue.regulation} else {regulation = "null"}

[gary1]

Can you share more of the script? After you define "regulation", what are you doing with it?

[jharrison]

https://www.workato.com/product-hub/semi-structured-data-tamed-with-javascript/

I am following this article on Semi-structured data tamed with JavaScript

Below is the JS note my attempts are all commented with errors noted at end. If I comment out the nested array part if works great.

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
const Status = employee.Status
row.regulation = employee.Status.Regulation
//let reg = "reg"
//row.regulation = Status.regulation
//row.reg = Status.regulation || "null" //Cannot read properties of null (reading 'regulation')
//regulation = if(Status.regulation === null){"null"}else {Status.regulation}
//row.regulation = Status[0].regulation || 0
//if(Status.regulation === null){row.regulation = "null"} else {row.regulation = Status.regulation}
//if(Status.regulation !== null){row.regulation = "null"} else {row.regulation = Status.regulation}
//if(Status.regulation.length === 0){row.regulation = "null"} else {row.regulation = Status.regulation}
//if(Status[0].length === 0){row.regulation = "null"} else {row.regulation = Status.regulation} Cannot read properties of undefined (reading 'length')

return row
}

exports.main = ({ input_json }) => {
const input = JSON.parse(input_json)
const rows = []
input.forEach(employee => {
rows.push(createRecord(employee))
})
return {rows: rows}
}

[jharrison]

Here is the Schema

[
{
"LastName": "",
"FirstName": "",
"Status": [
{
"Regulation": ""
}
]
}
]

[gary1]

Using that exact array as input, this script works fine on my end (I really didn't make any changes).

Is Regulation always present in the first index of the Status array? If not, then you may need to loop through Status to find an object with Regulation.

Either way though, I'm not getting any errors when the value is present, blank, or null.

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
row.regulation = 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
}
}

1. Input with blanks

[{
"LastName": "",
"FirstName": "",
"Status": [{
"Regulation": ""
}]
}] 

Output:

2. Input with nulls:

[{
"LastName": null,
"FirstName": null,
"Status": [{
"Regulation": null
}]
}]

Output:

3. Input with values:

[{
"FirstName": "Spider",
"LastName": "Man",
"EmployeeId": "123",
"Status": [{
"Regulation": test
}]
}]

 Output:

4. Input with an empty object leading the Status array:

[{
"FirstName": "Spider",
"LastName": "Man",
"EmployeeId": "123",
"Status": [{},{
"Regulation": "test"
}]
}]

 Output: