Why the shopifyPaymentsAccount return empty array in bankAccounts ptopery?

Why the shopifyPaymentsAccount return empty array in bankAccounts ptopery?

alexmyt
Visitor
1 0 0

Hi.

 

I have a Shopify Plus account with several stores. I need to make a report on payouts, in terms of stores and bank accounts to which payout were made.

 

I am using Admin GraphQL version 2025-4. To get a list of bank accounts and payouts for them, I make the following request:

 

query Payouts(
  $first: Int = 1,
  $after: String,
  $reverse: Boolean,
  $sortKey: PayoutSortKeys,
  $query:String
 ) {
  shopifyPaymentsAccount {
    id
    bankAccounts(first: 10) {
      nodes {
        id
        bankName
        accountNumberLastDigits
      }
    }
    payouts(
      first: $first,
      after: $after,
      reverse: $reverse,
      sortKey: $sortKey,
      query: $query
      ) {
      edges {
        cursor
        node {
          id
          bankAccount {
            id
            bankName
            accountNumberLastDigits
          }
          legacyResourceId,
          issuedAt
          net {
            amount
            currencyCode
          }
          status
          transactionType
        }
      }
      pageInfo {
        endCursor
        hasNextPage
      }
    }
  }
}

This query is behaving extremely strangely 😞

 

The BankAccount property of the payouts object is almost always null, except when we do not pass the query parameter to the request.

 

For most stores, the query returns the correct array of bank accounts in the BankAccounts property of the shopifyPaymentsAccount object. However, for one of the my stores, this object returns an empty array, nevertheless the fact that the billing account is configured correctly and there are payments to the bank account in the admin interface.

The application on whose behalf I am making the request has all the necessary rights, including read_shopify_payments_accounts and read_shopify_payments_bank_accounts.

Here is an example of a strange response to such a request:

{
    "data": {
        "shopifyPaymentsAccount": {
            "id": "gid://shopify/ShopifyPaymentsAccount/999005909****",
            "bankAccounts": {
                "nodes": []
            },
            "payouts": {
                "edges": [
                    {
                        "cursor": "eyJsYXN0X2lkIjoxMzk0OTUwODAzMTksImxhc3RfdmFsdWUiOjE3NDk1OTI3OTkwMDB9",
                        "node": {
                            "id": "gid://shopify/ShopifyPaymentsPayout/1394950****",
                            "bankAccount": null,
                            "legacyResourceId": "139495***",
                            "issuedAt": "2025-06-10T21:59:59Z",
                            "net": {
                                "amount": "щ.6",
                                "currencyCode": "EUR"
                            },
                            "status": "SCHEDULED",
                            "transactionType": "DEPOSIT"
                        }
                    }
                ],
                "pageInfo": {
                    "endCursor": "eyJsYXN0X2lkIjoxMzk0OTUwODAzMTksImxhc3RfdmFsdWUiOjE3NDk1OTI3OTkwMDB9",
                    "hasNextPage": true
                }
            }
        }
    }
 }

I would be grateful for any ideas: why is there no data in the paymenAccounts array?

Replies 0 (0)