Get the value of a field from an object inside of an array

(0) Share

Report

Posted on by arodriguez107

I created a Flow where I'm using an HTTP request to query a data table. I'm getting a response back inside of a compose function, but I'm wondering how I get the value of a field by it's key?

So my compose is grabbing the Body of the HTTP request as an input, but I want to grab the value of the key "18" (637) inside of the "data" array.

Here's my output from the Compose function:

{
 "data": [
 {
 "3": {
 "value": 31
 },
 "9": {
 "value": "AAMkADQ4YTg5NmQ2LWE0NjQtNGFiZC1iNDMzLTVmMGUzYzVjNzhlYwBGAAAAAADYf4WxPqVyRZ2Tfm0B217jBwADr7S2HTh5RatNQgK7SDFcAAAAAAEMAAADr7S2HTh5RatNQgK7SDFcAABRtMUpAAA="
 },
 "18": {
 "value": 637
 }
 }
 ],
 "fields": [
 {
 "id": 3,
 "label": "Record ID#",
 "type": "recordid"
 },
 {
 "id": 9,
 "label": "Email Message ID Field",
 "type": "text"
 },
 {
 "id": 18,
 "label": "Related Ticket",
 "type": "numeric"
 }
 ],
 "metadata": {
 "numFields": 3,
 "numRecords": 1,
 "skip": 0,
 "totalRecords": 1
 }
}

Categories:

General topics

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

PowerBack19 679 on at

Like (1)

Report

@arodriguez107 - You can use a "Parse JSON" action after the HTTP request to get the Key/Value pairs. You can then use a "Filter Array" action to narrow down the results.

Was this reply helpful? Yes No