Getting a 500 error when sending this to /gift/v1/gifts

William Joseph

Hey folks,

I'm wondering if anyone could help. I'm getting a generic 500 error when sending this payload to /gift/v1/gifts.

I've been through every item and I can't see anything that is malformed, or any required fields that are missing. Any values that are required to match to values in tables all seem to match (and would return an error if they didn't I assume).

Can anyone with a keen eye see anything wrong with the below?:

{
"subtype": "Gifts & Donations: Individuals",
"type": "Donation",
"amount": {
"value": 10
},
"payments": [
{
"payment_method": "Cash"
}
],
"constituent_id": "114134",
"date": "2024-06-26T12:49:42+01:00",
"reference": "Stripe - Appeal",
"acknowledgements": [
{
"date": "2024-06-26T12:49:42+01:00",
"status": "ACKNOWLEDGED"
}
],
"custom_fields": [
{
"category": "Bank Statement Income Category",
"value": "Stripe",
"date": "2024-06-26T12:50:30+01:00",
"comment": "Website"
},
{
"category": "Month End Category",
"value": "Bank Statement",
"date": "2024-06-26T12:50:30+01:00",
"comment": "Website"
},
{
"category": "Transaction ID/Ref",
"value": "ch_3PVuMsD8B8Wl5nLS0b7qHp1J",
"date": "2024-06-26T12:49:42+01:00",
"comment": "Website"
},
{
"category": "Website URL",
"value": "https://royalfreecharity.ddev.site/get-involved/donate",
"date": "2024-06-26T12:49:42+01:00",
"comment": "Website"
},
{
"category": "RFC Website Entry ID",
"value": 21897,
"date": "2024-06-26T12:49:42+01:00",
"comment": "Website"
},
{
"category": "Website - Relationship to trust",
"value": "I have no connection",
"date": "2024-06-26T12:49:42+01:00",
"comment": "Website"
},
{
"category": "Website - Reason for donation",
"value": "A general donation",
"date": "2024-06-26T12:49:42+01:00",
"comment": "Website"
},
{
"category": "Website - Type of donation",
"value": "personal",
"date": "2024-06-26T12:49:42+01:00",
"comment": "Website"
}
],
"gift_splits": [
{
"amount": {
"value": 10
},
"fund_id": "684"
}
]
}

Alex Wong

@William Joseph
first try again, there was a major issue yesterday with API.

then you want to check your custom fields, anything that is a table entry, you need to provide the table entry id, NOT the “text” of the entry.

then check your “id” and table entries. (i.e. fund id 684 exists and active? 114134 exists and is the constituent system record id? Gifts & Donations: Individuals is a table entry for gift subtype?)

William Joseph

check your custom fields, anything that is a table entry, you need to provide the table entry id, NOT the “text” of the entry.

Ah, this is almost certainly the issue.

So rather than sending the “value” value as;

{
"category": "Bank Statement Income Category",
"value": "Stripe",
"date": "2024-06-26T12:50:30+01:00",
"comment": "Website"
},

It needs to correlate to the ID of that item in the table, (for example);

{
"category": "Bank Statement Income Category",
"value": "2669",
"date": "2024-06-26T12:50:30+01:00",
"comment": "Website"
},

I can confirm if I omit our custom_fields array from the request, it goes through fine. So the error is definitely here somewhere. Will investigate and follow up, but I think you're onto a winner - thankyou.

Thomas Royal

@Alex Wong

To follow up on the API issue: is there a place where we can see historical information about issues and outages. We experienced this yesterday as well, and I'd like to provide formal information to our stakeholders.

Alex Wong

@Thomas Royal
https://status.blackbaud.com/

they keep some history, i don't know how long a history they keep though