nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Payment information API

Dennis Pulido

What is the transaction_ID on the Payments API? I'm trying to get some of the payment information that is previously on the transactional database Gift record that is no longer on the Gift API.

Any advice would be greatly appreciated.

Find more posts tagged with

Comments

Mina Mistry

Hi Dennis

Thanks for your question - can you provide some additional information to help pinpoint the data you are looking for?

If a gift in RE NXT has been processed via BBMS, the gift record in RE NXT (via the Gift API) will reference the transaction ID for BBMS. That transaction ID can be used to query payment data from the Payments API.

Are you working with a set of gift records in RE NXT that you'd like to retrieve payment information for? Let us know an example of what you're looking for so we can provide some additional help.

Thanks

Mina

Dennis Pulido

Hi Mina,

Thanks for the info. To confirm, the payment has to be made by BBMS service in order for the transaction ID to appear on the Gift API record? What if another service was used? Will that other service payment record get stored on the payment API? We are moving from Raiser Edge to NXT platform. So the payment information is currently stored on the Gift table.

I've pulled up a historic record via gift record API that was processed via credit card but was unable to find "transaction_id" on the Gift API string, just the payment method

Gift API. Most likely has not been processed by BBMS.


"payments": [<br/>    {<br/>      "payment_method": "CreditCard"<br/>    }

Thanks,

Dennis

Mina Mistry

Hi Dennis

The SKY Payments API will allow you to retrieve and process payments for BBMS transactions only. It does not support any other processor that you may have used through Raiser's Edge.

I have confirmed that Raiser's Edge does not store the Transaction ID which is why you are not seeing that value returned from the API. RE NXT however will store the Transaction ID for any new payments made going forward.

Thanks

Mina

Ralph Rebacz

Mina,

In Raisers Edge there was a field on the gift table called Credit_type which indicated the credit card type used for payment (Visa, MasterCard, etc). There was also a field on Gift called PROCESSEDBYEFT which indicated if the card was processed in Raisers Edge I believe. Is this information available in NXT for non BBMS transactions? We import payments from Classy and NetCommunity that are not processed by BBMS and we currently use IATS for transactions within Raisers Edge. If we could get the credit card type and the ProcessedBYEFT flag for all transactions I think that would meet our needs.

Thanks

Anthony Gallo

Ralph, PROCESSEDBYEFT translates to IsElectronic on the GiftPayment contract which is not currently available in the API unfortunately.

Ralph Rebacz

Is the credit card type, which used to be stored on Gift.Credit_type available in the API for payments not made through BBMS?

Anthony Gallo

Some fields are not present because they could be used to reverse engineer private account data for users. Credit Card type might be something we see again down the road but unsure of the timeline there.