Unable to split using Item Lists

Questions
,
#1

I’m trying to split out a multi-dimensional array using item lists but it keeps throwing an error stating it cannot find Object, Object. The structure seems like I should be able to use Item lists, so I’m not sure why it is not working. The data I’m specifically trying to extract is the “sellerId”, which you will see in the workflow I pasted below.

Note: Even thought I’m using more recent version, I uploaded a previous workflow which still is using FunctionItem node instead of Code. But I do not believe this is causing the problem.

ERROR: Couldn’t find the field ‘[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object]’ in the input data

Here’s a simpler version, focusing just on the issue;

Additionally, if I just try splitting the sellerId using {{ $json[“offers”][0][“sellerId”] }}

It gives me ERROR: Couldn’t find the field ‘ATY4ITDW0ZSW’ in the input data

which is strange because if it knows the value of the field which it put in single quotes, then it can obviously find it, so I’m not understanding what the error is.

(Select the nodes and use the keyboard shortcuts CMD+C/CTRL+C and CMD+V/CTRL+V to copy and paste the workflow respectively)


## Share the output returned by the last node
<!-- If you need help with transforming the data, please also share the expected output -->

## 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]:**
#2

The ASIN isnt in Keepa’s database - they claim a lot more than what they actually have.
Their data is outdated and even if you ask for a real-time refresh it still is outdated by months.
Barely usable data for anything other than curiosity.

Try this ASIN e.g. B084DCJKSL and it will work

#3

That’s not the issue. I have successfully parsed out the csv array from the products object and the data is up to date. The issue is that the offers object will not split using item lists. The http request is fine and the asin I’m using is in the keepa database with up to date info.

#4

Hey @JasonA,

Are you able to share the output of the Keepa HTTP Request from the second workflow?

1 Like
#5

I’m going to close this entry and start a new thread, I think I resolved my original issue but have another one,… still related to accessing a parameter, but I don’t want to muddy the issue with this thread. Thanks

1 Like
#6

Hi! How I don´t know what was the solution, I will put here may JSon that I trying to Split… The final that I expect is use fields id, key and type to insert a data in a multiples lines inside GoogleSheets (One line for each id)…

[
{
“data”: [
{
“id”: 508666,
“key”: “M_Acao”,
“type”: 0
},
{
“id”: 507631,
“key”: “M_Audio”,
“type”: 0
},
{
“id”: 508670,
“key”: “M_CampoLivre”,
“type”: 0
},
{
“id”: 508145,
“key”: “M_CEP”,
“type”: 0
},
{
“id”: 507622,
“key”: “M_Content”,
“type”: 0
},
{
“id”: 508133,
“key”: “M_CPF”,
“type”: 0
},
{
“id”: 515735,
“key”: “M_DataNascTxt”,
“type”: 0
},
{
“id”: 511928,
“key”: “M_DataNascTxT”,
“type”: 0
},
{
“id”: 515734,
“key”: “M_DateTimeTxt”,
“type”: 0
},
{
“id”: 508144,
“key”: “M_DMNasc”,
“type”: 0
},
{
“id”: 515736,
“key”: “M_DTTSendTxt”,
“type”: 0
},
{
“id”: 508134,
“key”: “M_E-Mail”,
“type”: 0
},
{
“id”: 520966,
“key”: “M_Etiquetas”,
“type”: 0
},
{
“id”: 507621,
“key”: “M_Fase”,
“type”: 0
},
{
“id”: 508611,
“key”: “M_FirstName”,
“type”: 0
},
{
“id”: 508612,
“key”: “M_FullName”,
“type”: 0
},
{
“id”: 507629,
“key”: “M_Image”,
“type”: 0
},
{
“id”: 507627,
“key”: “M_InSeq”,
“type”: 0
},
{
“id”: 507624,
“key”: “M_LessEtiq”,
“type”: 0
},
{
“id”: 508668,
“key”: “M_Link1”,
“type”: 0
},
{
“id”: 508669,
“key”: “M_Link2”,
“type”: 0
},
{
“id”: 507628,
“key”: “M_OutSeq”,
“type”: 0
},
{
“id”: 507623,
“key”: “M_PlusEtiq”,
“type”: 0
},
{
“id”: 515737,
“key”: “M_ProxRenovTxt”,
“type”: 0
},
{
“id”: 508180,
“key”: “M_TipoCliente”,
“type”: 0
},
{
“id”: 507630,
“key”: “M_Video”,
“type”: 0
}
]
}
]

#7

Hi @Evandro_Caruso,

Welcome to the community :raised_hands:

It is normally best to create a new thread and complete the template provided. Looking at your data what you are trying to do can by done by adding an item lists node and typing in data like the example workflow below.