Luiz Lima Lopes
Luiz Lima Lopes

Reputation: 1

tExtractJSONFields result String

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

Answers (0)

Related Questions