I can't filter on a custom field

[Mike_Gallucci]

Hi, I have an Api call that returns two custom fields. I need to filter on custom field 1 as seen in image:

But when I open the filters window, I can only see custom filed 2 to filter on:

Why is custom field 1 not available to filter on?

Thanks!
Mike

[Stob_AI]

Hey @Mike_Gallucci

The custom field 1 not available because it is a array either you have iterate the array using Array aggregator or you have to use Get Map Functions to get it.

[samliew]

Welcome to the Make community!

You can use the built-in functions map and get (or first) to access variables within an array.

e.g.:

{{ first(map(9.custom_field; "DefinitionId"; "Stringvalue"; "Awaiting Fufillment")) }}

For more information, see the function documentation in the Help Center, and complete the Make Academy as it is explained in further detail there.

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 —

Getting Started

• Help Centre | Tutorials – Make “Manual”
• Make Academy – Basics 101: Learn Make and get certified

Help Centre 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
• Date Format: 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 setup and use OpenAI (ChatGPT) in Make
• How to use Regex in Make - How to use pattern matching to extract the text you want
• Webhooks – Make Academy – tutorial on how to use Webhooks

Hope this helps! Let me know if there are any further questions or issues.

— @samliew

P.S.: Investing some effort into the Make Academy will save you lots of time and frustration using Make.