Hi, I need help with this, I noticed that when it’s just one item the flow works normally, what could it be?
If you’re noticing that this works with one input item, have you tried mapping over this data or using the Split in Batches node with a batch size of 1? If so, does that fix up the issue? 
I’m trying to generate a csv containing the data from the supabase database, can you give me an example of how to do this.
HI @LorenzoSbeghen 
I wouldn’t be able to connect to your own database, so can you provide an example of the data that you’re receiving before that first set node called Estruturar1?
JSON Snippet
[
{
"id": 237213,
"created_at": "2023-09-26T11:01:36.652342+00:00",
"ITEM": "GAM4315.0003",
"CODIGO_LINHA": "11",
"NRO_PEDIDO": "132578"
},
{
"id": 237214,
"created_at": "2023-09-26T11:01:36.652342+00:00",
"ITEM": "GAM4317.0006",
"CODIGO_LINHA": "11",
"NRO_PEDIDO": "132578"
},
{
"id": 237215,
"created_at": "2023-09-26T11:01:36.652342+00:00",
"ITEM": "PRM2002.0017",
"CODIGO_LINHA": "2",
"NRO_PEDIDO": "132578"
},
{
"id": 237216,
"created_at": "2023-09-26T11:01:36.652342+00:00",
"ITEM": "APL8171.0006",
"CODIGO_LINHA": "82",
"NRO_PEDIDO": "132578"
},
{
"id": 237217,
"created_at": "2023-09-26T11:01:36.652342+00:00",
"ITEM": "APL1600.0016",
"CODIGO_LINHA": "82",
"NRO_PEDIDO": "132578"
},
{
"id": 237218,
"created_at": "2023-09-26T11:01:36.652342+00:00",
"ITEM": "APL0731.0019",
"CODIGO_LINHA": "82",
"NRO_PEDIDO": "132578"
},
{
"id": 237219,
"created_at": "2023-09-26T11:01:36.652342+00:00",
"ITEM": "APL0732.0022",
"CODIGO_LINHA": "82",
"NRO_PEDIDO": "132578"
},
{
"id": 237220,
"created_at": "2023-09-26T11:01:36.652342+00:00",
"ITEM": "PDR1018.0008",
"CODIGO_LINHA": "78",
"NRO_PEDIDO": "132578"
},
{
"id": 237645,
"created_at": "2023-09-26T11:01:36.652342+00:00",
"ITEM": "FLO1970.0004",
"CODIGO_LINHA": "116",
"NRO_PEDIDO": "132578"
},
{
"id": 237646,
"created_at": "2023-09-26T11:01:36.652342+00:00",
"ITEM": "FLO1971.0003",
"CODIGO_LINHA": "116",
"NRO_PEDIDO": "132578"
},
{
"id": 237647,
"created_at": "2023-09-26T11:01:36.652342+00:00",
"ITEM": "FLO3511.0002",
"CODIGO_LINHA": "116",
"NRO_PEDIDO": "132578"
},
{
"id": 237648,
"created_at": "2023-09-26T11:01:36.652342+00:00",
"ITEM": "FLO7011.0002",
"CODIGO_LINHA": "116",
"NRO_PEDIDO": "132578"
},
{
"id": 237649,
"created_at": "2023-09-26T11:01:36.652342+00:00",
"ITEM": "FLO3535.0005",
"CODIGO_LINHA": "116",
"NRO_PEDIDO": "132578"
},
{
"id": 237650,
"created_at": "2023-09-26T11:01:36.652342+00:00",
"ITEM": "FLO7035.0002",
"CODIGO_LINHA": "116",
"NRO_PEDIDO": "132578"
},
{
"id": 237651,
"created_at": "2023-09-26T11:01:36.652342+00:00",
"ITEM": "FLO3515.0007",
"CODIGO_LINHA": "116",
"NRO_PEDIDO": "132578"
},
{
"id": 237652,
"created_at": "2023-09-26T11:01:36.652342+00:00",
"ITEM": "FLO3515.0008",
"CODIGO_LINHA": "116",
"NRO_PEDIDO": "132578"
},
{
"id": 237654,
"created_at": "2023-09-26T11:01:36.652342+00:00",
"ITEM": "FLO3515.0009",
"CODIGO_LINHA": "116",
"NRO_PEDIDO": "132578"
},
{
"id": 237655,
"created_at": "2023-09-26T11:01:36.652342+00:00",
"ITEM": "FLO3520.0002",
"CODIGO_LINHA": "116",
"NRO_PEDIDO": "132578"
},
{
"id": 237656,
"created_at": "2023-09-26T11:01:36.652342+00:00",
"ITEM": "FLO7220.0002",
"CODIGO_LINHA": "116",
"NRO_PEDIDO": "132578"
},
{
"id": 237657,
"created_at": "2023-09-26T11:01:36.652342+00:00",
"ITEM": "FLO1630.0002",
"CODIGO_LINHA": "116",
"NRO_PEDIDO": "132578"
},
{
"id": 237658,
"created_at": "2023-09-26T11:01:36.652342+00:00",
"ITEM": "CEVA.SOS1L.0029",
"CODIGO_LINHA": "77",
"NRO_PEDIDO": "132578"
},
{
"id": 237659,
"created_at": "2023-09-26T11:01:36.652342+00:00",
"ITEM": "PSFV.75H70.0004",
"CODIGO_LINHA": "87",
"NRO_PEDIDO": "132578"
},
{
"id": 237660,
"created_at": "2023-09-26T11:01:36.652342+00:00",
"ITEM": "PSFV.45H70.0007",
"CODIGO_LINHA": "87",
"NRO_PEDIDO": "132578"
},
{
"id": 237661,
"created_at": "2023-09-26T11:01:36.652342+00:00",
"ITEM": "PSFV.45H45.0008",
"CODIGO_LINHA": "87",
"NRO_PEDIDO": "132578"
},
{
"id": 237662,
"created_at": "2023-09-26T11:01:36.652342+00:00",
"ITEM": "PSFV.45H45.0009",
"CODIGO_LINHA": "87",
"NRO_PEDIDO": "132578"
},
{
"id": 237663,
"created_at": "2023-09-26T11:01:36.652342+00:00",
"ITEM": "MDV6037.0022",
"CODIGO_LINHA": "77",
"NRO_PEDIDO": "132578"
},
{
"id": 237664,
"created_at": "2023-09-26T11:01:36.652342+00:00",
"ITEM": "MAX7705.0037",
"CODIGO_LINHA": "55",
"NRO_PEDIDO": "132578"
},
{
"id": 237665,
"created_at": "2023-09-26T11:01:36.652342+00:00",
"ITEM": "MAX7706.0090",
"CODIGO_LINHA": "55",
"NRO_PEDIDO": "132578"
},
{
"id": 237666,
"created_at": "2023-09-26T11:01:36.652342+00:00",
"ITEM": "ACT0062.0002",
"CODIGO_LINHA": "17",
"NRO_PEDIDO": "132578"
},
{
"id": 237667,
"created_at": "2023-09-26T11:01:36.652342+00:00",
"ITEM": "OTM1500.0007",
"CODIGO_LINHA": "112",
"NRO_PEDIDO": "132578"
},
{
"id": 237668,
"created_at": "2023-09-26T11:01:36.652342+00:00",
"ITEM": "OTM7520.0015",
"CODIGO_LINHA": "112",
"NRO_PEDIDO": "132578"
},
{
"id": 237669,
"created_at": "2023-09-26T11:01:36.652342+00:00",
"ITEM": "OTM7553.0001",
"CODIGO_LINHA": "112",
"NRO_PEDIDO": "132578"
},
{
"id": 237670,
"created_at": "2023-09-26T11:01:36.652342+00:00",
"ITEM": "OTM0900.0005",
"CODIGO_LINHA": "112",
"NRO_PEDIDO": "132578"
},
{
"id": 237671,
"created_at": "2023-09-26T11:01:36.652342+00:00",
"ITEM": "OTM3514.0003",
"CODIGO_LINHA": "112",
"NRO_PEDIDO": "132578"
},
{
"id": 237672,
"created_at": "2023-09-26T11:01:36.652342+00:00",
"ITEM": "MDU3462.0048",
"CODIGO_LINHA": "77",
"NRO_PEDIDO": "132578"
},
{
"id": 237673,
"created_at": "2023-09-26T11:01:36.652342+00:00",
"ITEM": "CPHI.SOFBQ.0062",
"CODIGO_LINHA": "70",
"NRO_PEDIDO": "132578"
},
{
"id": 237680,
"created_at": "2023-09-26T11:01:36.652342+00:00",
"ITEM": "ORD8003.0011",
"CODIGO_LINHA": "56",
"NRO_PEDIDO": "132578"
},
{
"id": 237681,
"created_at": "2023-09-26T11:01:36.652342+00:00",
"ITEM": "PLU4402.0021",
"CODIGO_LINHA": "5",
"NRO_PEDIDO": "132578"
},
{
"id": 237682,
"created_at": "2023-09-26T11:01:36.652342+00:00",
"ITEM": "GAM4313.0016",
"CODIGO_LINHA": "11",
"NRO_PEDIDO": "132578"
},
{
"id": 237683,
"created_at": "2023-09-26T11:01:36.652342+00:00",
"ITEM": "GAM3311.0010",
"CODIGO_LINHA": "11",
"NRO_PEDIDO": "132578"
},
{
"id": 237684,
"created_at": "2023-09-26T11:01:36.652342+00:00",
"ITEM": "PDR2001.0002",
"CODIGO_LINHA": "78",
"NRO_PEDIDO": "132578"
},
{
"id": 237685,
"created_at": "2023-09-26T11:01:36.652342+00:00",
"ITEM": "PDR3450.0004",
"CODIGO_LINHA": "78",
"NRO_PEDIDO": "132578"
},
{
"id": 237686,
"created_at": "2023-09-26T11:01:36.652342+00:00",
"ITEM": "PDR2005.0002",
"CODIGO_LINHA": "78",
"NRO_PEDIDO": "132578"
},
{
"id": 237687,
"created_at": "2023-09-26T11:01:36.652342+00:00",
"ITEM": "SOL1476.0022",
"CODIGO_LINHA": "41",
"NRO_PEDIDO": "132578"
},
{
"id": 237688,
"created_at": "2023-09-26T11:01:36.652342+00:00",
"ITEM": "SOL1071.0003",
"CODIGO_LINHA": "41",
"NRO_PEDIDO": "132578"
},
{
"id": 237689,
"created_at": "2023-09-26T11:01:36.652342+00:00",
"ITEM": "SOL1294.0004",
"CODIGO_LINHA": "41",
"NRO_PEDIDO": "132578"
},
{
"id": 237690,
"created_at": "2023-09-26T11:01:36.652342+00:00",
"ITEM": "SOL6048.0003",
"CODIGO_LINHA": "41",
"NRO_PEDIDO": "132578"
},
{
"id": 237691,
"created_at": "2023-09-26T11:01:36.652342+00:00",
"ITEM": "SOL6045.0002",
"CODIGO_LINHA": "41",
"NRO_PEDIDO": "132578"
},
{
"id": 237692,
"created_at": "2023-09-26T11:01:36.652342+00:00",
"ITEM": "CLS6010.0005",
"CODIGO_LINHA": "17",
"NRO_PEDIDO": "132578"
},
{
"id": 237693,
"created_at": "2023-09-26T11:01:36.652342+00:00",
"ITEM": "CLS1520.0003",
"CODIGO_LINHA": "63",
"NRO_PEDIDO": "132578"
},
{
"id": 237694,
"created_at": "2023-09-26T11:01:36.652342+00:00",
"ITEM": "CLS7040.0001",
"CODIGO_LINHA": "17",
"NRO_PEDIDO": "132578"
},
{
"id": 237695,
"created_at": "2023-09-26T11:01:36.652342+00:00",
"ITEM": "CLS4383.0013",
"CODIGO_LINHA": "63",
"NRO_PEDIDO": "132578"
},
{
"id": 237696,
"created_at": "2023-09-26T11:01:36.652342+00:00",
"ITEM": "ORD3637.0159",
"CODIGO_LINHA": "56",
"NRO_PEDIDO": "132578"
},
{
"id": 237697,
"created_at": "2023-09-26T11:01:36.652342+00:00",
"ITEM": "ORD3637.0160",
"CODIGO_LINHA": "56",
"NRO_PEDIDO": "132578"
},
{
"id": 237698,
"created_at": "2023-09-26T11:01:36.652342+00:00",
"ITEM": "ORD3637.0161",
"CODIGO_LINHA": "56",
"NRO_PEDIDO": "132578"
},
{
"id": 237699,
"created_at": "2023-09-26T11:01:36.652342+00:00",
"ITEM": "ORD3637.0023",
"CODIGO_LINHA": "56",
"NRO_PEDIDO": "132578"
},
{
"id": 237700,
"created_at": "2023-09-26T11:01:36.652342+00:00",
"ITEM": "ORD3637.0095",
"CODIGO_LINHA": "56",
"NRO_PEDIDO": "132578"
},
{
"id": 237701,
"created_at": "2023-09-26T11:01:36.652342+00:00",
"ITEM": "ORD3637.0158",
"CODIGO_LINHA": "56",
"NRO_PEDIDO": "132578"
},
{
"id": 237702,
"created_at": "2023-09-26T11:01:36.652342+00:00",
"ITEM": "ORD7437.0082",
"CODIGO_LINHA": "56",
"NRO_PEDIDO": "132578"
},
{
"id": 237703,
"created_at": "2023-09-26T11:01:36.652342+00:00",
"ITEM": "ORD7437.0083",
"CODIGO_LINHA": "56",
"NRO_PEDIDO": "132578"
},
{
"id": 237704,
"created_at": "2023-09-26T11:01:36.652342+00:00",
"ITEM": "ORD7437.0084",
"CODIGO_LINHA": "56",
"NRO_PEDIDO": "132578"
},
{
"id": 237705,
"created_at": "2023-09-26T11:01:36.652342+00:00",
"ITEM": "ORD7437.0085",
"CODIGO_LINHA": "56",
"NRO_PEDIDO": "132578"
},
{
"id": 237706,
"created_at": "2023-09-26T11:01:36.652342+00:00",
"ITEM": "SCY1362.0027",
"CODIGO_LINHA": "62",
"NRO_PEDIDO": "132578"
},
{
"id": 237707,
"created_at": "2023-09-26T11:01:36.652342+00:00",
"ITEM": "SCX2.MEF4R.0061",
"CODIGO_LINHA": "62",
"NRO_PEDIDO": "132578"
},
{
"id": 237708,
"created_at": "2023-09-26T11:01:36.652342+00:00",
"ITEM": "SCX2.MEF4S.0011",
"CODIGO_LINHA": "62",
"NRO_PEDIDO": "132578"
},
{
"id": 237709,
"created_at": "2023-09-26T11:01:36.652342+00:00",
"ITEM": "SCX1.MEF4R.0084",
"CODIGO_LINHA": "62",
"NRO_PEDIDO": "132578"
},
{
"id": 237710,
"created_at": "2023-09-26T11:01:36.652342+00:00",
"ITEM": "SCX3.MEF4R.0134",
"CODIGO_LINHA": "62",
"NRO_PEDIDO": "132578"
},
{
"id": 237711,
"created_at": "2023-09-26T11:01:36.652342+00:00",
"ITEM": "SCY9018.0009",
"CODIGO_LINHA": "62",
"NRO_PEDIDO": "132578"
},
{
"id": 237712,
"created_at": "2023-09-26T11:01:36.652342+00:00",
"ITEM": "ATA1061.0013",
"CODIGO_LINHA": "94",
"NRO_PEDIDO": "132578"
},
{
"id": 237713,
"created_at": "2023-09-26T11:01:36.652342+00:00",
"ITEM": "XBL2412.001.001",
"CODIGO_LINHA": "1113",
"NRO_PEDIDO": "132578"
},
{
"id": 237714,
"created_at": "2023-09-26T11:01:36.652342+00:00",
"ITEM": "XPN0606.001.001",
"CODIGO_LINHA": "1062",
"NRO_PEDIDO": "132578"
},
{
"id": 237715,
"created_at": "2023-09-26T11:01:36.652342+00:00",
"ITEM": "ORD1273.0097",
"CODIGO_LINHA": "56",
"NRO_PEDIDO": "132578"
},
{
"id": 237716,
"created_at": "2023-09-26T11:01:36.652342+00:00",
"ITEM": "ORD1226.0025",
"CODIGO_LINHA": "56",
"NRO_PEDIDO": "132578"
},
{
"id": 237717,
"created_at": "2023-09-26T11:01:36.652342+00:00",
"ITEM": "ORD1234.0010",
"CODIGO_LINHA": "56",
"NRO_PEDIDO": "132578"
},
{
"id": 237718,
"created_at": "2023-09-26T11:01:36.652342+00:00",
"ITEM": "XPN0559.001.001",
"CODIGO_LINHA": "1106",
"NRO_PEDIDO": "132578"
},
{
"id": 237719,
"created_at": "2023-09-26T11:01:36.652342+00:00",
"ITEM": "KIAM.BP.002.001",
"CODIGO_LINHA": "1017",
"NRO_PEDIDO": "132578"
},
{
"id": 237720,
"created_at": "2023-09-26T11:01:36.652342+00:00",
"ITEM": "KIAM.CP.002.001",
"CODIGO_LINHA": "1017",
"NRO_PEDIDO": "132578"
},
{
"id": 237721,
"created_at": "2023-09-26T11:01:36.652342+00:00",
"ITEM": "KIAM.DC.002.001",
"CODIGO_LINHA": "1017",
"NRO_PEDIDO": "132578"
},
{
"id": 237722,
"created_at": "2023-09-26T11:01:36.652342+00:00",
"ITEM": "KIAM.LV.002.001",
"CODIGO_LINHA": "1017",
"NRO_PEDIDO": "132578"
},
{
"id": 237723,
"created_at": "2023-09-26T11:01:36.652342+00:00",
"ITEM": "KIAM.MA.002.001",
"CODIGO_LINHA": "1017",
"NRO_PEDIDO": "132578"
},
{
"id": 237724,
"created_at": "2023-09-26T11:01:36.652342+00:00",
"ITEM": "KIAM.ME.002.001",
"CODIGO_LINHA": "1017",
"NRO_PEDIDO": "132578"
},
{
"id": 237725,
"created_at": "2023-09-26T11:01:36.652342+00:00",
"ITEM": "KIAM.PM.002.001",
"CODIGO_LINHA": "1017",
"NRO_PEDIDO": "132578"
},
{
"id": 237727,
"created_at": "2023-09-26T11:01:36.652342+00:00",
"ITEM": "KIAM.ST.002.001",
"CODIGO_LINHA": "1017",
"NRO_PEDIDO": "132578"
},
{
"id": 237730,
"created_at": "2023-09-26T11:01:36.652342+00:00",
"ITEM": "FLO0860.0001",
"CODIGO_LINHA": "116",
"NRO_PEDIDO": "132578"
},
{
"id": 237731,
"created_at": "2023-09-26T11:01:36.652342+00:00",
"ITEM": "FLO0861.0002",
"CODIGO_LINHA": "116",
"NRO_PEDIDO": "132578"
},
{
"id": 237734,
"created_at": "2023-09-26T11:01:36.652342+00:00",
"ITEM": "FLO7035.0008",
"CODIGO_LINHA": "116",
"NRO_PEDIDO": "132578"
},
{
"id": 237735,
"created_at": "2023-09-26T11:01:36.652342+00:00",
"ITEM": "FLO7001.0012",
"CODIGO_LINHA": "116",
"NRO_PEDIDO": "132578"
},
{
"id": 237736,
"created_at": "2023-09-26T11:01:36.652342+00:00",
"ITEM": "FLO3552.0015",
"CODIGO_LINHA": "116",
"NRO_PEDIDO": "132578"
},
{
"id": 237737,
"created_at": "2023-09-26T11:01:36.652342+00:00",
"ITEM": "FLO3525.0005",
"CODIGO_LINHA": "116",
"NRO_PEDIDO": "132578"
}
]
Another thing, if you notice I’m generating a url for the file using Google Drive but I can only use this url if I’m logged into my account, is there another method to do this?
Hi @LorenzoSbeghen - I’m not too sure what’s happening here, but it might be that your code doesn’t account for linked items, but your expression {{ $('Separar1').item.json["pedidos"] }} is looking for them. The code node would require some extra work to make sure this functions: Item linking in the Code node | n8n Docs
An easier workaround might be trying to use a different expression / node reference here, like {{ $('Separar1').first().json["pedidos"] }}-BACKUP-LINHA.csv, which doesn’t require linked items
In terms of the Google Drive question, you would need to be logged in to your Drive account to use the URL with n8n, there wouldn’t be a way around that authorisation of credentials.
1 Like
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.