Events filter Isupcoming doesn't work
Using the following base:
https://api.wildapricot.org/v2.1/Accounts/Events?
I can successfully list ALL events, or filter the list by Name using substringof, but...
The following filters don't work:
'$filter' => 'EndDate lt 2022-12-31'
'$filter' => 'IsUpcoming eq true'
'$filter' => 'IsUpcoming eq True'
What gives?
-
Paul commented
Encountered similar issue using the substringof function.
The website help page for Events Admin API Call (https://gethelp.wildapricot.com/en/articles/499), there is an example using the substringof function:
$filter=substringof('Name', 'training') eq true
However, I have not been able to get this syntax to work, it keeps returning an error. However, the following syntax works fine:
$filter=substringof('Name', 'training')
The problem is I would like to find all events that do not contain 'training' in their name, i.e., I would like to use the following syntax:
$filter=substringof('Name', 'training') eq false
Or:
$filter= NOT substringof('Name', 'training')
I understand that there is no 'NOT' function available for filter constructs.
Any suggestions on how I can exclude events that certain words?When I contacted Wild Apricot Tech Support, they responded with the following comment:
"Unfortunately, we're not equipped to answer specific questions regarding the use of WA's API, beyond what's found in the article. "