Skip to main content

Build a Transaction Feed

Overview​

Financial account activity is recorded in the Highnote ledger. To build a transaction feed for your account holders, query a financial account to return its account activity and associated ledgers.

Building transaction feeds against a financial account ensures financial account activity carries across all payment cards associated with the financial account.

Prerequisites​

View financial account activity​

Note the following when querying for financial account activity:

  • For financial accounts with no activities: The Highnote API returns four specific ledgers, CASH, AVAILABLE_CASH, CREDIT_OUTSTANDING, AVAILABLE_CREDIT.
  • For financial accounts with activities: The Highnote API only returns ledgers that have at least one activity on them.

Use the following query to return financial account activity:

FindFinancialAccount​
Query
query FindFinancialAccount(
  $id: ID!
  $firstActivities: Int
  $activitiesAfterCursor: String
) {
  node(id: $id) {
    __typename
    ... on FinancialAccount {
      __typename
      id
      financialAccountActivities(
        first: $firstActivities
        after: $activitiesAfterCursor
      ) {
        pageInfo {
          hasNextPage
          hasPreviousPage
          startCursor
          endCursor
        }
        edges {
          cursor
          node {
            __typename
            sign
            isComplete
            pendingAmount {
              value
              currencyCode
            }
            postedAmount {
              value
              currencyCode
            }
            createdAt
            source {
              ... on DebitTransaction {
                __typename
                id
                transactionEvents {
                  __typename
                  ... on Node {
                    id
                  }
                  ... on AuthorizationEvent {
                    merchantDetails {
                      category
                      name
                    }
                  }
                  ... on IssuerPreliminaryAuthorizationEvent {
                    merchantDetails {
                      category
                      name
                    }
                  }
                  ... on ClearingEvent {
                    merchantDetails {
                      category
                      name
                    }
                  }
                  ... on BalanceInquiryEvent {
                    merchantDetails {
                      category
                      name
                    }
                  }
                  ... on VerificationEvent {
                    merchantDetails {
                      category
                      name
                    }
                  }
                  ... on AuthorizationAndClearEvent {
                    merchantDetails {
                      category
                      name
                    }
                  }
                  ... on ReversalEvent {
                    merchantDetails {
                      category
                      name
                    }
                  }
                }
              }
              ... on CreditTransaction {
                __typename
                id
                transactionEvents {
                  __typename
                  ... on Node {
                    id
                  }
                  ... on AuthorizationEvent {
                    merchantDetails {
                      category
                      name
                    }
                  }
                  ... on IssuerPreliminaryAuthorizationEvent {
                    merchantDetails {
                      category
                      name
                    }
                  }
                  ... on ClearingEvent {
                    merchantDetails {
                      category
                      name
                    }
                  }
                  ... on BalanceInquiryEvent {
                    merchantDetails {
                      category
                      name
                    }
                  }
                  ... on VerificationEvent {
                    merchantDetails {
                      category
                      name
                    }
                  }
                  ... on AuthorizationAndClearEvent {
                    merchantDetails {
                      category
                      name
                    }
                  }
                  ... on ReversalEvent {
                    merchantDetails {
                      category
                      name
                    }
                  }
                }
              }
            }
          }
        }
      }
    }
  }
}
Variables
{
  "id": "FINANCIAL_ACCOUNT_ID"
}
⚠️ Please login to execute queries. Visit the dashboard to authenticate.
Result
{
  "data": {
    "node": {
      "__typename": "FinancialAccount",
      "id": "FINANCIAL_ACCOUNT_ID",
      "financialAccountActivities": {
        "pageInfo": {
          "hasNextPage": false,
          "hasPreviousPage": false,
          "startCursor": "dD0yM...hYmY",
          "endCursor": "dD0yM...hYmY"
        },
        "edges": [
          {
            "cursor": "dD0yM...hYmY",
            "node": {
              "__typename": "FinancialAccountActivity",
              "sign": "NEGATIVE",
              "isComplete": true,
              "pendingAmount": {
                "value": 0,
                "currencyCode": "USD"
              },
              "postedAmount": {
                "value": 0,
                "currencyCode": "USD"
              },
              "createdAt": "2022-12-02T03:14:37.892Z",
              "source": {
                "__typename": "DebitTransaction",
                "id": "TRANSACTION_ID",
                "transactionEvents": [
                  {
                    "__typename": "ReversalEvent",
                    "id": "TRANSACTION_EVENT_ID",
                    "merchantDetails": {
                      "category": "MISCELLANEOUS_SPECIALTY_RETAIL",
                      "name": "WALGREENS"
                    }
                  },
                  {
                    "__typename": "AuthorizationEvent",
                    "id": "TRANSACTION_EVENT_ID",
                    "merchantDetails": {
                      "category": "MISCELLANEOUS_SPECIALTY_RETAIL",
                      "name": "WALGREENS"
                    }
                  }
                ]
              }
            }
          }
        ]
      }
    }
  },
  "extensions": {
    "requestId": "REQUEST_ID"
  }
}