Filtering

Some GoFormz API's support a filtering syntax that is similar to OData. The filtering syntax is supported when a "filter" query string parameter is described in the endpoint documentation.

Logical Operators

Note: The logical operators are Case-Sensitive

Operator

Definition

Description

eq

Equals

The eq operator returns true if the left operand is equal to the right operand, otherwise it returns false.

ne

Not Equals

The ne operator returns true if the left operand is not equal to the right operand, otherwise it returns false.

gt

Greater Than

The gt operator returns true if the left operand is greater than the right operand, otherwise it returns false.

ge

Greater Than or Equal

The ge operator returns true if the left operand is greater than or equal to the right operand, otherwise it returns false.

lt

Less Than

The lt operator returns true if the left operand is less than the right operand, otherwise it returns false.

le

Less Than or Equal

The le operator returns true if the left operand is less than or equal to the right operand, otherwise it returns false.

and

And

The and operator returns true if both the left and right operands evaluate to true, otherwise it returns false.

or

Or

The or operator returns false if both the left and right operands both evaluate to false, otherwise it returns true.

Logical Operator Examples

📘

Dates

Dates will use Coordinated Universal Time (UTC), eg. 2021-12-08T08:00:00Z

  • Include timezone offset, if necessary.
// all forms with a lastUpdatedDate greater than January 1st, 2015 (00:00 UTC time)
https://api.goformz.com/v2/formz?filter=lastupdateddate gt 2015-01-01

// all forms with a lastUpdatedDate greater than January 1st, 2015
// indcluding time
https://api.goformz.com/v2/formz?filter=lastupdateddate gt 2015-01-01T03:01:01

// all forms with a lastUpdatedDate greater than January 1st, 2015
// in PST timezone (-08:00 offset)
https://api.goformz.com/v2/formz?filter=lastupdateddate gt 2015-01-01T08:00:00

// all forms with a lastUpdatedDate greater than January 1st, 2015 
// and a lastUpdatedDate less than January 1st, 2016
https://api.goformz.com/v2/formz?filter=lastupdateddate gt 2015-01-01 and lastupdateddate lt 2015-01-01

//This will kept all forms for January 1, 2015 on PST time (-8:00 offset)
https://api.goformz.com/v2/formz?filter=lastupdateddate gt 2015-01-01T08:00:00Z and lastupdateddate lt 2015-01-01T08:00:00Z