Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Boolean search inside attachments - 2023 update?

Topic Labels: Data Extensions Integrations
1500 3
cancel
Showing results for 
Search instead for 
Did you mean: 
Vikram
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi Folks,

We have one or more attachments (pdf, docx mostly) per record, and want to run a Boolean search on the content of these documents. This is similar to how you can search in Google Drive, Dropbox etc.

@kuovonne I saw some of your suggested workaround. Do you know if Airtable or any extensions / integrations have done this seamlessly?

Thanks in advance,

Vikram

3 Replies 3
Stephen_Orr1
10 - Mercury
10 - Mercury

I'm not aware of any native ability to read the contents of an attachment but this could be done with Airtable scripting. You can use a somewhat hacky method with eval() to import external libraries that can do these things and parse the result in your base.

kuovonne
18 - Pluto
18 - Pluto

Airtable scripting cannot look directly inside pdf or doc attachments. It can look at plain text files. 

I suggest looking into third party services that can perform searches into the file types you want (or that can extract text into plain text format).

Vikram
5 - Automation Enthusiast
5 - Automation Enthusiast

Thanks folks. I'm exploring a two step process.

 

Step 1: Use the relevant 3rd party tool to extract the Data in a structured format (e.g. Google Sheets).

Step 2: Use Zapier to push a new record in Aortab