How can I check if a credit card has been used before?

[Viktor]

Question:

How can I check if a credit card has been used efore?

[Viktor · Accepted solution]

Answer:

1., API

By executing the following call using the last 4 digits of the CC number, you'll get all the possible results, and you can match the expiration date, month, and the cardholder name with similar cards:

<ns1:query>
<ns1:queryString>Select id, creditcardmasknumber,
CreditCardExpirationMonth,CreditCardExpirationYear,
CreditCardHolderName
from paymentmethod
where CreditCardMaskNumber = '************1111'
</ns1:queryString>
</ns1:query>

2., Export

You can also pull a Data Source Export from the UI by setting the Data Source to PaymentMethod, and selecting the same fields mentioned in the API call above. Again, the CCmasknumber, the expiry date & month and the cardholdername will help you identify the card.