API Filters
Has anyone been able to successfully get the built in filters to work for the list gifts? I need to be able to use the “Added on or after” filter. I have tested many different time formats, but have not been successful in getting the outputs to change.
In the example below, my gift list has 51 gifts received this year. I only want to retrieve gifts that were added in the last 24 hours. Only 1 of the 51 gifts in the list has been added in the last 24 hours. If the filter was working correctly, the output of the connector should result in 1, not 51.
According to this, the time format should be ISO-8601 format, which I have matched exactly.

Below is the output of running the automation. I have highlighted the single gift time that I was expecting to receive with this query, however all 51 gifts are counted for in the output. Every other “date_added” time in the output is from before the requested filter time.

I have also tested with trying to filter to one specific constituent ID that exists in that gift list, the results still output all 51 gifts. Am I missing anything or are these filter options broken for the API?
Comments
-
Hey @Dan Evans, so the List Gift action allows for either list name OR filter parameters, not both. If you populate a list you're pulling from NXT, the API call will ignore all filtering parameters listed.
0 -
@Dan Evans Hey Dan, I create the gift list with the date parameter set to Last week (or another relative date criteria) and pull it through the API to get the most recent gifts. Then no need to use the API filter.
0 -
@Dan Evans
As mentioned by Matt, the List Gift will not filter based on other parameters when you already have a “list” selected.What you want to do is, use the “list” selected (without any other parameters), then use a Filter array data action to filter the returned list of gifts on the date added field.
0 -
@Alex Wong
Thank you all for your assistance with this. I was not aware that it was an either or for the list filters. I appreciate you diagraming out this filter array option. I have successfully tested it and it is working in my environment.0
Categories
- All Categories
- 6 Blackbaud Community Help
- 206 bbcon®
- 1.4K Blackbaud Altru®
- 394 Blackbaud Award Management™ and Blackbaud Stewardship Management™
- 1.1K Blackbaud CRM™ and Blackbaud Internet Solutions™
- 15 donorCentrics®
- 357 Blackbaud eTapestry®
- 2.5K Blackbaud Financial Edge NXT®
- 646 Blackbaud Grantmaking™
- 561 Blackbaud Education Management Solutions for Higher Education
- 3.2K Blackbaud Education Management Solutions for K-12 Schools
- 934 Blackbaud Luminate Online® and Blackbaud TeamRaiser®
- 84 JustGiving® from Blackbaud®
- 6.4K Blackbaud Raiser's Edge NXT®
- 3.6K SKY Developer
- 242 ResearchPoint™
- 118 Blackbaud Tuition Management™
- 165 Organizational Best Practices
- 238 The Tap (Just for Fun)
- 33 Blackbaud Community Challenges
- 28 PowerUp Challenges
- 3 (Open) Raiser's Edge NXT PowerUp Challenge: Product Update Briefing
- 3 (Closed) Raiser's Edge NXT PowerUp Challenge: Standard Reports+
- 3 (Closed) Raiser's Edge NXT PowerUp Challenge: Email Marketing
- 3 (Closed) Raiser's Edge NXT PowerUp Challenge: Gift Management
- 4 (Closed) Raiser's Edge NXT PowerUp Challenge: Event Management
- 3 (Closed) Raiser's Edge NXT PowerUp Challenge: Home Page
- 4 (Closed) Raiser's Edge NXT PowerUp Challenge: Standard Reports
- 4 (Closed) Raiser's Edge NXT PowerUp Challenge: Query
- 778 Community News
- 2.9K Jobs Board
- 53 Blackbaud SKY® Reporting Announcements
- 47 Blackbaud CRM Higher Ed Product Advisory Group (HE PAG)
- 19 Blackbaud CRM Product Advisory Group (BBCRM PAG)

