List Gift Last Modified

Alex Wong

Hi,

I recently notice an issue (not sure if it always been like this) where I use the List Gift API with last modified date specified and expect to get gift last changed since 12hrs ago. This is to update my data warehouse of gift information. However, I added gift custom field onto a gift and then ran the api, and found out the gift I added custom field to did not show up. I also tried a few times after that after 10-15 minutes. Then when I go into database view and look at the gift record's property, it does not show that the gift have been updated by me recently.

I'm going to test this again but wanted to report this and see if others are seeing the same thing.

Dan Snyder

@Alex Wong I suspect that there is a separate date modified for the custom field itself that does not change the date last modified for the gift as a whole. It would seem that the date should update for both locations, but I would not be surprised if your further tests show the same behavior.

Alex Wong

@Dan Snyder
I am doing a review of my data warehouse and how to best optimize it to correctly represent the data that exist in RE, I remember I posted about this and found this post again.

I just did some additional checks and confirm that update to gift custom field DOES NOT update the gift record itself's last modified date, thereby making it impossible to use the Gift List with last modified to update my data ware house of informtion about the gift (including all gift custom field).

If this is a the intention of Blackbaud to make changes within a gift not be consider a change to the gift, (which I think is wrong), then what is Blackbaud's recommendation on how keep an external data warehouse correct with RE data? we have over 1M gift record with over 4M gift custom fields, it is not feasible to always run a FULL DUMP of the gift and everything related to gift (not with the frequency of every 4 hours we want to keep.

Not to mention that gift custom field deleted also doesn't trigger a “last modified” on anything (should trigger a last mofified on the gift itself in my opinion), it also does NOT have a webhook so I can react to the delete of gift custom field by removing the custom field from my data warehouse.

Any recommendation and suggestion will be greatly appreciated.

Thank you,

Alex