Power BI Connector for PayPal

Build 24.0.9062

Disputes

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 for the authenticated user.

The following filters are supported by the PayPal API:

  • DisputeId
  • DisputeState
  • CreateTime

The CreateTime filter supports the >, >=, <, <=, and = operators, while the other filters only support the = operator.

The 本製品 processes other filters client side within the 本製品.

For example, the following queries are processed server side.

  • The following query retrieves details for a specific dispute:
    SELECT * FROM Disputes WHERE DisputeId = 'PP-D-12345'
  • The following query returns details for Dispute records created after the specified date:
    SELECT * FROM Disputes WHERE CreateTime > '2016-01-01'

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.

使用できる値は次のとおりです。OPEN, WAITING_FOR_BUYER_RESPONSE, WAITING_FOR_SELLER_RESPONSE, UNDER_REVIEW, RESOLVED, OTHER

Reason String The reason for the item-level dispute.

使用できる値は次のとおりです。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.

使用できる値は次のとおりです。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.

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