Getting existing transactions

Arnaud Charlier
Arnaud Charlier
Name Dropper Facilitator 1
in Merchant Services APIs

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!

Answers

  • Alex Wong
    Alex Wong Community All-Star
    Tenth Anniversary Facilitator 5 Kudos 5 bbcon 2025 Attendee Badge

    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
    Erik Leaver Blackbaud Employee
    Tenth Anniversary Kudos 5 First Reply Name Dropper

    @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
    Alex Wong Community All-Star
    Tenth Anniversary Facilitator 5 Kudos 5 bbcon 2025 Attendee Badge

    @Erik Leaver nice!

  • Arnaud Charlier
    Arnaud Charlier
    Name Dropper Facilitator 1

    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
    Erik Leaver Blackbaud Employee
    Tenth Anniversary Kudos 5 First Reply Name Dropper

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

  • Arnaud Charlier
    Arnaud Charlier
    Name Dropper Facilitator 1

    @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
    Arnaud Charlier
    Name Dropper Facilitator 1

    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
    Mina Mistry Blackbaud Employee
    Seventh Anniversary Kudos 2 Name Dropper Participant

    Hi Arnaud -

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

    Thanks

    Mina

  • Alex Wong
    Alex Wong Community All-Star
    Tenth Anniversary Facilitator 5 Kudos 5 bbcon 2025 Attendee Badge

    @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
    Erik Leaver Blackbaud Employee
    Tenth Anniversary Kudos 5 First Reply Name Dropper

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

  • James Belich
    James Belich
    First Reply Kudos 1 First Anniversary Name Dropper

    @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
    Erik Leaver Blackbaud Employee
    Tenth Anniversary Kudos 5 First Reply Name Dropper

    @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
    James Belich
    First Reply Kudos 1 First Anniversary Name Dropper

    @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
    Erik Leaver Blackbaud Employee
    Tenth Anniversary Kudos 5 First Reply Name Dropper

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

Categories