Insert data from json to table in SQL Server with NULL row

[Jeersson Maradiaga]

Hi,

I'm trying to insert data in SQL table using like a source a json, the data looks good in my table, but I don't know why the process insert addiotional rows with all columns in NULL

this is my json

{
  "Files": [
    {
      "FileName": "Test.pdf",
      "RowCount": 10,
      "BoxFullPath": "Integrations/TestDoc_6.pdf"
    },
    {
      "FileName": "Test2.pdf",
      "RowCount": 100,
      "BoxFullPath": "Integrations/TestDoc_7.pdf"
    }
  ],
  "Status": 1,
  "UniqueCode": "CT_Images",
  "Event_Time": "2023-06-29 09:25:53.444000000",
  "PackageGuid": "5abeeffb-a118-4fdc-b857-b7f334da8adf",
  "Processed_Message_Key": "0"
}

[Ivan Peev]

Hi Jeersson,

I suspect you are retrieving data from the Files composite field. Please review the documentation page here.