Insert JSON data to MongoDB inserting empty values

[Siva_Manickam]

My goal is to download a JSON file from S3 and insert the JSON value to MongoDB, however I’m observing empty values in MongoDB

What is the error message (if any)?

Please share the workflow

Share the output returned by the last node

Here is the JSON input file stored in S3
[{
“data”: “SKU1234”,
“Desc”: “Ganesh”,
"Name ": “Name Desc”,
“Test”: “Test fast”,
“Test 2”: “Test Test 2”,
“Test 3”: “Test Test 3”
}]

Information on your n8n setup

• n8n version:
• Database you’re using (default: SQLite):
• Running n8n with the execution process [own(default), main]:
• Running n8n via [Docker, npm, n8n.cloud, desktop app]:
  
  

[MutedJam]

Hi @Siva_Manickam, it seems your fields aren’t on the top level of your file. Looking at your example data you probably want to move the binary data and then split out your fields as shown below:

This would give you proper fields to work with in subsequent nodes:

On the Move Binary Data node you want to make sure to disable “Set All Data” and enable “JSON Parse”: