Setting the Gift Constituency for Gifts added to Gift Batch

Vincent Bailly

Hi,

How is the Gift constituency working in this operation “POST Gift (Batch)”?

From what I can see, it takes the constituent code from the Constituent, even though it exists in the Code Table and is specified in the body of the request:

{
"gifts": [
{
"amount": {
"value": "20.00"
},
"constituent_id": "591080",
"constituency": "Ami",
"date": "2024-11-29T20:19:17Z",
"gift_status": "Active",
"type": "Donation",
[…]
}
]
}

Many thanks,

Vincent

Alex Wong

@Vincent Bailly
I have not tested this but given how gift constituency works on gift record in DBV, you will need to make sure the constituency you trying to set is actually a constituent code that exists on the constituent record.

So in your example, you are trying to set the gift constituency to Ami, is Ami a constituent code on the constituent record with system record id 591080?

Vincent Bailly

@Alex Wong Yes, it is. I actually tried different scenarios before posting (with or without the code, adding the code to the Gift Table, changing the order, etc.).

When the code is set on the Constituent, I can see it as one of the available values in the Gift constituency field. Just so you know, I have not tried adding the Gift directly (not via a Batch).

Thanks,
Vincent

Alex Wong

@Vincent Bailly
Gift Code is not the same as Gift Constituency, they are 2 different field and uses 2 different table.

Vincent Bailly

The screenshot was too small…

Alex Wong

@Vincent Bailly
so are you trying to set gift_code or constituency of the gift?

Vincent Bailly

@Alex Wong Oh I see, that's confusing… I'd like to set the Gift Constituency, here:

Where are the Gift codes in the DBV? It seems clearer in the web view:

But, in the SKY API, the two properties are there (gift_code and constituency)… I'll do more testing tomorrow.

Thanks for your help!

Alex Wong

@Vincent Bailly

Check your RE config, maybe your org previously have the Gift code field disabled

Vincent Bailly

@Alex Wong Thanks, the Gift code field was indeed hidden and the code is added correctly via the SKY API operation Gift (Batch).

But the question remains for the Constituency field, I still can't override the default Constituent Code coming from the Constituent who made the Gift.

Alex Wong

@Vincent Bailly
I just tested this and have no problem

This is using the post gift to gift batch, then approving the gift batch gives me a gift with the constituency:

do you get any error in your API call to add to batch?

does your constituent has the constituency? if so, is it “expired”?

Vincent Bailly

@Alex Wong thank you for testing. There is no error and the Constituent has the constituency. Regarding the “expired”, Date From and Date To are empty, could it be the reason?

Also, in your test, does the Constituent have the value “New York” and is it the primary constituency?

FYI, I opened a case in the support, they could reproduce the fact that the value in the API body is not taken into account. I'll follow up here when I have some updates.

Thanks!

Alex Wong

@Vincent Bailly
You are right, New York is the primary constituent code on the record. I just tried a secondary code and it also does not work.

So this is a bug, and i'm glad Blackbaud acknowledged it and will fix it. Keep us posted.