Power BI Connector for PayPal

Build 24.0.9060

DisputeDetails

PayPal merchants, partners, and external developers can use the PayPal Disputes API to manage disputes.

Table Specific Information

Select

This view returns a list of disputes with detailed information for the authenticated user.

The following filters are supported by the PayPal API:

  • DisputeId

The connector processes other filters client side within the connector.

For example, the following queries are processed server side.

  • The following query retrieves details for a specific Dispute:
    SELECT * FROM DisputeDetails WHERE DisputeId = 'PP-D-12345'

Columns

Name Type References Description
DisputeId [KEY] String The ID of the dispute.
CreatedTime Datetime The date and time when the dispute was created.
UpdatedTime Datetime The date and time when the dispute was updated.
Status String The status of the dispute.

The allowed values are OPEN, WAITING_FOR_BUYER_RESPONSE, WAITING_FOR_SELLER_RESPONSE, UNDER_REVIEW, RESOLVED, OTHER.

Reason String The reason for the item-level dispute.

The allowed values are MERCHANDISE_OR_SERVICE_NOT_RECEIVED, MERCHANDISE_OR_SERVICE_NOT_AS_DESCRIBED, UNAUTHORISED, CREDIT_NOT_PROCESSED, DUPLICATE_TRANSACTION, INCORRECT_AMOUNT, PAYMENT_BY_OTHER_MEANS, CANCELED_RECURRING_BILLING, PROBLEM_WITH_REMITTANCE, OTHER.

DisputeState String The state of the dispute.

The allowed values are OPEN_INQUIRIES, REQUIRED_ACTION, REQUIRED_OTHER_PARTY_ACTION, UNDER_PAYPAL_REVIEW, APPEALABLE, RESOLVED.

DisputeCurrencyCode String The three-character ISO-4217 currency code that identifies the currency.
DisputeAmountValue Decimal The value of the amount.
ExternalReasonCode String The code that identifies the reason for the credit card chargeback.
DisputeOutcomeCode String The outcome of a resolved dispute.
DisputeOutcomeAmountRefundedCode String The three-character ISO-4217 currency code that identifies the currency.
DisputeOutcomeAmountRefundedValue Decimal The value of the amount.
DisputeLifecycleStage String The stage in the dispute lifecycle.
DisputeChannel String The channel where the customer created the dispute.
OfferType String The merchant-proposed offer type for the dispute.
BuyerRequestedAmountCode String The three-character ISO-4217 currency code that identifies the currency.
BuyerRequestedAmountValue Decimal The value of the amount.
BuyerResponseDueDate Datetime The date and time by when the customer must respond to the dispute.
SellerOfferedAmountCode String The three-character ISO-4217 currency code that identifies the currency.
SellerOfferedAmountValue Decimal The value of the amount.
SellerResponseDueDate Datetime The date and time by when the seller must respond to the dispute.
Email String The email address that is provided by the merchant where the customer can share the evidences.
Note String The merchant provided notes that are visible to both the customer and PayPal.
TimePosted Datetime The date and time when the contact details were posted.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060