How to look up from named fields in array?

Questions
1

This is more of a method question. Any guidance is appreciated.

Thanks in advance.

Given this json input:

{
    "fields": [
        {
            "id": 21759,
            "value": "d0:88:0c:7b:8d:0d",
            "label": "MAC Address",
            "position": 17
        },
        {
            "id": 21753,
            "value": "HRTJ504ZQ6L7",
            "label": "Serial Number",
            "position": 18
        },
        {
            "id": 21767,
            "value": null,
            "label": "Warranty Expires At",
            "position": 19
        }
    ]
}

I need a way to look this up like so:

In the element with the label A, return the value.

For example:

Find the element with the label Serial Number, return the value.

This should return: HRTJ504ZQ6L7

Information on your n8n setup

  • n8n version: 1.36.2
  • Database (default: SQLite): PostgresQL
  • n8n EXECUTIONS_PROCESS setting (default: own, main): Que
  • Running n8n via (Docker, npm, n8n cloud, desktop app): Docker on Digital Ocean
  • Operating system: Ubuntu Linux 22.04 LTS
2

Hello, @russellkg , It would be something like this

3

Thank you thank you thank you.

That resolved my issue.

-Russ

1 Like
4

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.