Action list (All constituents) - Filter by Action Date and Category?

Tyler Stickney

New to the Sky API, and loving it so far! We need to retrieve lists of Actions that match a specific action date range and a specific action category (Meeting, Phone Call, etc.). We may have data that has been imported/added far after the actual action date, so using date_added to filter doesn't give good results. In the database view / query, we can filter exactly how we need to in this way to get exactly what we need, however I can't find a good solution through the SKY API other than grabbing a lot of extra data through lots of multiple API calls, and filtering it post retrieval. Has anyone ran into this business requirement, and found an efficient way of getting actions within a specific action date range, and/or of a specific category?

Cameron Hurst

@Tyler Stickney - did you ever solve this? I have the same issue for Gifts - wanna pull gifts by year but don't want to pull 5 years at a time when I only need 2018 ….

Alex Wong

@Cameron Hurst
may want to check out List v2 for Action

Tyler Stickney

@Alex Wong - This looks promising, thanks so much for the tip! I'm getting a 403 response back when I try it though. “This API is current in a private preview available to selected developers and ISV Partners.”. Any insight on how to get permission to hit these endpoints?

Alex Wong

@Tyler Stickney
reach out to your account rep