SSIS Components for PayPal

Build 24.0.9060

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 component processes other filters client side within the component.

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.

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.

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