FENXT Payable Power Platform Connector

Ed Leiter
Ed Leiter
Ninth Anniversary Kudos 1 Name Dropper Participant
in Blackbaud Financial Edge NXT® General Discussions

I have setup a flow in power automate using the action "Update an Invoice" from the Blackbaud FENXT Payable connector. I am attempting to pay an invoice with a credit card. Payment method is "Credit Card". Card account ID is 17 as indicated in the URL. I am at a loss as to what Card ID should be. I cannot seem to locate the system record ID of the credit card from which the invoice should be paid. Where can I find the credit card system record ID? Only integers are permitted.

Comments

  • Kevin Brazell
    Kevin Brazell Blackbaud Employee
    Tenth Anniversary Kudos 5 First Reply Name Dropper
    44afc444ce428427e64894d5f668c49b-huge-im

    @Ed Leiter when looking in the actual GUI for a credit card account, the Card ID is a mixture of the last 4 digits of card number & Carholder's name , see the screen shot above from a sample database. I know that's been an issue with importing invoices for credit cards as the invoice import didn't have a field for the Card ID so you could tell FE which card paid the invoices, which is needed to save it as paid.


  • Ed Leiter
    Ed Leiter
    Ninth Anniversary Kudos 1 Name Dropper Participant

    @Kevin Brazell
    It appears that the credit card does not have a system record ID like there is for the Card account ID. If that is the case, then the only option is Card ID as revealed in the GUI which as you indicated is a mixture of the last 4 digits of the card number and the cardholder's name. The Card ID parameter in “Update an Invoice” action only permits integers. Entering in the alphanumeric Card ID as displayed in the GUI does not work because only integers are permitted. Is this a Blackbaud issue or a Microsoft issue? Why would the Card ID parameter even be there if it wasn't a possibility as part of the “Update an Invoice” action? When I saw that the Card ID was a parameter option in this connector, I thought this looks like a possible work around to the functionality missing in the import for paying an invoice by credit card.

  • Ed Leiter
    Ed Leiter
    Ninth Anniversary Kudos 1 Name Dropper Participant

    @Kevin Brazell
    Finally. Got a decent answer from support on obtaining the system record ID for a credit card on a credit card account. These are the instructions that were provided:

    Here are the steps provided to find the system record ID for credit card:

    To locate the specific ID for credit card fields within a credit card account, follow these steps using the SKY API reference tool:

    1. Sign in to the SKY API reference tool.
    2. Navigate to FENXT > Treasury > Endpoint Reference.
    3. Select [GET] Credit card accounts (List) and run it to find the credit_card_account_id.
    4. Use the credit_card_account_id from the previous step to select [GET] Credit cards (List) and run it. This will output all the cards and their credit_card_ids.

    Note: If the customer does not have a developer account, they will need to create one to use the API reference tool.

    I setup a developer account. Connected the SKY API Console from Marketplace and was able to obtain the system record ID for the credit card.

Categories