When querying an Infusionsoft table in Grow, you have to do a little work to specify a date range. This article will show you how to do that.

Once you have selected to use the table query, go ahead and use the blue Select Columns button to decide what columns to show. You do not need the dates column in order to use the date interpolator.

To use Infusionsoft’s date interpolator, you will need to add a Where Clause. Below your selected columns is a section for Where Clauses.

Go ahead and press the white + button on the right side.

The Where Clause has two fields: the Column and the Value. A where clause is essentially a filter where x = value

In the Column field, select whichever column has the dates. If you start typing the name of the column in the Column field, it will bring up a list of available columns to choose from for that table.

The Value portion works very similarly to Grow’s date interpolator, with some exceptions:

  • The entire value portion needs to be surrounded in single apostrophes, ’such as this.’
  • The operator is surrounded by tildes, like this: ~>~.
  • The time value includes seconds, in addition to minutes and hours.

For example, to get anything within the last month, I would make this the value:
'~>~ {{date('-1months','YYYY-MM-DD 00:00:00')}}'

This value includes single apostrophes surrounding the entire value ' ' , the greater than operator > surrounded by tildes, and the time in HH:MM:SS format.

Infusionsoft also describes on their documentation what parameters are available for querying:

You can also find more information on Infusionsoft’s API docs here.

Once you have entered in your query, press the blue Connect button.

And that’s it! 

Questions? Chat in on the site and we’ll be happy to help.

Did this answer your question?