SSIS Components for Shopify

Build 25.0.9434

Disputes

Lists chargeback and dispute cases related to the shop.

View-Specific Information

Select

The component uses the Shopify API to process WHERE clause conditions built with the following columns and operators. The component processes other filters client-side within the component.

  • Id supports the '=, IN' comparison operators.
  • Status supports the '=, !=' comparison operators.
  • InitiatedAt supports the '=, <, >, >=, <=' comparison operators.

For example, the following queries are processed server-side:

  SELECT * FROM Disputes WHERE Id = 'Val1'
  SELECT * FROM Disputes WHERE Status = 'Val1'
  SELECT * FROM Disputes WHERE InitiatedAt = '2023-01-01 11:10:00'

Columns

Name Type References Description
Id [KEY] String The globally unique identifier of the dispute.
LegacyResourceId String The identifier of the corresponding resource in the REST Admin API.
EvidenceDueBy Date The deadline by which evidence must be submitted for the dispute.
EvidenceSentOn Date The date when evidence was submitted. Returns null if no evidence has been sent.
Status String The current status of the dispute, such as open, under review, or closed.
Type String Indicates whether the dispute is still in the inquiry stage or has escalated to a chargeback.
FinalizedOn Date The date when the dispute was resolved. Returns null if the dispute has not been finalized.
InitiatedAt Datetime The date and time when the dispute was initiated.
Amount Decimal The disputed amount, expressed as a decimal money value.
AmountCurrencyCode String The currency code of the disputed amount.
OrderId String The globally unique identifier of the order associated with the dispute.
ReasonDetailsReason String The reason for the dispute as provided by the cardholder's bank.
ReasonDetailsNetworkReasonCode String The raw reason code returned by the payment network.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434