Gift API to delete a gift failed on Pledge

Alex Wong · March 2022

Hi,

I have a problem deleting gift record using the Gift API via HTTP action on Power Automate.

I have a flow that runs every 8AM to check for a specific criteria of gifts that is set to be deleted (gift subtype of a DELETE value and GL Post Status of Not Posted). While it works perfectly on Cash gift, it seems to have issue deleting a Pledge. (the cash type gift is even one that is consider a “webview” gift that you would normally not be able to delete in database view. The pledge I'm having problem in deleting is created in database view and when the pledge gift is open in database view, the File > Delete menu is selectable.

Is there a problem or limitation on deleting a pledge?

By the way, the pledge is newly created incorrectly, there is no payment attached to the pledge, nor was the pledge “linked” to any registration or opportunity.

9e5eaf8f125ef41bc045e18244a92a16-huge-im

Alex Wong · March 2022

Not sure if the image is good enough:
HTTP status is 409

Message:
[

{

"message": "The requested operation could not be fulfilled",

"error_name": "RequestNotFulfilled",

"error_code": 409,

"raw_message": "The requested operation could not be fulfilled",

"error_args": []

}

]

Anthony Gallo · March 2022

Here is the list of what we check for to deny deletion:

Gift is a Pledge or Recurring Gift and the Origin field has a name value of either GiftV2API or API - INCORRECT AND UPDATED IN A RESPONSE
Gift has claimed gift aid
Gift has adjustments
Gift has matching gifts
Gift has a payment transaction id
Gift has been posted and has gl distributions
Gift is not NXT && (not a recurring gift || not a recurring gift payment) && not a pledge

Alex Wong · March 2022

What you just stated in your post differs from what the DELETE Gift API endpoint document.

If what you said is true, (which seems like it b/c I can't delete Pledge it seems), the DELETE Gift API endpoint documentation needs to be updated

7e12c678b4e86757672248766f5fbbeb-huge-im

Anthony Gallo · March 2022

We will double check the documentation on this but the main idea is that we only allow deletion for those gifts that we can tell came in from an external source and have no posting or transactional data applied. Those gifts must me marked manual so that they are not set to auto generate the payments (this is for RGs only, pledges can only be manual right now). Does the pledge you are trying to delete already have installments with payments or anything applied? Was it entered via api?

Gift is a MANUAL Pledge or Recurring Gift and the Origin field has a name value of either GiftV2API or API

Alex Wong · March 2022

the 4 pledges are manually entered and commmitted from a database view gift batch with no payment or write off. Like all pledges, they do have insteallments. It is not posted so no GL distribution. it is also not linked to registration or opportunuity

Anthony Gallo · March 2022

We do not currently allow any deletion of gifts entered via db view. For Pledges or RGs to be deleted using this endpoint they will have to be entered via API and have the is_manual flag set. At this moment this endpoint is just for deletion via APIs for integrations to handle “mistakes” and not meant to be something to use to delete any gift in the system.

Alex Wong · March 2022

ok, then let this be a request to have delete of gift that can be “normally” be deleted.

Thanks

Gift API to delete a gift failed on Pledge

Comments

Categories