Hitting a 'GiftDateOutOfRangeCFAP' error when posting to /gift/v1/gifts

William Joseph

Hey folks,

We're in the process of building an integration between a donation form on our website and our Raiser's Edge NXT instance. The integration takes the form submission data, massages it in to the right shape, and then fires a payload at /gift/v1/gifts.

We're struggling a little bit with an error coming back from the API;

[{"message":"Gift date is invalid for appeal with ID 291.","error_name":"GiftDateOutOfRangeCFAP","error_code":25077,"raw_message":"Gift date is invalid for appeal with ID 291."}]

You can see a summary of the body data we are sending across, but it looks like we're formatting the date on the gift object correctly as an ISO-8601 date-time string (e.g. “2024-06-14T10:12:52+01:00”).

The fact that the error name suggests the date is “out of range” rather than flat invalid leads me to believe that it's not necessarily a date formatting issue but rather the related appeal has some validation rules in place where it doesn't want to accept the date we are sending?

Any pointers greatly received,

Thanks.

Summary of body payload and response follows:

The following API call to RENXT failed:

Method: POST

Endpoint: /gift/v1/gifts

Body:

• subtype : Gifts & Donations: Individuals
• type : Donation
• amount :
  • value : 10
• payments :
  • 0 :
    • payment_method : Cash
• constituent_id : 114132
• date : 2024-06-14T10:12:52+01:00
• reference : Stripe - Appeal
• acknowledgements :
  • 0 :
    • date : 2024-06-14T10:12:52+01:00
    • status : ACKNOWLEDGED
• custom_fields :
  • 0 :
    • category : Bank Statement Income Category
    • value : Stripe
    • date : 2024-06-14T10:12:53+01:00
    • comment : Website
  • 1 :
    • category : Month End Category
    • value : Bank Statement
    • date : 2024-06-14T10:12:53+01:00
    • comment : Website
  • 2 :
    • category : Transaction ID/Ref
    • value : ch_3PRWBlD8B8Wl5nLS11P2F5jw
    • date : 2024-06-14T10:12:52+01:00
    • comment : Website
  • 3 :
    • category : Website URL
    • value : https://royalfreecharity.ddev.site/get-involved/donate
    • date : 2024-06-14T10:12:52+01:00
    • comment : Website
  • 4 :
    • category : RFC Website Entry ID
    • value : 8895
    • date : 2024-06-14T10:12:52+01:00
    • comment : Website
  • 5 :
    • category : Website - Relationship to Trust
    • value :
    • date : 2024-06-14T10:12:52+01:00
    • comment : Website
  • 6 :
    • category : Website - Reason for donation
    • value : general
    • date : 2024-06-14T10:12:52+01:00
    • comment : Website
  • 7 :
    • category : Website - Type of donation
    • value : personal
    • date : 2024-06-14T10:12:52+01:00
    • comment : Website
• gift_splits :
  • 0 :
    • amount :
      • value : 10
    • appeal_id : 291
    • fund_id : 684
    • campaign_id : 22

--------------------

The following error occurred:

Client error: `POST https://api.sky.blackbaud.com/gift/v1/gifts?access_token=eyJhbGciOiJSUzI1NiIsImtpZCI6IjREVjZzVkxIM0FtU1JTbUZqMk04Wm5wWHU3WSIsInR5cCI6IkpXVCJ9.eyJhcHBsaWNhdGlvbmlkIjoiOTM5Y2VhMjEtOWJiMy00NjAwLWJhMmEtYzM2ZDFiM2RlZDNlIiwiZW52aXJvbm1lbnRpZCI6InAtbDNQNWhrY0dvMGFHeU1Oc1ljM3ZHQSIsImVudmlyb25tZW50bmFtZSI6IlJGQyAtIERFVkVMT1BNRU5UIiwibGVnYWxlbnRpdHlpZCI6InAtZUhvRnloVmNFMEdiZUQzWG1aaDdaUSIsImxlZ2FsZW50aXR5bmFtZSI6IlRIRSBST1lBTCBGUkVFIENIQVJJVFkiLCJtb2RlIjoiTGltaXRlZCIsInpvbmUiOiJwLWV1cjAxIiwibmFtZWlkIjoiODA4NmQ3Y2YtMzk0ZC00MmExLWFhZjYtMDIxYmJhNDhhZmU3Iiwic2NwIjpbInJueHQuciIsInJueHQudyIsInJueHQud2hrIiwicm54dC5kIl0sImp0aSI6IjgwMGI3ZDBkLTVjNGItNGJhZC05Zjk1LTc2MThiNDgzYzQwMyIsImV4cCI6MTcxODYxNjc2NCwiaWF0IjoxNzE4NjEzMTY0LCJpc3MiOiJodHRwczovL29hdXRoMi5za3kuYmxhY2tiYXVkLmNvbS8iLCJhdWQiOiJibGFja2JhdWQifQ.SswmXsfHhzshMYdjkhWghPZh--_04ZK-_onLr-wsGoHad6CserGAquvt5eQoTahA2k-OzzztHwbfckPvAUcgl4tl8GprWodjEPgtzvRhNaMm3IK3830u1bNJHnGqgMZ_7XLL4LGn6j59636boZa72s7x9cTEtpMUhJU2S9mPhd0JTsUC5VOnC-6UQ-vZieozohiOfMRkGSeKnr179-AOQFSfwOrlwhftK78M5Vd4sCPql6qUCYibKAGW4lS4QDPb1j7jVXsQBbKW_Bmow_pjQ0dRwSYzyTL37R2daj9_2CvGdtsF2Uc7Va7HZ9f0Oaopw03S19QG87xuKfC_PWNnZg` resulted in a `400 Bad Request` response: [{"message":"Gift date is invalid for appeal with ID 291.","error_name":"GiftDateOutOfRangeCFAP","error_code":25077,"raw (truncated...)

--------------------

The full API response body was:

[{"message":"Gift date is invalid for appeal with ID 291.","error_name":"GiftDateOutOfRangeCFAP","error_code":25077,"raw_message":"Gift date is invalid for appeal with ID 291."}]

--------------------

Alex Wong

@William Joseph
Appeal can have a start and end date on it, where if your gift date falls outside of that range, you will get the error as you have.

Secondly, not sure if it is an issue or not, but gift date, acknowledgement, custom field date, etc are all DATE only field, I always only provide the date portion (i.e. 2024-06-17) and works good.