List Contact Filters

Retrieve all contact filters for an organization

Contact Filter Fields

FieldData Type (Length)Required?Read OnlyNotes
idlongnxThe internal ID for a contact filter. It is visible on the URI in the UI.
namestring (100)yThe name of the filter.
contactFilterTypestringnConstant ContactRule.
contactFilterRulescontactFilterRule[]yAn array of contactFilterrules.
createdDatelongnxUnix epoch date/time when the filter was created.
createdIdlongnxInternal ID of the user that created this filter.
createdNamestringnxFirst and last name of the user that created this filter.
lastModifiedDatelongnxUnix epoch date/time when the filter was last modified.
lastModifiedIdlongnxThe internal ID of the user that last modified this filter.
lastModifiedNamestringnxThe first and last name of the user that last modified this filter.
lastModifiedTimelongnxUnix epoch date/time when the filter was last modified.
lastSynchronizedTimelongnxUnix epoch date/time when the filter was last synchronized.
accountIdlongnxThe ID of the account that owns this resource.
statusstringnxThe status of the object. All records returned by the API should have a status of 'A' indicating that the record is active and has not been deleted.
Deleted records of any type are invisible to the API.
resourceBundleIdlongnxThe ID of the Role which owns this resource.
organizationIdlongnxThe ID of the organization to which this filter belongs.
dirtybooleannxWhether the contacts of this group have been updated and need to refresh map layer data.

Contact Filter Rule Fields

NameData Type (Length)Required?Description
idlongxThe internal ID for a contact.
contactFieldIdlongRequired if type is SYSTEM, SYSTEM_OBJECT or SYSTEM_ARRAY
columnNamestringRequired if type is SYSTEM, SYSTEM_OBJECT or SYSTEM_ARRAY
columnValueDepends on field type (string, date, number)Required if type is SYSTEM, SYSTEM_OBJECT or SYSTEM_ARRAY
attributeIdlongRequired if type is CUSTOM or CUSTOM_ARRAY
attributeValuesstring[]The values the filter is looking for. Required if type is CUSTOM or CUSTOM_ARRAY
typestringOne of:
◊ SYSTEM
◊ CUSTOM
◊ SYSTEM_OBJECT
◊ SYSTEM_ARRAY
◊ CUSTOM_ARRAY
◊ SYSTEM_SCHEDULING
◊ SYSTEM_EXPECTED_OBJECT
◊ SYSTEM_TRAVEL_SEGMENT_OBJECT
dataTypestringOne of:
◊ STRING
◊ NUMBER
◊ DATE
◊ BOOLEAN
operatorstringString
◊ STARTWITH
◊ ENDWITH (ends with)
◊ E (equal to)
◊ NE (not equal to)
◊ LIKE (contains)
◊ NLIKE (does not contain)
◊ GT (greater than)
◊ LT (less than)
◊ GTE (greater than or equal to)
◊ LTE (less than or equal to)

Number
◊ E (equal to)
◊ NE (not equal to)
◊ GT (greater than)
◊ LT (less than)
◊ GTE (greater than or equal to)
◊ LTE (less than or equal to)

Date field
◊ E (equal to)
◊ LT (is before)
◊ LTE (is equal to or before)
◊ GT (is after)
◊ GTE (is equal to or after)
◊ BETWEEN (between two dates)

Single select list
◊ E (equal to)
◊ NE (not equal to)

Multiple choice list
◊ IN (contains)
◊ NIN (does not contain)
contactFilteroptionstringSame as operator

Details below:

