Integrations

PayPal datasets and fields

The 5 datasets Maven lands from PayPal, every field in them, and how the connection syncs.

Maven lands 5 datasets from PayPal in each client workspace. This page lists every one with all of its fields. For the metrics, reports and setup steps, see the PayPal integration page.

Connection and sync#

You connect PayPal with client ID and client secret from the PayPal account. Maven stores them encrypted.

The first PayPal sync pulls the most recent 30 days so the workspace fills quickly. A follow-up backfill then adds older history, up to 3 years in total. After that, each scheduled sync re-reads the last 3 days, so late changes are picked up.

Datasets#

Accounts#

Current PayPal reporting account identity, capability status, and sync metadata.

FieldType
account IDText
account nameText
default currencyText
timezoneText
livemodeTrue/false
transactions availableTrue/false
balances availableTrue/false
disputes statusText
transaction countInteger
balance currency countInteger
dispute countInteger
last refreshed atTimestamp

Balances#

PayPal per-currency total, available, and withheld balances at the requested reporting time.

FieldType
dateDate
account IDText
account nameText
currencyText
is primaryTrue/false
total balanceNumber
available balanceNumber
withheld balanceNumber
as of atTimestamp
last refreshed atTimestamp

Transactions#

PayPal transaction ledger including completed, pending, denied, reversed, fee, transfer, and balance activity.

FieldType
dateDate
transaction row keyText
transaction IDText
account IDText
account nameText
paypal account IDText
payer account IDText
payer emailText
payer given nameText
payer surnameText
payer country codeText
payer statusText
payer address statusText
invoice IDText
cart invoice IDText
reference IDText
reference ID typeText
event codeText
event groupText
statusText
subjectText
transaction noteText
payment tracking IDText
bank reference IDText
custom fieldText
currencyText
gross amountNumber
fee amountNumber
net amount after feeNumber
discount amountNumber
insurance amountNumber
sales tax amountNumber
shipping amountNumber
shipping discount amountNumber
shipping tax amountNumber
other amountNumber
tip amountNumber
ending balanceNumber
available balanceNumber
credit transactional feeNumber
credit promotional feeNumber
payment method typeText
instrument typeText
instrument sub typeText
decline codeText
protection eligibilityText
shipping methodText
shipping cityText
shipping stateText
shipping country codeText
store IDText
terminal IDText
tax inclusiveTrue/false
incentive typeText
incentive codeText
incentive program codeText
incentive amountNumber
incentives jsonText
initiated atTimestamp
updated atTimestamp
item countInteger

Transaction items#

Product details passed by the merchant to PayPal for each account-qualified transaction.

FieldType
dateDate
transaction row keyText
transaction IDText
account IDText
account nameText
event codeText
item indexInteger
item codeText
item nameText
item descriptionText
quantityNumber
unit priceNumber
item amountNumber
total item amountNumber
discount amountNumber
adjustment amountNumber
gift wrap amountNumber
basic shipping amountNumber
extra shipping amountNumber
handling amountNumber
insurance amountNumber
tax percentageNumber
tax amountNumber
item options jsonText
currencyText
invoice numberText

Disputes#

Optional PayPal dispute summaries when the connected REST app has the Disputes feature.

FieldType
dateDate
account IDText
account nameText
dispute IDText
reasonText
statusText
dispute stateText
lifecycle stageText
channelText
amountNumber
currencyText
outcome codeText
seller response due atTimestamp
buyer response due atTimestamp
created atTimestamp
updated atTimestamp