Retrieve multiple documents urls from airtable attachement trough watch record (and not the first one only)

How To
1

What are you trying to achieve?

Hello community,
I’m quite new on make and after some unsuccessful searches, I’m asking for help:

My automation starts with an Airtable Watch Record
→ Inside the record I have attachments that are images or pdf
---->Those documents then passe through OCR (google vision) for further needs

What is working :white_check_mark:: from airtable watch record, I do see listed the documents attached (and the URL I need to get)
What I failed to get :x: : from google cloud vision (our other module like http get a file to dowload the document), I can only retrieve the first document data listed by Airtable watch record

I’ve seen aggregation option regarding bundles, but nothing within the bundle

Last info: the number of attachments vary from a record to another

Any insight?
thanks for your time!

Screenshots: scenario setup, module configuration, errors

screen01.png
screen01.png673×871 55.8 KB

screen2.png
screen2.png1453×762 150 KB

2

Hello @Arnaud2,
Welcome to the community.

Current Solution

You just need to use Iterator and Aggregator to fix this.
→ Need to add an Iterator before Google Cloud Vision. But an Iterator only takes an Array as input.
→ Use that Document URL array as input of Iterator and then use Array value as input of Google Cloud Vision.

Other Possibilities Explanation

Summary

→ Airtable Watch Records always returns single or multiple bundles. It depends on how many records are added/modified. Right now in your example, it’s just a single record is there.
→ But If you think there will be multiple records, then you need to understand the nature of bundles, Iterators and how to use Array Aggregator with it.
→ For that possibility you need to first aggregate all Watch Records and then Iterate it.
→ If this is not a case right now then just forget it.

:bulb:P.S.: Always search first, Check Make Academy. If this is helpful, Mark Best Answers as Solutions :white_check_mark: and give :+1: If you need expert help or have questions? Contact or comment below! :point_down:

2 Likes
3

Thank you dilipborad for your time on my case :pray:

I first failed using iterator and aggregator

But thanks to your guidance I tried again with only the iterator and get it to work properly

Now all attachments from the record are getting processed

screen3
screen3902×659 39 KB