columnNamedataTypetypeoperatorembeddedColumnName
firstNameSTRINGSYSTEMSTARTWITH,ENDWITH,E,NE,LIKE,NLIKE
lastNameSTRINGSYSTEMSTARTWITH,ENDWITH,E,NE,LIKE,NLIKE
middleInitialSTRINGSYSTEMSTARTWITH,ENDWITH,E,NE,LIKE,NLIKE
suffixSTRINGSYSTEMSTARTWITH,ENDWITH,E,NE,LIKE,NLIKE
externalIdSTRINGSYSTEMSTARTWITH,ENDWITH,E,NE,LIKE,NLIKE
countrySTRINGSYSTEMSTARTWITH,ENDWITH,E,NE,LIKE,NLIKE
recordTypeIdNUMBERSYSTEME,NE,LT,LTE,GT,GTE
userIdNUMBERSYSTEMISNULL,NOTNULL
individualAccountIdNUMBERSYSTEMISNULL,NOTNULL
lastModifiedDateDATESYSTEMBETWEEN,LT,LTE,GT,GTE
lastModifiedNameSTRINGSYSTEMSTARTWITH,ENDWITH,E,NE,LIKE,NLIKE
registeredEmailSTRINGSYSTEMSTARTWITH,ENDWITH,E,NE,LIKE,NLIKE
registeredDateDATESYSTEMBETWEEN,LT,LTE,GT,GTE
groupsNUMBERSYSTEM_ARRAYIN,NIN
valueSTRINGSYSTEM_OBJECTSTARTWITH,ENDWITH,E,NE,LIKE,NLIKEpaths
locationNameSTRINGSYSTEM_OBJECTSTARTWITH,ENDWITH,E,NE,LIKE,NLIKEaddress
streetAddressSTRINGSYSTEM_OBJECTSTARTWITH,ENDWITH,E,NE,LIKE,NLIKEaddress
suiteSTRINGSYSTEM_OBJECTSTARTWITH,ENDWITH,E,NE,LIKE,NLIKEaddress
citySTRINGSYSTEM_OBJECTSTARTWITH,ENDWITH,E,NE,LIKE,NLIKEaddress
stateSTRINGSYSTEM_OBJECTSTARTWITH,ENDWITH,E,NE,LIKE,NLIKEaddress
postalCodeSTRINGSYSTEM_OBJECTSTARTWITH,ENDWITH,E,NE,LIKE,NLIKEaddress
countrySTRINGSYSTEM_OBJECTSTARTWITH,ENDWITH,E,NE,LIKE,NLIKEaddress
address.gisLocation.lonNUMBERSYSTEMISNULL,NOTNULL
addressGeoCodingSourceSTRINGSYSTEM_OBJECTIN,NINaddress
locationIdNUMBERSYSTEM_OBJECTE,NE,LT,LTE,GT,GTE
floorNoSTRINGSYSTEM_OBJECTSTARTWITH,ENDWITH,E,NE,LIKE,NLIKEaddress
floorNoSTRINGSYSTEM_OBJECTSTARTWITH,ENDWITH,E,NE,LIKE,NLIKElastKnownLocation
address.streetAddressBOOLEANSYSTEMISNULL,NOTNULL
gisLocation.latNUMBERSYSTEM_OBJECTE,NE,LT,LTE,GT,GTEaddress
gislocation.lonNUMBERSYSTEM_OBJECTE,NE,LT,LTE,GT,GTEaddress
pathIdNUMBERSYSTEM_OBJECTIN,NINpaths
createdDateDATESYSTEMBETWEEN,LT,LTE,GT,GTE
topicsNUMBERSYSTEMIN,NIN
systemRequirementSTRINGSYSTEM_OBJECTSTARTWITH,ENDWITH,E,NE,LIKE,NLIKEpaths
calendarNUMBERSYSTEM_SCHEDULINGE
shiftNUMBERSYSTEM_SCHEDULINGE
shiftDateDATE*SYSTEM_SCHEDULINGBETWEEN
ssoIdentitySTRINGSYSTEMSTARTWITH,ENDWITH,E,NE,LIKE,NLIKE
smUserIdNUMBERSYSTEMISNULL,NOTNULL
expectedDateDATE*SYSTEM_EXPECTED_OBJECTBETWEEN,LT,LTE,GT,GTE, BETWEEN
locationNameSTRINGSYSTEM_EXPECTED_OBJECTSTARTWITH,ENDWITH,E,NE,LIKE,NLIKEaddress
citySTRINGSYSTEM_EXPECTED_OBJECTSTARTWITH,ENDWITH,E,NE,LIKE,NLIKEaddress
stateSTRINGSYSTEM_EXPECTED_OBJECTSTARTWITH,ENDWITH,E,NE,LIKE,NLIKEaddress
countrySTRINGSYSTEM_EXPECTED_OBJECTSTARTWITH,ENDWITH,E,NE,LIKE,NLIKEaddress
iataSTRINGSYSTEM_EXPECTED_OBJECTSTARTWITH,ENDWITH,E,NE,LIKE,NLIKEaddress
locationIdSTRINGSYSTEM_EXPECTED_OBJECTE,NE,LT,LTE,GT,GTEaddress
expatriateNUMBERSYSTEMISNULL,NOTNULL
vipNUMBERSYSTEMISNULL,NOTNULL
isTravelBOOLEANSYSTEM_EXPECTED_OBJECTEaddress
postalCodeSTRINGSYSTEM_EXPECTED_OBJECTSTARTWITH,ENDWITH,E,NE,LIKE,NLIKEaddress
gislocation.lonNUMBERSYSTEM_EXPECTED_OBJECTE,NE,LT,LTE,GT,GTEaddress
gisLocation.latNUMBERSYSTEM_EXPECTED_OBJECTE,NE,LT,LTE,GT,GTEaddress
travelTypeSTRINGSYSTEM_EXPECTED_OBJECTLIKE,NLIKEaddress
supplierSTRINGSYSTEM_EXPECTED_OBJECTSTARTWITH,ENDWITH,E,NE,LIKE,NLIKEaddress.expectedLocationSegments
travelDateDATESYSTEM_TRAVEL_SEGMENT_OBJECTE,BETWEEN
airRailCodeAndNoSTRINGSYSTEM_TRAVEL_SEGMENT_OBJECTSTARTWITH,ENDWITH,E,NE,LIKE,NLIKE
toLocation.localTravelStatusSTRINGSYSTEM_TRAVEL_SEGMENT_OBJECTE,NE
travelSegmentTypeSTRINGSYSTEM_TRAVEL_SEGMENT_OBJECTLIKE,NLIKE
toLocation.iataCodeSTRINGSYSTEM_TRAVEL_SEGMENT_OBJECTLIKE,NLIKE
fromLocation.iataCodeSTRINGSYSTEM_TRAVEL_SEGMENT_OBJECTLIKE,NLIKE
diStatusSTRINGSYSTEM_TRAVEL_SEGMENT_OBJECTLIKE,NLIKE
supplierNameSTRINGSYSTEM_TRAVEL_SEGMENT_OBJECTSTARTWITH,ENDWITH,E,NE,LIKE,NLIKE
toLocation.countryCodeSTRINGSYSTEM_TRAVEL_SEGMENT_OBJECTE,NE
fromLocation.countryCodeSTRINGSYSTEM_TRAVEL_SEGMENT_OBJECTE,NE
travelItinerary.startDateDATESYSTEM_TRAVEL_SEGMENT_OBJECTE,LT,LTE,GT,GTE
travelItinerary.endDateDATESYSTEM_TRAVEL_SEGMENT_OBJECTE,LT,LTE,GT,GTE

NOTE: columnValue(except sxpectedDate, shiftDate) depends on operator, if it is IN, NIN, BETWEEN, columnValue should be an array, otherwise as data type indicates.
expectedDate and shiftDate are special. Their value should be an array with three elements, and there are only two patterns: ["NOW",null,null] or ["BETWEEN", fromDate, toDate].
|

Error Messages

statusmessage
401Missing Organization Id
500Internal error
Language
Credentials
:
URL
Click Try It! to start a request and see the response here!