Forum Discussion

AndrewS's avatar
AndrewS
Qrew Trainee
3 years ago

Pipeline Webhook / JSON path

Hi everybody,

I have a Pipeline with following steps:

1. Webhooks Incoming Request
2. Quickbase Create Record

Response from 1st step is:

body:"{"eventNotifications":[{"realmId":"4620816365171332690","dataChangeEvent":{"entities":[{"name":"Estimate","id":"148","operation":"Update","lastUpdated":"2021-07-12T18:09:32.000Z"}]}}]}"

How can I reach "id" parameter of the body?

{{a.body.eventNotifications.dataChangeEvent.entities.id}}

doesn't work...


------------------------------
Andrew S
------------------------------
Pipelines

1 Reply

Sort By
  • JeffPeterson1's avatar
    JeffPeterson1
    Qrew Captain
    3 years ago
    So does your pipeline look like this:

    A.  Incoming JSON
    B.  Iterate over JSON records
    C. Create Record

    You might be missing the B. step.   You need the 'Iterate over JSON records' step from the JSON handler in order to process the JSON for later steps.

    ------------------------------
    Jeff Peterson
    ------------------------------