Can I enter the path to an value manually?

Questions & Answers
1

Hey all

I want to get a item from a nested object I receive via webhook from Stripe. This is the object. I’ve marked the relevant attribute with am <------------------.

{
    "id": "xxx",
    "object": "event",
    "account": "xxx",
    "api_version": "2020-08-27",
    "created": 1688979466,
    "data": {
      "object": {
        "id": "xxx",
        "object": "invoice",
        "lines": {
          "object": "list",
          "data": [
            {
              "id": "xxx",
              "object": "line_item",
              "amount": 599997,
              "amount_excluding_tax": 599997,
              "currency": "eur",
              "description": "Time on lorem ipsum" <--------------
            }
          ],
          "has_more": false,
          "total_count": 2,
          "url": "/v1/invoices/xxx/lines"
        }
      }
    },
    "livemode": false,
    "pending_webhooks": 1,
    "type": "invoice.created"
  }

I need this attribute to set up a filter. Unfortunately I cannot access the attribute when setting up the filter, as it is only marked as collection.
image

As this does not work for me, tried to set a variable containing the description by using first() and pick(). first() works as expected, returning the first entry from the data array. pick() on the other side does not work (results in an empty varaible).
image

So how can I access this value? Is it possible to enter the path manually, e.g. data.object.lines.data[1].description somehow? If yes, how?

Thank you very much!

2

If you want to get the first data for the description, then what you can use is,

{{first(map(1.data.object.lines.data; “description”))}}

If you want to get the description for all, then you can use an iterator and directly access the description from there.

1 Like