Parse specific fields of a JSON

[Pedro_Rossa_Felicio]

Here is the current Json I have:

An array with a list of clients with TONS of useless information.

I want to be able to filter out only specific fields, like ‘id’ and ‘name’, so I can have the array of the 5 clients but each of them only having the fields ‘id’ and ‘name’.

Im triying to parse the JSON with this specif structure, but it simply doesn’t work. It parses the JSON correctly but with ALL the fields.

Any help would be appreciated!

[samliew]

Welcome to the Make community!

The simplest way to do this is by using an Iterator-Aggregator combo.

This will allow you to select only the “fields”/properties of the collection that you want.

Here are some useful links and guides you can use to learn more on how to use the Make platform, apps, and app modules. I found these useful when I was learning Make, and hope they might benefit you too —

General

• Help Center | Tutorials
• Make Academy – learn Make and get your certificate
• Discord Server – join us in live chat for fans of Make!

Help Center Basics

• Mapping – What is mapping? What can I map?
• Mapping with arrays – How to map items in an array
• Aggregate an array for mapping complex fields
• Tokens for parseDate | Tokens for formatDate
• HTTP modules – Make a request, Get (download) a file
• Webhooks – Error Handling, Responding to webhooks

Articles & Videos

• Router Magic Formula - YouTube
• Error Handlers in Make - YouTube playlist
• Getting started with OpenAI
• How to use Regex in Make

samliew – request private consultation

Join the Make Fans Discord server to chat with other makers!