Latest app improvements: Airtable

Categories: App Improvements
Latest app improvements: Airtable

This post is dedicated to providing updates on bug fixes, enhancements, and new features added to the Airtable <> Zapier Integration. Please refer to the comments below for the latest information changes.

New Feature! Find Record and Find Many Records searches can now do both fuzzy and exact-match searches 🆕 🎉

Previously, the Find Record and Find Many Records searches only did exact-match searches. This meant some searches wouldn’t find any records due to things like extra whitespace, searching for one specific value inside a multi-select field with multiple values selected, and other unexpected results. With a new “Search for Exact Match?” input field, you can choose whether you want to use an exact or fuzzy match for this search.

 

What This Means for You:

  • Increased Flexibility: Choose between exact or fuzzy match searches to suit your specific needs.
  • Improved Search Accuracy: Avoid missing records due to minor discrepancies like extra whitespace or multi-select field values.
  • Enhanced Data Retrieval: More effectively find and utilize the records you need by tailoring your search method.

 

Use Cases:

  • Data Cleanup: Use fuzzy searches to find records with minor inconsistencies for cleanup purposes.
  • Detailed Queries: Perform exact searches when you need precise results for reporting or analysis.
  • Enhanced Filtering: Retrieve records with varying levels of specificity to support different workflow requirements.

We've fixed the spike in "Invalid token" error messages 🐛🔧

The issue involved a spike in the error message: Trigger partner failure: The app returned "Invalid token."

 

Details:

Likely a byproduct of a migration of the Airtable integration’s usage of API keys to OAuth, some connections were getting this error from Airtable but still being marked as a “good” connection on Zapier’s side. These errors are now properly marking the Zapier connection as invalid so that you are appropriately prompted to re-connect.

 

What This Means for You:

  • Improved Connection Accuracy: Connections that encounter the "Invalid token" error will now be correctly marked as invalid.
  • Prompt Reconnection: You'll be appropriately prompted to re-connect, ensuring your integrations function smoothly.
  • Enhanced Reliability: Overall reliability of the Airtable integration is improved, reducing unexpected disruptions.

We've fixed the New Record and New or Updated Record triggers 🐛🔧

The New Record and New or Updated Record triggers encountered a Trigger partner failure due to response payload size exceeding maximum limits.

 

Details:

Depending on the size of your Airtable records, our systems were sometimes unable to handle the data size, resulting in errors. We've implemented a solution to programmatically reduce the number of records checked for new/updated records. This ensures that record sizes remain within our limitations, resolving the issue.

 

What This Means for You:

  • Improved Reliability: You can now rely on consistent performance of the New Record and New or Updated Record triggers without encountering payload size limitations.
  • Efficient Workflow: Automate processes involving Airtable records with confidence, knowing that trigger failures due to data size issues have been resolved.
  • Streamlined Operations: Reduce manual oversight as the system now manages record size programmatically, optimizing integration performance.