3 replies

Trouble saving meta data from API GET Call

I'm having a problem with saving meta data value from my WC REST API entry in Voiceflow API Block using Capture Response. Headers are correct (Authorization and Content-Type) and I get successful API calls and even pull/save data into variables (e.g. Order Number, Order Status, Shipping Address). However, whilst trying to save the backordered value using

line_items[0].meta_data[?(@.key=='Backordered')].value

line_items[0].meta_data[?(@.key=='Backordered')].value

it simply results in an empty (default) variable.

I'm incredibly new to all of this (Voiceflow and APIs) but can't seem to solve the issue even with GPT4 or the documentation. I'm not sure how i would go about solving this.

https://www.WEBSITE/wp-json/wc/v3/orders/{order_number}

"id": XXXXX1,
"status": "pending",
"billing": {...},
"shipping": {...},
"order_number": "XXXX2",
"line_items": [
      {
        "id": 58290,
        "name": "ITEM NAME",
        "product_id": XXXXX3,
        "variation_id": XXXXX4,
        "quantity": 1,
        "tax_class": "",
        "subtotal": "1220.95",
        "subtotal_tax": "0.00",
        "total": "1220.95",
        "total_tax": "0.00",
        "taxes": [],
        "meta_data": [
          {
            "id": 672070,
            "key": "pa_colour",
            "value": "white",
            "display_key": "Colour",
            "display_value": "White"
          },
          {
            "id": 672072,
            "key": "Backordered",
            "value": "1",
            "display_key": "Backordered",
            "display_value": "1"
          }
        ],

"id": XXXXX1,
"status": "pending",
"billing": {...},
"shipping": {...},
"order_number": "XXXX2",
"line_items": [
      {
        "id": 58290,
        "name": "ITEM NAME",
        "product_id": XXXXX3,
        "variation_id": XXXXX4,
        "quantity": 1,
        "tax_class": "",
        "subtotal": "1220.95",
        "subtotal_tax": "0.00",
        "total": "1220.95",
        "total_tax": "0.00",
        "taxes": [],
        "meta_data": [
          {
            "id": 672070,
            "key": "pa_colour",
            "value": "white",
            "display_key": "Colour",
            "display_value": "White"
          },
          {
            "id": 672072,
            "key": "Backordered",
            "value": "1",
            "display_key": "Backordered",
            "display_value": "1"
          }
        ],

Trouble saving meta data from API GET Call

Similar Threads