# Filtering Json Data

**URL:** <https://community.make.com/t/filtering-json-data/38314>\
**Category:** Beginner Questions\
**Tags:** arrays, filters\
**Created:** [May 21, 2024, 7:07pm UTC](https://community.make.com/t/filtering-json-data/38314 "2024-05-21T19:07:52Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![gdp](https://avatars.discourse-cdn.com/v4/letter/g/a5b964/32.png) [@gdp](https://community.make.com/u/gdp)\
**Post date:** [May 21, 2024, 7:07pm UTC](https://community.make.com/t/filtering-json-data/38314/1 "2024-05-21T19:07:52Z")

</div>

Hi!!

I am new with Make and i can´t the answer to this problem:

I am using google Document api to parse invoice document.

Using a http call i get a json ( here output sample: [https://storage.googleapis.com/cloud-samples-data/documentai/SampleDocuments/INVOICE\_PROCESSOR/pretrained-invoice-v2.0-2023-12-06\_output.json](https://storage.googleapis.com/cloud-samples-data/documentai/SampleDocuments/INVOICE_PROCESSOR/pretrained-invoice-v2.0-2023-12-06_output.json))

The output json classify the data using “type” data. For example , type:“invoice\_id” give you the invoice id. type:“line\_item” is the data which correspond to one of the lines of the invoice document.

My question is, how can i get only the collection of data which correspond to type:“line\_item” .

Using a iterator compont i want to add the data to my airtable file.

Thanks for your help.

---

<div class="post-metadata">

**Author:** ![samliew](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/samliew/32/13327_2.png) [@samliew](https://community.make.com/u/samliew)\
**Post date:** [May 22, 2024, 3:29am UTC](https://community.make.com/t/filtering-json-data/38314/2 "2024-05-22T03:29:22Z")

</div>

Welcome to the Make community!

Iterate the `entities` array, and filter by type.

 ![Screenshot_2024-05-22_132829](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/2/e/2ec237e1637489a24b2d618996a0db82f1341dac.png)

[samliew](https://samliew.com/services) – [request private consultation](https://samliew.com/request-quote?ServiceType=Automation%20Consultation&Referrer=Make)

> Join the unofficial [Make Discord server](https://samliew.com/make-discord-invite) to chat with other makers!

---

<div class="post-metadata">

**Author:** ![gdp](https://avatars.discourse-cdn.com/v4/letter/g/a5b964/32.png) [@gdp](https://community.make.com/u/gdp)\
**Post date:** [May 23, 2024, 5:14pm UTC](https://community.make.com/t/filtering-json-data/38314/3 "2024-05-23T17:14:56Z")

</div>

Thank you!!! Solved. But now, i receive an erro 422 ( airtable ) “cannot accept the provided value”

I do like this:

{{parseNumber(get(map(31.properties; “mentionText”; “type”; “line\_item/amount”); 1); “,”)}}

And my field type is number

Where is the problem

---

<div class="post-metadata">

**Author:** ![samliew](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/samliew/32/13327_2.png) [@samliew](https://community.make.com/u/samliew)\
**Post date:** [May 23, 2024, 11:33pm UTC](https://community.make.com/t/filtering-json-data/38314/4 "2024-05-23T23:33:47Z")

</div>

No problem, glad I could help!

1. If you have a new question in the future, please **start a new thread**. This makes it easier for others with the same problem to search for the answers to specific questions, and you are more likely to receive help since newer questions are monitored closely.

2. The [Make Community guidelines](https://community.make.com/t/make-community-the-ultimate-topic/11682) encourages users to try to **mark helpful replies as solutions** to help keep the Community organized.

This marks the topic as solved, so that:

- others can _save time_ when catching up with the latest activity here, and
- allows others to _quickly jump to the solution_ if they come across the same problem

To do this, simply **click the checkbox** at the bottom of the post that answers your question:  
 ![Screenshot_2023-10-04_161049](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/5/d/5d9b26fbef0fd7385a34084f61cd5b9165786f42.png)

3. Don’t forget to like and **bookmark** this topic so you can get back to it easily in future!

4. Do **join** the unofficial [Make Discord server](https://samliew.com/make-discord-invite) for live chat and video assistance

[samliew](https://samliew.com/services) – [request private consultation](https://samliew.com/request-quote?ServiceType=Automation%20Consultation&Referrer=Make)

> Join the unofficial [Make Discord server](https://samliew.com/make-discord-invite) to chat with other makers!

---

<div class="post-metadata">

**Author:** ![Make\_Bot](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/make_bot/32/14661_2.png) [@Make\_Bot](https://community.make.com/u/Make_Bot)\
**Post date:** [June 7, 2024, 5:49am UTC](https://community.make.com/t/filtering-json-data/38314/5 "2024-06-07T05:49:03Z")

</div>

This topic was automatically closed because it's resolved or inactive. Please, start a new topic.


