Power BI Connector for Shopify

Build 25.0.9454

RecurringApplicationCharges

Stores subscription billing records for apps, including plan details, trial periods, status, and recurring amounts.

Columns

Name Type ReadOnly References Description
Id [KEY] Long False

The unique numeric identifier for the recurring application charge.

Name String False

The name or label assigned to the recurring application charge.

ApiClientId String False

The unique identifier of the API client that created the recurring application charge.

Price Decimal False

The recurring charge amount billed to the merchant. The maximum allowed value is 10,000.

Status String False

The current status of the recurring charge. Typical values include pending, active, cancelled, and expired.

ReturnUrl String False

The URL where the merchant is redirected after accepting the charge.

BillingOn Date False

The date when the customer is billed for the recurring charge.

Test String False

Indicates whether this is a test transaction. Valid values: true or null.

CreatedAt Datetime False

The date and time (ISO 8601 format) when the recurring application charge was created.

UpdatedAt Datetime False

The date and time (ISO 8601 format) when the recurring application charge was last updated.

ActivatedOn Datetime False

The date and time (ISO 8601 format) when the recurring application charge was activated by the customer.

CancelledOn Datetime False

The date and time (ISO 8601 format) when the recurring application charge was cancelled by the merchant.

TrialDays Int False

The number of free trial days the customer is eligible for before billing begins.

TrialEndsOn Datetime False

The date and time (ISO 8601 format) when the free trial period ends.

DecoratedReturnUrl String False

The return URL decorated with additional query parameters for context or validation after charge acceptance.

CappedAmount String False

The maximum amount the customer can be billed for usage-based charges within the billing period. Must be defined if usage-based billing is enabled.

ConfirmationUrl String False

The URL where the merchant is directed to accept or decline the recurring application charge.

Terms String False

The terms and conditions that describe the usage-based billing agreement. Required when CappedAmount is specified.

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