Empty fields from SOQL query returned as '\x1B[1mnull\x1B[22m'
I'm guessing this is due sfdx colorising the output for the shell... Repro
const sfdx = require('sfdx-node/parallel')
void async function () {
console.log(await sfdx.force.data.soqlQuery({ query: 'select id, FirstName, LastName from lead', _rejectOnError: true }))
}()
➜ sfdx git:(master) ✗ node repro.js
Querying Data...
{
done: true,
totalSize: 2,
records: [
{
attributes: [Object],
Id: '00Q1100000EkzEDEAZ',
FirstName: '\x1B[1mnull\x1B[22m',
LastName: 'LeadNumber0',
height: 1
},
{
attributes: [Object],
Id: '00Q1100000EkzEEEAZ',
FirstName: '\x1B[1mnull\x1B[22m',
LastName: 'LeadNumber1',
height: 1
}
]
}
➜ sfdx git:(master) ✗ sfdx version
sfdx-cli/7.103.0 darwin-x64 node-v14.15.1