API Filters

Dan Evans

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?

Matt Thacker

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.

Bob Raymond

@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.

Alex Wong

@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.

Dan Evans

@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.