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

OperatorDefinitionDescription
eqEqualsThe eq operator returns true if the left operand is equal to the right operand, otherwise it returns false.
neNot EqualsThe ne operator returns true if the left operand is not equal to the right operand, otherwise it returns false.
gtGreater ThanThe gt operator returns true if the left operand is greater than the right operand, otherwise it returns false.
geGreater Than or EqualThe ge operator returns true if the left operand is greater than or equal to the right operand, otherwise it returns false.
ltLess ThanThe lt operator returns true if the left operand is less than the right operand, otherwise it returns false.
leLess Than or EqualThe le operator returns true if the left operand is less than or equal to the right operand, otherwise it returns false.
andAndThe and operator returns true if both the left and right operands evaluate to true, otherwise it returns false.
orOrThe 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