Tips and tricks for searching, IQL, and integrations

Impira allows you to immediately extract the data you need from your files and there’s a lot more additional functionality that allows you to automate more of your workflow.

Tip #1: Searching

Use the search bar to construct easy free text searches of your records as well as more complex queries. You can quickly search within a specific Collection as well as across all your files from any Collection.

By default, those queries will search all types of information about your records including file names, the text content of your files, and any fields that you’ve added. You can also use the Impira Query Language (IQL) to run more precise searches across specific fields.

Tip #2: Analyze your data with IQL

Impira Query Language (IQL) also allows you to manipulate and analyze your data. IQL’s Excel-like functions allow you to perform actions such as adding or concatenating different fields, counting the number of words in each document, and seeing which records are past a manual “review by” date.

You can run those queries as on-the-fly queries or save them as computed fields in your collection. You can even aggregate and analyze your data with Pivots: The IQL equivalent of Pivot Tables in Excel.

An example of an IQL query

Tip #3: Auto-organize your files with Smart Collections

You can use manually created Collections to organize your files by hand. However, you can use Smart Collections to automate how files get assigned to your Collections. For each Smart Collections, you define a query to populate that Collection. Any new files that you add to your organization that match that query will then be automatically assigned to that Collection.

For example, if you're processing forms which always have the text “IX920” on the document, you can easily set up a Smart Collection to route all files that match that text to the same Collection. You can always manually add files to your Smart Collection if they don’t match the query for any reason.

Read this guide to set up your Smart Collection.

Tip #4: Further automate your workflow with integrations

Many of our users automate their whole workflow by dragging and dropping files directly into the platform and downloading the data as a CSV.

Partner integrations: Snowflake and Zapier

Send files to Impira from your Snowflake warehouse and back again with the Impira x Snowflake integration. Unlock and organize unstructured data stored in your warehouse and stream it back into Snowflake for analysis. Read more.

You can also use Zapier to connect Impira to thousands of apps. This Zapier integration allows you to incorporate Impira into the workflows you use every day without skipping a beat. Read more.

Email integration

You can upload data into Impira via email as attachments, body text, or a combination of both. Read more.


Upload files and write data using Impira’s Write API. Query that data by using Impira Query Language (IQL).

These interactions allow you to programmatically add files to Impira and export data directly to where it needs to go. With these integrations in place, you can easily use Impira as your organization’s document processing clearinghouse.

© 2023 Impira Inc. All rights reserved. This site is built with Motif.