Describe the issue/error/question
Hi,
I take several HTTP nodes to download an encrypted report. Then, I decompress with the Compression node, and moved the binary to json with Move Binary Data node. But the resulting json is very hard to work with. If I add a Spreadsheet node instead of the MBD node, it doesn’t return the data properly, if I make a file it’s not properly ordered.
The resulting json is completely normal, but if I change the view to Table tab, it appears that each group of data is nested with a number.
Here the important nodes:
{
“meta”: {
“instanceId”: “d58043e5a2d90cfccdda22f430cc0fc54767857d6204d3e17454f47932efca7c”
},
“nodes”: [
{
“parameters”: {
“outputPrefix”: “data”
},
“id”: “7dfe8936-db2e-4ba5-9c75-9c34c25ae0d9”,
“name”: “Compression”,
“type”: “n8n-nodes-base.compression”,
“typeVersion”: 1,
“position”: [
1820,
-60
]
},
{
“parameters”: {
“sourceKey”: “data0”,
“options”: {}
},
“id”: “69ff710d-1281-4720-bcb0-76ca1032a5b7”,
“name”: “Move Binary Data”,
“type”: “n8n-nodes-base.moveBinaryData”,
“typeVersion”: 1,
“position”: [
2040,
-60
]
}
],
“connections”: {
“Compression”: {
“main”: [
[
{
“node”: “Move Binary Data”,
“type”: “main”,
“index”: 0
}
]
]
}
}
}
Here photo of the json result and the table result.
I want to create a simple csv, but I can’t operate with this resulting json.
Information on your n8n setup
- **n8n version: 0.204.0
- **Database you’re using: default: SQLite
- **Running n8n with the execution process: own(default
- **Running n8n via: desktop app