Join us October 22nd to hear Coglate-Palmolive, IDC, and Sequoia Capital discuss moving to a digital-first environment
Learn more

Customize your data exports with IQL

Impira Query Language (IQL) was created to make it easy for users to search, filter, and transform data. Our recent overhaul of the IQL Playground makes querying easier than ever, while giving you a few more bells and whistles.

Subscribe to Impira's blog
Stay up to date with all things Impira, automation, document processing, and industry best practices.

IQL: Our not-so-secret sauce

Two of our core values here at Impira are boldness and growth. These two seemingly simple words drive so much of our decision-making. We push ourselves and those around us to think outside the box and be better than we were yesterday. One result of this level of innovative thinking drove the development of our very own query language called Impira Query Language, or IQL. 

Most intelligent document processing solutions give you one or maybe two options for what your data looks like. The first being a near-exact replica of what it looked like coming in and the other involves the use of APIs or webhooks to send data to another tool. 

Our users have always asked for more ways to customize the output of their data, which means this is probably something that would make life easier and at the end of the day, that’s what we’re all about. This is how IQL was born. 

With IQL, you have the ability to customize how data is formatted for other downstream systems. IQL can be used for advanced queries within the Impira UI, to power a custom field on a Collection, or to query data over the API.

Is this just another name for SQL?

Nope. Unlike Structured Query Language (or SQL), IQL was built specifically to query unstructured data. This means you get the same power as SQL, but without writing a lengthy and complex query to get you what you need. 

For example, imagine you were a retailer that made a large order to a manufacturer and now you need to extract all information about eye glasses so you can understand your profit and loss for the year. 

If you were writing SQL to pull data from invoices, it might look like this:

SELECT

  *

FROM

  Invoices,

WHERE

  EXISTS (SELECT 1 FROM 

            unnest(Invoices.Lineitems) v(value) 

            WHERE v.Item='Glasses')


But with IQL, your query is much more streamlined: @Invoices Lineitems.Item:Glasses

You can also use IQL to perform a quick reconciliation from documents within a Collection to catch errors. For example, if you want to make sure that the subtotal and tax on an invoice added up to the stated total, you can write an expression that looks like: Subtotal + Tax = Total.

Read more about how to apply these queries.

Our shiny and new IQL Playground

The IQL Playground is where users can slice and dice data in a number of different ways. The demand for IQL and the creative ways our customers were using the IQL Playground has taken us by surprise. The Playground’s popularity pushed us to focus harder on overhauling it to create the best possible user experience. 


The IQL Playground now includes a much larger window for authoring IQL queries and provides support for multiple queries in the editor, syntax highlighting, and semantic autocomplete (using the schema of the data).

If you’re ready to jump in, learn more about how IQL can give you the control you never knew you needed over unstructured data.

Want to customize how your data enters Impira, or find specific information from within your Collections? Reach out to us about anything at community@impira.com


Customize your extracted data today