Import data into referral lists

You can import referral data into the Adyen payments platform to be placed on several referral lists used for fraud checks. The details can be listed in a CSV file where each line is prefixed by the type of referral data. Below you can find the different columns required per referral list:

Card

For card data the following columns are required:

Field Required Description
Fixed value: card (tick) Record type identifier.
merchantAccountCode

(tick)

The merchant account name.

cardNumber (tick) The card number.
description (tick)

 A description of the item, e.g. transaction ID of the original fraudulent transaction.

flag (tick)

You can perform the following actions:

  • trust
  • block
  • delete

SEPA

For card data the following columns are required:

Field Required Description
Fixed value: sepa (tick) Record type identifier.
iban (tick) IBAN of the bank account.
merchantAccountCode

(tick)

The merchant account name.

description (tick)

 A description of the item, e.g. transaction ID of the original fraudulent transaction.

flag (tick)

You can perform the following actions:

  • trust
  • block
  • delete

Shopper Name

For shopper data the following columns are required:

Field Required Description
Fixed value: shopperName (tick) Record type identifier.

merchantAccountCode

(tick)

The merchant account name.

shopperName (tick)

Name of the shopper.

description (tick)

 A description of the item, e.g. transaction ID of the original fraudulent transaction.

flag (tick)

You can perform the following actions:

  • trust
  • block
  • delete

Shopper Email

For shopper email data the following columns are required:

Field Required Description
Fixed value: shopperEmail (tick) Record type identifier.

merchantAccountCode

(tick)

The merchant account name.
shopperEmail (tick)

The shopper's email address.

description (tick)

A description of the item, e.g. transaction ID of the original fraudulent transaction.

flag (tick)

You can perform the following actions:

  • trust
  • block
  • delete

Shopper IP

For shopper IP the following columns are required:

Field Required Description
Fixed value: shopperIP (tick) Record type identifier.

merchantAccountCode

(tick)

The merchant account name.

shopperIP (tick)

The IP address the shopper used to carry out the transaction.

description (tick)

 A description of the item, e.g. transaction ID of the original fraudulent transaction.

flag (tick)

You can perform the following actions:

  • trust
  • block
  • delete

Shopper Reference

For shopper reference the following columns are required:

Field Required Description
Fixed value: shopperReference
(tick) Record type identifier.

merchantAccountCode

(tick)

The merchant account name.

shopperReference (tick)

A shopper's reference, which is the unique identifier for a shopper.

description (tick)

 A description of the item, e.g. transaction ID oforiginalfraudulent transaction.

flag (tick)

You can perform the following actions:

  • trust
  • block
  • delete

Shopper Address

For shopper address the following columns are required:

Field Required Description
Fixed value: shopperAddress (tick)   Record type identifier.
merchantAccountCode

(tick)

The merchant account name.

street (tick)

Street name.

houseNumberOrName (tick)

House number or name.

city (tick) Name of the city
postalCode (tick) Postal code.
stateOrProvince (tick) State or province name.
countryCode (tick) Country code
flag (tick)

You can perform the following actions:

  • trust
  • block
  • delete

Example file

The following is an example file with three lines of referral data:

card,YourMerchantAccount,4111111111111111,"Initial load, 2010-01-01",block
shopperName,YourMerchantAccount,"S. Hopper","Initial load, 2010-01-01",trust
shopperEmail,YourMerchantAccount,s.hopper@test.com,"Initial load, 2010-01-01",trust
shopperIP,YourMerchantAccount,201.44.22.11,"Initial load, 2010-01-01",block
shopperReference,YourMerchantAccount,YourMerchantReference,"Initial load, 2010-01-01",delete
shopperAddress,YourMerchantAccount,StreetName,58,Amsterdam, 2116 E,AMS,NL,trust