Help Extracting Nested JSON Array to Save Value in Data Store

How To
, ,
1

Hi Make community,

I’m working on a scenario where I receive a form submission via webhook. The JSON contains a nested fields array, where each item includes a label, a type, and a value. In some cases, value is a simple string, but for dropdowns and multiple-choice fields, it contains IDs that need to be matched with the options array to get the human-readable text.

Here’s what I want to achieve:

  • Iterate through the fields array in the bundle.
  • For each item, extract the label.
  • For the value, if it’s a dropdown or multiple-choice type, I want to resolve the ID(s) into the corresponding text from the options array.
  • Save each resolvedValue in a Data Store.

Any suggestions on the best way to do this? A sample blueprint or a more elegant formula for resolving the value would be amazing.

Webhook payload output:
webhook_Payload.json (3.7 KB)

Thanks in advance!
AD

2

hi @AgileDude,

it seems like you are using the general webhook module?

If you use the Tally app, the webhook data is more easily transformed so you can better use it within Make! :slight_smile:

Best,
Richard