Import set JSON missing attributes / field

[Eli Guttman]

Hi,

I'm using import sets with a JSON file type.

In the file, one of the attributes does not appear for all objects. In this example, fieldc attributes is missing from the 3rd object 

{
"Report_Entry": [
{
   
  "fieldA": "ddddd",
   "fieldB": "ccccc",
   "fieldC": "bbbbb",
   "fieldD": "aaaa"
 },
{

 "fieldA": "ddddd",
   "fieldB": "ccccc",
   "fieldC": "bbbbb",
   "fieldD": "aaaa"
},
{
  
   " "fieldA": "ddddd",
   "fieldB": "ccccc",
   "fieldD": "aaaa"
}]
}

It seems like this is causing the field to be ignored for all records and not being loaded to the staging table.

Does anyone know how to overcome this issue?

[Ankur Bawiskar]

@Eli Guttman 

if the json key is not present is it not setting the import set field as empty string?