Reputation: 1
I am using the t_rest component to obtain a json listing, in this listing we have the order_id within a class called items and within another class also called items we actually have the order items. when I extract using "items[*].sku" it brings the 2 lines separated by ",". however I need to separate this data to record the items of an order, leaving the repeated order and the values of each item and the respective quantity.
data extraction enter image description here
component configuration enter image description here
Exemplo do Json
{
"items": [
{
"grand_total": 348.83,
"order_id": 1497649,
"items": [
{
"created_at": "2023-01-26 22:19:58",
"price": 48,
"qty_ordered": 1,
"sku": "11111"
},
{
"created_at": "2023-01-26 22:19:58",
"price": 300.83,
"qty_ordered": 1,
"sku": "22222"
}
]
}
]
}
log output enter image description here
data extraction enter image description here
component configuration enter image description here
Upvotes: -1
Views: 15