Splitting a single item into many?

Shew, my learning curve here is vertical. Considering I am starting from pure ignorance and no code experience, a 1 week vertical learning curve still means I know almost nothing. I am starting to grasp some terminology and logic.

I am trying to work with a json file supplied via an API using HTTP. I have used a SET node after the HTTP node to extract the data I need. Only its only working for 1 of the several hundred items. I have come realise that is likely because the json file in the HTTP node is being seen as 1 item. I have crawled the docs and this forum but I am am stumped. I think because the function needed to created multiple items from a single item is very specific to the source json file.

Below is s a sample of the json. I have pasted only 5 “items” but there are actually hundreds. The data I want seen as an item so the SET node will work properly is everything from “k1” to “order number”

[
{
"ok": true,
"entries": [
{
"k1": {
"name": "JONATHAN MAEHLER",
"csaId": 6769
},
"k2": {
"name": "Benjamin Maehler",
"csaId": 61277
},
"k3": null,
"k4": null,
"entryDate": "2019-08-09",
"entryTime": "21:29:03",
"raceName": "GARA DOLPHIN COAST 17&18 AUG 2019",
"orderNumber": "ORD00001197"
},
{
"k1": {
"name": "ANTHONY EDMONDS",
"csaId": 8977
},
"k2": null,
"k3": null,
"k4": null,
"entryDate": "2019-08-09",
"entryTime": "18:12:36",
"raceName": "GARA DOLPHIN COAST 17&18 AUG 2019",
"orderNumber": "ORD00001194"
},
{
"k1": {
"name": "Sharon Armstrong",
"csaId": 555
},
"k2": null,
"k3": null,
"k4": null,
"entryDate": "2019-08-09",
"entryTime": "17:28:27",
"raceName": "GARA DOLPHIN COAST 17&18 AUG 2019",
"orderNumber": "ORD00001190"
},
{
"k1": {
"name": "TYRON MAHER",
"csaId": 9800
},
"k2": null,
"k3": null,
"k4": null,
"entryDate": "2019-08-09",
"entryTime": "17:14:14",
"raceName": "GARA DOLPHIN COAST 17&18 AUG 2019",
"orderNumber": "ORD00001188"
},
{
"k1": {
"name": "HAYLEY NIXON",
"csaId": 70562
},
"k2": null,
"k3": null,
"k4": null,
"entryDate": "2019-08-09",
"entryTime": "17:04:06",
"raceName": "GARA DOLPHIN COAST 17&18 AUG 2019",
"orderNumber": "ORD00001186"
}
]
}
]

This is what it looks like when viewed in the HTTP mode under table.

Try adding the Item Lists node to split on field entries before the set node.

1 Like

Thanks since posting, I discovered that and after banging my head against the wall repeatedly I got it to work.

1 Like