Getting existing transactions

Arnaud Charlier · March 5

Hi there,
I am trying to figure out how to get all the transactions out of BBMS. I would have thought it was possible with the SKY API but I can't seem to find an endpoint that is not for creating a payment.

FYI, I am not a CRM or NXT or any other platform customer. Only BBMS. I seem to see that there's way to connect powerBI or poweapps but again not sure if also works for BBMS or not and if that would resolve my problem in some way.

Any way or guidance welcome…
Thanks!

Alex Wong · March 5

There is no API endpoint for getting a list of all transactions. You can only get ONE transaction at a time by providing a transaction id. Something I'm also waiting on.

Erik Leaver · March 5

@Arnaud Charlier Check out the Get Disbursement Transactions endpoint. It's in preview but I believe Plan has access to it.

You can also expect to see a Power Platform connector for the Payments API in the near future!

Alex Wong · March 5

@Erik Leaver nice!

Arnaud Charlier · March 5

Great! Thanks for the response, both. Is there anything that needs to be done to access the preview or is that automatically available?

Erik Leaver · March 5

@Arnaud Charlier I checked with the Payments team & they noted that Plan should have access to the preview.

Arnaud Charlier · March 5

@Erik Leaver I am getting this error when trying to hit the API
[api] status: 403

[error] Failed to fetch disbursements: 403 Client Error: Forbidden for url: https://api.sky.blackbaud.com/payments/v1/disbursements

I am trying to get the list of disbursements first as I don't think the ID is available in the UI, or not that I could see anyway.
Noting that my script retrieves a transaction just fine so I am pretty sure the app is configured properly.

Thanks!

Arnaud Charlier · March 6

some progress here, it seems that I must pass a config ID and that it is not optional as suggested by the documentation. I am now getting a 403 but with an actual error message that is coming from this Azure application gateway.

GET https://api.sky.blackbaud.com/payments/v1/disbursements?2687sdfg-9113-4123-8123-qws820c8bd4e
[api] status: 403

[error] Failed to fetch disbursements: 403 Client Error: Forbidden for url: https://api.sky.blackbaud.com/payments/v1/disbursements?2687sdfg-9113-4123-8123-fb7820c8xxxx
[error] Response body: <html>

<head><title>403 Forbidden</title></head>
<body>
<center><h1>403 Forbidden</h1></center>
<hr><center>Microsoft-Azure-Application-Gateway/v2</center>
</body>
</html>

Mina Mistry · March 6

Hi Arnaud -

I will email you directly to confirm we have the right SKY application approved for this endpoint.

Thanks

Mina

Alex Wong · March 6

@Erik Leaver I just tried the disbursement transaction endpoint and always get empty array back. That's with using the Get Account Configurations > Get Disbursement List to confirm the ID for both before issuing the disbursement transaction endpoint.

Erik Leaver · March 6

Hi @Alex Wong - We need to invite you to the preview. @Mina Mistry can you add Alex?

James Belich · May 5

@Erik Leaver I've trying to work with the Payments API in Power Automate - do I understand correctly from the above conversation that not everyone has access to this yet? (I'm getting "404 Resource Not Found" errors.)

Erik Leaver · May 5

@James Belich In your developer account, there are subscription options for the SKY APIs and the Payments API. You'll need to be subscribed to the Payments API to access it. Make sure you can get the result you want using the API "Try It" console before you start using the send http request in Power Automate.

Let me know if that clears it up.

James Belich · May 5

@Erik Leaver Thanks! I did subscribe to the Payments API and I'm able to get results using the "Try it" console, but the Send HTTP Request doesn't work in Power Automate. I'll start a new post with more details, but I wanted to double check that I should have access to API first.

Erik Leaver · May 5

@James Belich sounds like a good start. We've confirmed access and that the API works. Next up - figure out the issue in PA!

Arnaud Charlier · August 10

@Erik Leaver
That's been working OK for us, although the auth method has been somewhat unreliable in full automations.
The main issues we faced, though is that it's a up to 6 days behind. And that is despite having daily disbursement. Is there a way to retrieve all transactions instead of the disbursed ones? Or is it on a roadmap?

Mina Mistry · August 10

Hi Arnaud - the ability to request a set of transactions is not currently on the roadmap.

Can you share what your query criteria would be if this data was available via the API, such as example date ranges or other specific criteria requirements?

Thanks

Mina

Arnaud Charlier · August 11

Hi Mina,
Thanks for following up on my question!

The transactions I would want to query are those not yet disbursed in order to get a more up to date view of transactions. Especially useful at end of month to know where the month has finished ahead of waiting for disbursements for days.

So an example of query criteria would be as follow:
Disbursement status: Any
Date: between 01.07.26 amd 31.07.26

I'd be basically wanting to emulate what is possible in the UI filter as per below.

Hope that makes sense

Thanks,
Arnaud

Getting existing transactions

Answers

Categories