Power BI Connector for Shopify

Build 25.0.9454

ShopifyPaymentsAccountDisputes

Displays dispute records tied to a Shopify Payments account, including resolution outcomes and evidence links.

View-Specific Information

Select

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

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

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

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

Columns

Name Type References Description
Id [KEY] String A globally unique identifier for the dispute record within Shopify Payments.
LegacyResourceId String The identifier corresponding to the same dispute resource in the REST Admin API for backward compatibility.
ShopifyPaymentsAccountId String

ShopifyPaymentsAccount.Id

The globally unique identifier of the Shopify Payments account associated with the dispute.
EvidenceDueBy Date The deadline date by which all supporting evidence must be submitted to contest the dispute.
EvidenceSentOn Date The date when evidence was submitted to the payment network. Returns null if no evidence has been sent yet.
Status String The current state of the dispute, such as 'needs_response', 'under_review', 'won', or 'lost'.
Type String Indicates whether the dispute is in the initial inquiry stage or has escalated to a formal chargeback.
FinalizedOn Date The date when the dispute was officially closed or resolved. Returns null if the case is still pending.
InitiatedAt Datetime The timestamp indicating when the dispute was first opened by the cardholder or issuing bank.
AmountAmount Decimal The total disputed amount, represented as a decimal money value.
AmountCurrencyCode String The three-letter ISO currency code corresponding to the disputed transaction amount (for example, USD or GBP).
OrderId String The globally unique identifier of the Shopify order linked to the disputed transaction.
ReasonDetailsReason String The explanation or reason provided by the cardholder's bank for the dispute, such as 'fraudulent' or 'product_not_received'.
ReasonDetailsNetworkReasonCode String The network-specific code provided by the payment processor or card network representing the dispute reason.

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