HTTP Request to Add Gift to Batch Not Responding

John Clarke

Hello Everyone,

I'm trying to use Power Automate to send an HTTP request to Raiser's Edge NXT (via the Blackbaud SKY API) to add gifts to an existing batch. However, the request does not respond and causes my flow to run indefinitely.

What I’m Trying to Do

I want to add a single gift to a batch using the "Send an HTTP Request" action from the Blackbaud SKY Add-in.

My HTTP Request Setup in Power Automate (Batch: 011)

{
"type": "OpenApiConnection",
"inputs": {
"parameters": {
"body/method": "POST",
"body/path": "/gift/v1/batches/011/gifts",
"body/headers": {
"Bb-Api-Subscription-Key": "MY_SUBSCRIPTION_KEY",
"Content-Type": "application/json"
},
"body/body": {
"batchGifts": [
{
"amount": { "value": 1 },
"gift_type": "Cash",
"constituent": { "id": "123456" }
}
]
}
},
"host": {
"apiId": "/providers/Microsoft.PowerApps/apis/shared_blackbaudskyaddins",
"connection": "shared_blackbaudskyaddins",
"operationId": "SendHttpRequest"
}
},
"runAfter": {}
}

Issue

• The flow runs indefinitely and never receives a response.
• I’ve checked Power Automate Run History, and there are no errors—just an ongoing request.

What I’ve Tried

• Verified API key and authentication → Using a valid subscription key and OAuth token.
• Sent a smaller request (without payments or splits) → Still no response.
• Added a timeout setting in Power Automate → Flow still hangs.

Questions

1. Has anyone successfully used Power Automate to add gifts to a batch?
2. Is there an issue with the /gift/v1/batches/{batch_id}/gifts endpoint?
3. Am I missing any required fields in my JSON code?

Any help would be greatly appreciated! Thank you.

Alex Wong

@John Clarke
I have added gift to batch without issue, so the API endpoint is not the problem

Your flow is not running indefinitly, however, it is likely doing the default “retry” which is 8 times and “exponentially” increase delay per retry, meaning it can take up to 25+ minutes to finish all 8 retries before it “fail” out.

So you need to change the retry, for now best to do No retry:

then is the problem with your API call:

• API doc on this endpoint: https://developer.sky.blackbaud.com/api#api=58bdd5edd7dcde06046081d6&operation=AddGiftsToBatch
• the URL path is /gift/v1/giftbatches/{batch_id}/gifts , but you have /gift/v1/batches/011/gifts
• is 011 the system record id for the webview gift batch that isn't approved yet?
  

if you open the batch in webview … in the URL is your system record id for the gift batch

• your JSON body for gift to create is also incorrectly done:
  • there is no “gift_type” of “Cash”, API for “Cash” is “Donation”, this is documented in the API doc link above
  • there is no “constituent” property and then “id” within it, instead it should be “constituent_id”
  • you are also missing a lot of fields, which “should” be required, though the documentation does say not required. (i.e. “date”, “gift_splits”)