Problem on JSON with Default data loader?

Questions
1

Describe the problem/error/question

I have a problem between the input and the output of my node “insert Data store”.
The default data loader handle my json as a blob file and create an element for each line instead of 1 with metadata and the other one with pageContent.
Exemple:
input:

{  
 "pageContent": "Comité RSE du 28 janvier",  
 "metadata": {    
    "source": "notion"    
    "title": "Comité RSE",  
 }
}

output:

{  
 "pageContent": "Comité RSE du 28 janvier",  
 "metadata": {    
     "source": "blob",    
     "blobType": "application/json",    
     "line": 1,    ...  
  }
},
{  
 "pageContent": "notion",  
 "metadata": {    
     "source": "blob",    
     "blobType": "application/json",    
     "line": 1,    ...  
 }
}

It is mandatory to use a loader but i’m not able to configure it correctly as in any case it splits all my values

Please share your workflow

Share the output returned by the last node

{  
 "pageContent": "Comité RSE du 28 janvier",  
 "metadata": {    
     "source": "blob",    
     "blobType": "application/json",    
     "line": 1,    ...  
  }
},
{  
 "pageContent": "notion",  
 "metadata": {    
     "source": "blob",    
     "blobType": "application/json",    
     "line": 1,    ...  
 }
}

Information on your n8n setup

  • n8n version: 1.106.3
  • Database (default: SQLite): simple memory
  • Running n8n via (Docker, npm, n8n cloud, desktop app): n8n cloud
  • Operating system: Mac os
2

Hi Romain_vermeeren, I hope you’re doing well. I wanted to reach out because I am currently experiencing the same issue that you mentioned. Have you found any solutions to this problem? I am also struggling with it and, unfortunately, I have not been able to find any effective solutions myself. Any insights you could share would be greatly appreciated.

3

Hello ! Unfortunately i’m still stuck at this step even if i try another source of data.