When you configure an export, import, other type of flow step using the prebuilt Chargebee connector, you can select any of the API operations listed below, organized by API type.
Note
If your API endpoint isn’t listed here, switch the flow step to HTTP mode and configure the endpoint provided in the Chargebee API documentation. You can also create a composite endpoint for this application in HTTP mode.
| Resource | API endpoint | Export | Import |
|---|---|---|---|
| Addresses | Retrieve an address | X | |
| Update an address | X | ||
| Attached items | Delete an attached item | X | |
| Retrieve an attached item | X | ||
| Update an attached item | X | ||
| Batch | Ingest usage events in batch | X | |
| Business entities | List business entity transfers | X | |
| Transfer a customer to another business entity | X | ||
| Cards | Retrieve card for a customer | X | |
| Comments | Create a comment | X | |
| Delete a comment | X | ||
| List comments | X | ||
| Retrieve a comment | X | ||
| Configurations | List site configurations | X | |
| Coupon codes | Archive a coupon code | X | |
| List coupon codes | X | ||
| Retrieve a coupon code | X | ||
| Coupon sets | Add coupon codes to coupon set | X | |
| Create a coupon set | X | ||
| Delete a coupon set | X | ||
| Delete unused coupon codes | X | ||
| List coupon sets | X | ||
| Retrieve a coupon set | X | ||
| Update a coupon set | X | ||
| Coupons | Copy a coupon | X | |
| Create a coupon for items | X | ||
| Delete a coupon | X | ||
| List coupons | X | ||
| Retrieve a coupon | X | ||
| Unarchive a coupon | X | ||
| Update a coupon for items | X | ||
| Credit notes | Create credit note | X | |
| Delete a credit note | X | ||
| Download e-invoice for credit note | X | ||
| Import credit note | X | ||
| List credit notes | X | ||
| Record refund for a credit note | X | ||
| Refund a credit note | X | ||
| Remove tax withheld refunds from a credit note | X | ||
| Resend failed e-invoice in credit notes | X | ||
| Retrieve a credit note | X | ||
| Retrieve credit note as PDF | X | ||
| Send an e-invoice for credit notes | X | ||
| Void a credit note | X | ||
| CSV tax rules | Taxes CSV import | X | |
| Currencies | Add a new currency | X | |
| Add schedule | X | ||
| List currencies | X | ||
| Remove schedule | X | ||
| Retrieve a currency | X | ||
| Update a currency | X | ||
| Custom field configs | List custom field configs | X | |
| Retrieve the metadata | X | ||
| Customers | Add contacts to a customer | X | |
| Assign payment role | X | ||
| Change billing date | X | ||
| Clear personal data of a customer | X | ||
| Collect payment for customer | X | ||
| Copy card | X | ||
| Create a customer | X | ||
| Create a quote for subscription creation | X | ||
| Create subscription for items | X | ||
| Delete a customer | X | ||
| Delete card for a customer | X | ||
| Delete contacts for a customer | X | ||
| Estimate for creating a subscription | X | ||
| Get account hierarchy for a customer | X | ||
| Get paginated account hierarchy for a customer | X | ||
| Import subscription for items | X | ||
| Link a customer to an account hierarchy | X | ||
| List customer entitlements | X | ||
| List customers | X | ||
| List of contacts for a customer | X | ||
| List vouchers for a customer | X | ||
| Merge customers | X | ||
| Move a customer | X | ||
| Record an excess payment for a customer | X | ||
| Retrieve a customer | X | ||
| Switch gateway | X | ||
| Unlink a customer from its parent account | X | ||
| Upcoming invoices estimate | X | ||
| Update a customer | X | ||
| Update account hierarchy access settings for a customer | X | ||
| Update billing info for a customer | X | ||
| Update card for a customer | X | ||
| Update contacts for a customer | X | ||
| Update payment method for a customer | X | ||
| Differential prices | Delete a differential price | X | |
| List differential prices | X | ||
| Retrieve a differential price | X | ||
| Update a differential price | X | ||
| Entitlements | List entitlements | X | |
| Manage entitlements for a feature | X | ||
| Estimates | Create a payment schedule estimate | X | |
| Create invoice for items estimate | X | ||
| Estimate for creating a customer and subscription | X | ||
| Estimate for updating a subscription | X | ||
| Gift subscription estimate for items | X | ||
| Events | List events | X | |
| Retrieve an event | X | ||
| Exports | Export attached items | X | |
| Export coupons | X | ||
| Export credit notes | X | ||
| Export customers | X | ||
| Export deferred revenue reports | X | ||
| Export differential price | X | ||
| Export invoices | X | ||
| Export item families | X | ||
| Export item prices | X | ||
| Export items | X | ||
| Export orders | X | ||
| Export price variants | X | ||
| Export revenue recognition reports | X | ||
| Export subscriptions | X | ||
| Export transactions | X | ||
| Retrieve an export | X | ||
| Features | Activate a feature | X | |
| Archive a feature | X | ||
| Create a feature | X | ||
| Delete a feature | X | ||
| List features | X | ||
| List item entitlements for a feature | X | ||
| Reactivate a feature | X | ||
| Retrieve a feature | X | ||
| Update a feature | X | ||
| §brand0§ert or remove item entitlements for a feature | X | ||
| Full exports | Retrieve full export status | X | |
| Gifts | Cancel a gift | X | |
| Claim a gift | X | ||
| Create a gift subscription for items | X | ||
| List gifts | X | ||
| Retrieve a gift | X | ||
| Update a gift | X | ||
| Hosted pages | Accept a quote | X | |
| Acknowledge a hosted page | X | ||
| Checkout charge items and one time charges | X | ||
| Checkout gift subscription for items | X | ||
| Claim a gift subscription | X | ||
| Collect now | X | ||
| Create a hosted page to view boleto vouchers | X | ||
| Create a pre cancel hosted page | X | ||
| Create checkout for a new subscription | X | ||
| Create checkout to update a subscription | X | ||
| Extend subscription | X | ||
| List hosted pages | X | ||
| Manage payment sources | X | ||
| Notify an event | X | ||
| Retrieve a hosted page | X | ||
| Retrieve direct debit agreement PDF | X | ||
| Update payment method | X | ||
| In app subscriptions | Import receipt | X | |
| Import subscription without receipt | X | ||
| Process purchase command | X | ||
| Retrieve store subscription | X | ||
| Invoices | Add a charge item to a pending invoice | X | |
| Add one time charge to a pending invoice | X | ||
| Apply credits for an invoice | X | ||
| Apply payment schedule scheme to an invoice | X | ||
| Apply payments for an invoice | X | ||
| Close a pending invoice | X | ||
| Collect payment for an invoice | X | ||
| Create invoice for items and one time charges | X | ||
| Delete an invoice | X | ||
| Delete line items | X | ||
| Download e-invoice | X | ||
| Import invoice | X | ||
| List invoices | X | ||
| List payment reference numbers | X | ||
| List payments for an invoice | X | ||
| List vouchers for an invoice | X | ||
| Pause dunning for invoice | X | ||
| Record an invoice payment | X | ||
| Record refund for an invoice | X | ||
| Record tax withheld for an invoice | X | ||
| Refund an invoice | X | ||
| Remove credit note from an invoice | X | ||
| Remove payment from an invoice | X | ||
| Remove tax withheld for an invoice | X | ||
| Resend failed e-invoice in invoices | X | ||
| Resume dunning for invoice | X | ||
| Retrieve an invoice | X | ||
| Retrieve invoice as PDF | X | ||
| Retrieve payment schedules for an invoice | X | ||
| Send an e-invoice for invoices | X | ||
| Stop dunning for invoice | X | ||
| Sync usages | X | ||
| Update invoice details | X | ||
| Void an invoice | X | ||
| Write off an invoice | X | ||
| Item families | Create an item family | X | |
| Delete an item family | X | ||
| List item families | X | ||
| Retrieve an item family | X | ||
| Update an item family | X | ||
| Item prices | Create a differential price | X | |
| Create an item price | X | ||
| Delete an item price | X | ||
| List applicable item prices for a plan item price | X | ||
| List applicable items for a plan item price | X | ||
| List item prices | X | ||
| Retrieve an item price | X | ||
| Update an item price | X | ||
| Items | Create an attached item | X | |
| Create an item | X | ||
| Delete an item | X | ||
| List attached items | X | ||
| List item entitlements for an item | X | ||
| List items | X | ||
| Retrieve an item | X | ||
| Update an item | X | ||
| §brand0§ert or remove item entitlements for an item | X | ||
| Non subscriptions | One time purchase | X | |
| Offer events | Create an offer event | X | |
| Offer fulfillments | Create an offer fulfillment | X | |
| Retrieve an offer fulfillment | X | ||
| Update an offer fulfillment | X | ||
| Omnichannel one time orders | List omnichannel one time orders | X | |
| Retrieve an one time order one time order | X | ||
| Omnichannel subscription items | List scheduled changes for omnichannel subscription item | X | |
| Omnichannel subscriptions | List omnichannel subscriptions | X | |
| List omnichannel transactions of an omnichannel subscription | X | ||
| Move an omnichannel subscription | X | ||
| Retrieve an omnichannel subscription | X | ||
| Orders | Assign order number | X | |
| Cancel an order | X | ||
| Create a refundable credit note | X | ||
| Create an order | X | ||
| Delete an imported order | X | ||
| Import an order | X | ||
| List orders | X | ||
| Reopen a cancelled order | X | ||
| Resend an order | X | ||
| Retrieve an order | X | ||
| Update an order | X | ||
| Payment intents | Create a payment intent | X | |
| Retrieve a payment intent | X | ||
| Update a payment intent | X | ||
| Payment schedule schemes | Create a payment schedule scheme | X | |
| Delete a payment schedule scheme | X | ||
| Retrieve a payment schedule scheme | X | ||
| Payment sources | Create a bank account payment source | X | |
| Create a card payment source | X | ||
| Create a voucher payment method | X | ||
| Create using Chargebee token | X | ||
| Create using gateway temporary token | X | ||
| Create using payment intent | X | ||
| Create using permanent token | X | ||
| Delete a payment source | X | ||
| Export payment source | X | ||
| List payment sources | X | ||
| Local delete a payment source | X | ||
| Retrieve a payment source | X | ||
| Switch gateway account | X | ||
| Update a bank account payment source | X | ||
| Update a card payment source | X | ||
| Verify bank account payment source | X | ||
| Payment vouchers | Create a voucher for the customer to initiate payment | X | |
| Retrieve voucher data | X | ||
| PC2 migration item families | Create a PC2 migration item family | X | |
| Delete draft family | X | ||
| List PC2 migration item families | X | ||
| Retrieve a PC2 migration item family | X | ||
| Update a PC2 migration item family | X | ||
| PC2 migration item prices | Delete draft item price | X | |
| List PC2 migration item prices | X | ||
| Retrieve a PC2 migration item price | X | ||
| Update a PC2 migration item price | X | ||
| PC2 migration items | Applicable items a PC2 migration item | X | |
| Create a PC2 migration item | X | ||
| Delete draft item | X | ||
| List PC2 migration items | X | ||
| Retrieve a PC2 migration item | X | ||
| Update a PC2 migration item | X | ||
| PC2 migrations | Contact support a PC2 migration | X | |
| Create a PC2 migration | X | ||
| Initiate a PC2 migration | X | ||
| Retrieve a PC2 migration | X | ||
| Personalized offers | List personalized offers | X | |
| Portal sessions | Activate a portal session | X | |
| Create a portal session | X | ||
| Logout a portal session | X | ||
| Retrieve a portal session | X | ||
| Price variants | Create a price variant | X | |
| Delete a price variant | X | ||
| List price variants | X | ||
| Retrieve a price variant | X | ||
| Update a price variant | X | ||
| Pricing page sessions | Create pricing page for existing subscription | X | |
| Create pricing page for new subscription | X | ||
| Products | Add remove or update options for the product | X | |
| Create a product | X | ||
| Create a product variant | X | ||
| Delete a product | X | ||
| List product variants | X | ||
| List products | X | ||
| Retrieve a product | X | ||
| Update a product | X | ||
| Promotional credits | Add promotional credits | X | |
| Deduct promotional credits | X | ||
| List promotional credits | X | ||
| Retrieve a promotional credit | X | ||
| Set promotional credits | X | ||
| Purchases | Create a purchase | X | |
| Estimates for purchase | X | ||
| Quotes | Convert a quote | X | |
| Create a quote for charges and charge items | X | ||
| Create a quote for subscription update | X | ||
| Delete a quote | X | ||
| Edit a quote for charges and charge items | X | ||
| Edit a quote for subscription creation | X | ||
| Edit a quote for subscription update | X | ||
| Extend expiry date | X | ||
| List quote line groups | X | ||
| List quotes | X | ||
| Retrieve a quote as PDF | X | ||
| Retrieve a quote | X | ||
| Update quote status | X | ||
| Ramps | Delete a subscription ramp | X | |
| List subscription ramps | X | ||
| Retrieve a subscription ramp | X | ||
| Update a subscription ramp | X | ||
| Recorded purchases | Record a purchase | X | |
| Retrieve a recorded purchase | X | ||
| Resource migrations | Retrieve latest migration details | X | |
| Rules | Retrieve rule data | X | |
| Site migration details | List site migration details | X | |
| Site pc meta records | List site pc meta records | X | |
| Subscriptions | Add charge at term end | X | |
| Advance invoice estimate | X | ||
| Cancel subscription for items estimate | X | ||
| Cancel subscription for items | X | ||
| Change term end | X | ||
| Charge future renewals | X | ||
| Create a subscription ramp | X | ||
| Create a usage | X | ||
| Delete a subscription | X | ||
| Delete a usage | X | ||
| Edit advance invoice schedule | X | ||
| Enable or disable subscription entitlements | X | ||
| Import contract term | X | ||
| Import unbilled charges | X | ||
| List contract terms for a subscription | X | ||
| List discounts for a subscription | X | ||
| List entitlement overrides for a subscription | X | ||
| List subscription entitlements | X | ||
| List subscriptions | X | ||
| Move a subscription | X | ||
| Override billing profile | X | ||
| Pause a subscription | X | ||
| Pause subscription estimate | X | ||
| Reactivate a subscription | X | ||
| Regenerate an invoice | X | ||
| Regenerate invoice estimate | X | ||
| Remove an advance invoice schedules | X | ||
| Remove coupons | X | ||
| Remove scheduled cancellation | X | ||
| Remove scheduled changes | X | ||
| Remove scheduled pause | X | ||
| Remove scheduled resumption | X | ||
| Resume a subscription | X | ||
| Resume subscription estimate | X | ||
| Retrieve a subscription | X | ||
| Retrieve a usage | X | ||
| Retrieve advance invoice | X | ||
| Retrieve with scheduled changes | X | ||
| Scheduled changes a subscription scheduled change | X | ||
| Subscription change term end estimate | X | ||
| Subscription renewal estimate | X | ||
| Update scheduled changes a subscription scheduled change | X | ||
| Update subscription for items | X | ||
| Remove entitlement overrides for a subscription | X | ||
| Time machines | Retrieve a time machine | X | |
| Start afresh | X | ||
| Travel forward | X | ||
| Tokens | Create a card payment method token | X | |
| Create using vault temp token | X | ||
| Retrieve a token | X | ||
| Transactions | Create an authorization payment | X | |
| Delete an offline transaction | X | ||
| List transactions | X | ||
| Reconcile transaction | X | ||
| Record an offline refund | X | ||
| Refund a payment | X | ||
| Retrieve a transaction | X | ||
| Void an authorization transaction | X | ||
| Unbilled charges | Create an estimate for unbilled charges | X | |
| Create an invoice for unbilled charges | X | ||
| Create unbilled charges for item subscription | X | ||
| Delete an unbilled charge | X | ||
| List unbilled charges | X | ||
| Usage events | Ingest a usage event | X | |
| Usage files | Retrieve file processing status | X | |
| Retrieve usage file upload URL | X | ||
| Usages | List usages | X | |
| Retrieve usages for an invoice as PDF | X | ||
| Variants | Delete a product variant | X | |
| Retrieve a product variant | X | ||
| Update a product variant | X | ||
| Virtual bank accounts | Create a virtual bank account | X | |
| Create a virtual bank account using permanent token | X | ||
| Delete a virtual bank account | X | ||
| List virtual bank accounts | X | ||
| Local delete a virtual bank account | X | ||
| Retrieve a virtual bank account | X | ||
| Webhook endpoints | Create a webhook endpoint | X | |
| Delete a webhook endpoint | X | ||
| List webhook endpoints | X | ||
| Retrieve a webhook endpoint | X | ||
| Update webhook endpoint | X |
Available DI objects
The following objects are available when using Chargebee as a source in Celigo Data Integration (DI).
Primary key: Every Chargebee DI object is returned wrapped in a named resource object, and the primary key is that wrapper's id — for example customer.id, subscription.id, invoice.id, coupon.id, item.id, and so on across all resources. The nested string id is the consistent key for every object.
Note
Chargebee generally does not remove records silently. Many resources expose status transitions or a deleted flag (for example, subscriptions move to cancelled, resources can be marked deleted) rather than being physically removed, and deletions are additionally surfaced through the Events API (the List events object) as *_deleted event types. Records that are hard-deleted otherwise stop appearing in list results rather than being returned with a deleted marker.
| Object | API endpoint | Available extract modes | Delta field |
|---|---|---|---|
| Business entities | List business entity transfers | Full, Incremental | created_at[after] |
| Comments | List comments | Full, Incremental | created_at[after] |
| Coupon codes | List coupon codes | Full | — |
| Coupon sets | List coupon sets | Full | — |
| Coupons | List coupons | Full, Incremental | updated_at[after] |
| Credit notes | List credit notes | Full, Incremental | updated_at[after] |
| Customers | List customers | Full, Incremental | updated_at[after] |
| Differential prices | List differential prices | Full | — |
| Entitlements | List entitlements | Full | — |
| Events | List events | Full | — |
| Features | List features | Full | — |
| Gifts | List gifts | Full | — |
| Invoices | List invoices | Full, Incremental | updated_at[after] |
| Item families | List item families | Full, Incremental | updated_at[after] |
| Item prices | List item prices | Full, Incremental | updated_at[after] |
| Items | List items | Full, Incremental | updated_at[after] |
| Omnichannel one time orders | List omnichannel one time orders | Full | — |
| Omnichannel subscriptions | List omnichannel subscriptions | Full | — |
| Orders | List orders | Full, Incremental | updated_at[after] |
| Payment sources | List payment sources | Full, Incremental | updated_at[after] |
| Price variants | List price variants | Full, Incremental | updated_at[after] |
| Products | List products | Full, Incremental | updated_at[after] |
| Promotional credits | List promotional credits | Full, Incremental | created_at[after] |
| Quotes | List quotes | Full, Incremental | updated_at[after] |
| Ramps | List subscription ramps | Full, Incremental | updated_at[after] |
| Subscriptions | List subscriptions | Full, Incremental | updated_at[after] |
| Transactions | List transactions | Full, Incremental | updated_at[after] |
| Unbilled charges | List unbilled charges | Full | — |
| Usages | List usages | Full, Incremental | updated_at[after] |
| Virtual bank accounts | List virtual bank accountss | Full, Incremental | updated_at[after] |
Response schemas
Click an object below to view its response fields and delta configuration.
Business entities — List business entity transfers
Delta configuration: use it to request incremental data.
| Setting | Value |
|---|---|
| Delta filter | created_at[after] = {{{encodeURI lastExportDateTime}}} |
| Date format | X |
Response schema:
| Field | Type |
|---|---|
business_entity_transfer |
object |
business_entity_transfer.id |
string (Primary key) |
business_entity_transfer.active_resource_id |
string |
business_entity_transfer.resource_id |
string |
business_entity_transfer.resource_type |
string |
business_entity_transfer.destination_business_entity_id |
string |
business_entity_transfer.source_business_entity_id |
string |
business_entity_transfer.status |
string |
business_entity_transfer.created_at |
number |
business_entity_transfer.initiated_by |
string |
business_entity_transfer.object |
string |
business_entity_transfer.transfer_details |
objectarray |
business_entity_transfer.transfer_details.resource_type |
string |
business_entity_transfer.transfer_details.resource_id |
string |
business_entity_transfer.transfer_details.active_resource_id |
string |
business_entity_transfer.transfer_details.object |
string |
Comments — List comments
Delta configuration: use it to request incremental data.
| Setting | Value |
|---|---|
| Delta filter | created_at[after] = {{{encodeURI lastExportDateTime}}} |
| Date format | X |
Response schema:
| Field | Type |
|---|---|
comment |
object |
comment.id |
string (Primary key) |
comment.entity_type |
string |
comment.added_by |
string |
comment.notes |
string |
comment.entity_id |
string |
comment.type |
string |
comment.created_at |
number |
comment.object |
string |
Coupon codes — List coupon codes
Response schema:
| Field | Type |
|---|---|
coupon_code |
object |
coupon_code.id |
string (Primary key) |
coupon_code.code |
string |
coupon_code.coupon_id |
string |
coupon_code.coupon_set_id |
string |
coupon_code.coupon_set_name |
string |
coupon_code.status |
string |
coupon_code.object |
string |
Coupon sets — List coupon sets
Response schema:
| Field | Type |
|---|---|
coupon_set |
object |
coupon_set.id |
string (Primary key) |
coupon_set.name |
string |
coupon_set.coupon_id |
string |
coupon_set.total_count |
number |
coupon_set.redeemed_count |
number |
coupon_set.archived_count |
number |
coupon_set.object |
string |
coupon_set.meta_data |
object |
Coupons — List coupons
Delta configuration: use it to request incremental data.
| Setting | Value |
|---|---|
| Delta filter | updated_at[after] = {{{encodeURI lastExportDateTime}}} |
| Date format | X |
Response schema:
| Field | Type |
|---|---|
coupon |
object |
coupon.id |
string (Primary key) |
coupon.name |
string |
coupon.invoice_name |
string |
coupon.discount_type |
string |
coupon.discount_percentage |
number |
coupon.discount_amount |
number |
coupon.currency_code |
string |
coupon.duration_type |
string |
coupon.duration_month |
number |
coupon.valid_till |
number |
coupon.max_redemptions |
number |
coupon.status |
string |
coupon.apply_discount_on |
string |
coupon.apply_on |
string |
coupon.created_at |
number |
coupon.archived_at |
number |
coupon.resource_version |
string |
coupon.updated_at |
number |
coupon.period |
number |
coupon.period_unit |
string |
coupon.redemptions |
boolean |
coupon.invoice_notes |
string |
coupon.coupon_type |
string |
coupon.deleted |
boolean |
coupon.object |
string |
coupon.business_entity_id |
string |
coupon.plan_constraint |
string |
coupon.addon_constraint |
string |
coupon.plan_ids |
stringarray |
coupon.addon_ids |
stringarray |
coupon.item_constraints |
objectarray |
coupon.item_constraints.item_type |
string |
coupon.item_constraints.constraint |
string |
coupon.item_constraints.item_price_ids |
stringarray |
coupon.item_constraint_criteria |
objectarray |
coupon.item_constraint_criteria.item_type |
string |
coupon.item_constraint_criteria.currencies |
string |
coupon.item_constraint_criteria.item_family_ids |
string |
coupon.item_constraint_criteria.item_price_periods |
string |
coupon.coupon_constraints |
objectarray |
coupon.coupon_constraints.entity_type |
string |
coupon.coupon_constraints.type |
string |
coupon.coupon_constraints.value |
string |
coupon.meta_data |
object |
Credit notes — List credit notes
Delta configuration: use it to request incremental data.
| Setting | Value |
|---|---|
| Delta filter | updated_at[after] = {{{encodeURI lastExportDateTime}}} |
| Date format | X |
Response schema:
| Field | Type |
|---|---|
credit_note |
object |
credit_note.id |
string (Primary key) |
credit_note.customer_id |
string |
credit_note.subscription_id |
string |
credit_note.reference_invoice_id |
string |
credit_note.type |
string |
credit_note.reason_code |
string |
credit_note.create_reason_code |
number |
credit_note.status |
string |
credit_note.vat_number |
string |
credit_note.date |
number |
credit_note.price_type |
string |
credit_note.currency_code |
string |
credit_note.total |
number |
credit_note.amount_allocated |
number |
credit_note.amount_refunded |
number |
credit_note.amount_available |
number |
credit_note.refunded_at |
number |
credit_note.voided_at |
number |
credit_note.generated_at |
number |
credit_note.updated_at |
number |
credit_note.resource_version |
number |
credit_note.sub_total |
number |
credit_note.sub_total_in_local_currency |
number |
credit_note.total_in_local_currency |
number |
credit_note.local_currency_code |
string |
credit_note.round_off_amount |
number |
credit_note.fractional_correction |
number |
credit_note.deleted |
boolean |
credit_note.object |
string |
credit_note.channel |
string |
credit_note.business_entity_id |
string |
credit_note.base_currency_code |
string |
credit_note.vat_number_prefix |
string |
credit_note.create_reason_code_v2 |
string |
credit_note.line_items |
objectarray |
credit_note.line_items.id |
string |
credit_note.line_items.date_from |
number |
credit_note.line_items.date_to |
number |
credit_note.line_items.unit_amount |
number |
credit_note.line_items.quantity |
number |
credit_note.line_items.amount |
number |
credit_note.line_items.pricing_model |
number |
credit_note.line_items.is_taxed |
boolean |
credit_note.line_items.tax_amount |
number |
credit_note.line_items.tax_rate |
number |
credit_note.line_items.unit_amount_in_decimal |
number |
credit_note.line_items.quantity_in_decimal |
string |
credit_note.line_items.amount_in_decimal |
string |
credit_note.line_items.discount_amount |
number |
credit_note.line_items.item_level_discount_amount |
number |
credit_note.line_items.description |
string |
credit_note.line_items.entity_type |
string |
credit_note.line_items.entity_id |
string |
credit_note.line_items.subscription_id |
string |
credit_note.line_items.customer_id |
string |
credit_note.line_items.reference_line_item_id |
string |
credit_note.line_items.tax_exempt_reason |
string |
credit_note.line_items.discount_type |
number |
credit_note.line_items.object |
string |
credit_note.discounts |
objectarray |
credit_note.discounts.id |
string |
credit_note.discounts.invoice_name |
string |
credit_note.discounts.type |
string |
credit_note.discounts.percentage |
number |
credit_note.discounts.amount |
number |
credit_note.discounts.currency_code |
string |
credit_note.discounts.duration_type |
string |
credit_note.discounts.period |
number |
credit_note.discounts.period_unit |
string |
credit_note.discounts.included_in_mrr |
boolean |
credit_note.discounts.apply_on |
string |
credit_note.discounts.item_price_id |
string |
credit_note.discounts.created_at |
number |
credit_note.discounts.apply_till |
number |
credit_note.discounts.object |
string |
credit_note.line_item_discounts |
objectarray |
credit_note.line_item_discounts.line_item_id |
string |
credit_note.line_item_discounts.discount_type |
string |
credit_note.line_item_discounts.coupon_id |
string |
credit_note.line_item_discounts.entity_id |
string |
credit_note.line_item_discounts.discount_amount |
number |
credit_note.line_item_discounts.object |
string |
credit_note.line_item_tiers |
objectarray |
credit_note.line_item_tiers.line_item_id |
string |
credit_note.line_item_tiers.starting_unit |
number |
credit_note.line_item_tiers.ending_unit |
number |
credit_note.line_item_tiers.quantity_used |
number |
credit_note.line_item_tiers.unit_amount |
number |
credit_note.line_item_tiers.starting_unit_in_decimal |
string |
credit_note.line_item_tiers.ending_unit_in_decimal |
string |
credit_note.line_item_tiers.quantity_used_in_decimal |
string |
credit_note.line_item_tiers.unit_amount_in_decimal |
string |
credit_note.line_item_tiers.pricing_type |
string |
credit_note.line_item_tiers.package_size |
number |
credit_note.line_item_tiers.object |
string |
credit_note.taxes |
objectarray |
credit_note.taxes.name |
string |
credit_note.taxes.amount |
number |
credit_note.taxes.description |
string |
credit_note.line_item_taxes |
objectarray |
credit_note.line_item_taxes.line_item_id |
string |
credit_note.line_item_taxes.tax_name |
string |
credit_note.line_item_taxes.tax_rate |
number |
credit_note.line_item_taxes.tax_amount |
number |
credit_note.line_item_taxes.tax_juris_type |
string |
credit_note.line_item_taxes.tax_juris_name |
string |
credit_note.line_item_taxes.tax_juris_code |
string |
credit_note.line_item_taxes.tax_amount_in_local_currency |
number |
credit_note.line_item_taxes.local_currency_code |
string |
credit_note.line_item_taxes.object |
string |
credit_note.linked_refunds |
objectarray |
credit_note.linked_refunds.txn_id |
string |
credit_note.linked_refunds.applied_amount |
string |
credit_note.linked_refunds.applied_at |
number |
credit_note.linked_refunds.txn_status |
string |
credit_note.linked_refunds.txn_date |
string |
credit_note.linked_refunds.txn_amount |
number |
credit_note.linked_refunds.object |
string |
credit_note.allocations |
objectarray |
credit_note.allocations.invoice_id |
string |
credit_note.allocations.allocated_amount |
string |
credit_note.allocations.allocated_at |
number |
credit_note.allocations.invoice_date |
number |
credit_note.allocations.invoice_status |
string |
credit_note.allocations.object |
string |
credit_note.shipping_address |
object |
credit_note.shipping_address.first_name |
string |
credit_note.shipping_address.last_name |
string |
credit_note.shipping_address.email |
string |
credit_note.shipping_address.company |
string |
credit_note.shipping_address.phone |
string |
credit_note.shipping_address.line1 |
string |
credit_note.shipping_address.line2 |
string |
credit_note.shipping_address.line3 |
string |
credit_note.shipping_address.city |
string |
credit_note.shipping_address.state_code |
string |
credit_note.shipping_address.state |
string |
credit_note.shipping_address.country |
string |
credit_note.shipping_address.zip |
string |
credit_note.shipping_address.validation_status |
string |
credit_note.shipping_address.object |
string |
credit_note.billing_address |
object |
credit_note.billing_address.first_name |
string |
credit_note.billing_address.last_name |
string |
credit_note.billing_address.email |
string |
credit_note.billing_address.company |
string |
credit_note.billing_address.phone |
string |
credit_note.billing_address.line1 |
string |
credit_note.billing_address.line2 |
string |
credit_note.billing_address.line3 |
string |
credit_note.billing_address.city |
string |
credit_note.billing_address.state_code |
string |
credit_note.billing_address.state |
string |
credit_note.billing_address.country |
string |
credit_note.billing_address.zip |
string |
credit_note.billing_address.validation_status |
string |
credit_note.billing_address.object |
string |
Customers — List customers
Delta configuration: use it to request incremental data.
| Setting | Value |
|---|---|
| Delta filter | updated_at[after] = {{{encodeURI lastExportDateTime}}} |
| Date format | X |
Response schema:
| Field | Type |
|---|---|
customer |
object |
customer.id |
string (Primary key) |
customer.first_name |
string |
customer.last_name |
string |
customer.email |
string |
customer.phone |
string |
customer.company |
string |
customer.vat_number |
string |
customer.auto_collection |
string |
customer.net_term_days |
number |
customer.allow_direct_debit |
boolean |
customer.is_location_valid |
boolean |
customer.created_at |
number |
customer.created_from_ip |
number |
customer.taxability |
string |
customer.entity_code |
string |
customer.exempt_number |
string |
customer.resource_version |
number |
customer.updated_at |
number |
customer.locale |
string |
customer.billing_date |
number |
customer.billing_date_mode |
string |
customer.billing_day_of_week |
string |
customer.billing_day_of_week_mode |
string |
customer.pii_cleared |
string |
customer.card_status |
string |
customer.fraud_flag |
string |
customer.primary_payment_source_id |
string |
customer.backup_payment_source_id |
string |
customer.promotional_credits |
number |
customer.refundable_credits |
number |
customer.excess_payments |
number |
customer.unbilled_charges |
number |
customer.preferred_currency_code |
string |
customer.mrr |
string |
customer.customer_type |
string |
customer.deleted |
boolean |
customer.object |
string |
customer.consolidated_invoicing |
boolean |
customer.auto_close_invoices |
number |
customer.channel |
string |
customer.business_entity_id |
string |
customer.vat_number_validated_time |
string |
customer.vat_number_status |
string |
customer.client_profile_id |
string |
customer.billing_address |
object |
customer.billing_address.first_name |
string |
customer.billing_address.last_name |
string |
customer.billing_address.email |
string |
customer.billing_address.company |
string |
customer.billing_address.phone |
string |
customer.billing_address.line1 |
string |
customer.billing_address.line2 |
string |
customer.billing_address.line3 |
string |
customer.billing_address.city |
string |
customer.billing_address.state_code |
string |
customer.billing_address.state |
string |
customer.billing_address.country |
string |
customer.billing_address.zip |
string |
customer.billing_address.validation_status |
string |
customer.billing_address.object |
string |
customer.referral_urls |
objectarray |
customer.referral_urls.external_customer_id |
string |
customer.referral_urls.referral_sharing_url |
string |
customer.referral_urls.created_at |
string |
customer.referral_urls.updated_at |
number |
customer.referral_urls.referral_campaign_id |
string |
customer.referral_urls.referral_account_id |
string |
customer.referral_urls.referral_external_campaign_id |
string |
customer.referral_urls.referral_system |
string |
customer.referral_urls.object |
string |
customer.contacts |
objectarray |
customer.contacts.id |
string |
customer.contacts.first_name |
string |
customer.contacts.last_name |
string |
customer.contacts.email |
string |
customer.contacts.phone |
string |
customer.contacts.label |
string |
customer.contacts.enabled |
boolean |
customer.contacts.send_account_email |
boolean |
customer.contacts.send_billing_email |
boolean |
customer.contacts.object |
string |
customer.payment_method |
object |
customer.payment_method.object |
string |
customer.payment_method.type |
string |
customer.payment_method.gateway |
string |
customer.payment_method.gateway_account_id |
string |
customer.payment_method.status |
string |
customer.payment_method.reference_id |
string |
customer.balances |
objectarray |
customer.balances.promotional_credits |
number |
customer.balances.excess_payments |
number |
customer.balances.refundable_credits |
number |
customer.balances.unbilled_charges |
number |
customer.balances.currency_code |
string |
customer.balances.balance_currency_code |
string |
customer.balances.object |
string |
customer.entity_identifiers |
objectarray |
customer.entity_identifiers.id |
string |
customer.entity_identifiers.scheme |
string |
customer.entity_identifiers.value |
string |
customer.entity_identifiers.type |
string |
customer.entity_identifiers.standard |
string |
customer.entity_identifiers.object |
string |
customer.relationship |
object |
customer.relationship.parent_id |
string |
customer.relationship.payment_owner_id |
string |
customer.relationship.invoice_owner_id |
string |
customer.meta_data |
object |
Differential prices — List differential prices
Response schema:
| Field | Type |
|---|---|
differential_price |
object |
differential_price.id |
string (Primary key) |
differential_price.item_price_id |
string |
differential_price.parent_item_id |
string |
differential_price.price |
number |
differential_price.price_in_decimal |
string |
differential_price.status |
string |
differential_price.resource_version |
number |
differential_price.updated_at |
number |
differential_price.created_at |
number |
differential_price.object |
string |
differential_price.tiers |
objectarray |
differential_price.tiers.starting_unit |
number |
differential_price.tiers.ending_unit |
number |
differential_price.tiers.price |
number |
differential_price.tiers.starting_unit_in_decimal |
string |
differential_price.tiers.ending_unit_in_decimal |
string |
differential_price.tiers.price_in_decimal |
string |
differential_price.tiers.pricing_type |
string |
differential_price.tiers.package_size |
number |
differential_price.parent_periods |
objectarray |
differential_price.parent_periods.period_unit |
string |
differential_price.parent_periods.period |
numberarray |
Entitlements — List entitlements
Response schema:
| Field | Type |
|---|---|
entitlement |
object |
entitlement.id |
string (Primary key) |
entitlement.entity_id |
string |
entitlement.entity_type |
string |
entitlement.feature_id |
string |
entitlement.feature_name |
string |
entitlement.feature_unit |
string |
entitlement.value |
string |
entitlement.name |
string |
entitlement.created_at |
number |
entitlement.updated_at |
number |
entitlement.resource_version |
number |
entitlement.object |
string |
Events — List events
Response schema:
| Field | Type |
|---|---|
event |
object |
event.id |
string (Primary key) |
event.occurred_at |
number |
event.source |
string |
event.user |
string |
event.webhook_status |
number |
event.webhook_failure_reason |
string |
event.event_type |
string |
event.api_version |
string |
event.webhooks |
objectarray |
event.webhooks.id |
string |
event.webhooks.webhook_status |
string |
event.webhooks.object |
string |
event.object |
string |
event.content |
object |
Features — List features
Response schema:
| Field | Type |
|---|---|
feature |
object |
feature.id |
string (Primary key) |
feature.name |
string |
feature.description |
string |
feature.status |
string |
feature.type |
string |
feature.unit |
string |
feature.created_at |
number |
feature.updated_at |
number |
feature.resource_version |
number |
feature.object |
string |
feature.levels |
objectarray |
feature.levels.id |
string |
feature.levels.name |
string |
feature.levels.value |
string |
feature.levels.level |
number |
feature.levels.is_unlimited |
boolean |
feature.levels.object |
string |
Gifts — List gifts
Response schema:
| Field | Type |
|---|---|
gift |
object |
gift.id |
string (Primary key) |
gift.status |
string |
gift.scheduled_at |
number |
gift.auto_claim |
number |
gift.no_expiry |
boolean |
gift.claim_expiry_date |
number |
gift.subscription_id |
string |
gift.invoice_id |
string |
gift.resource_version |
number |
gift.updated_at |
number |
gift.object |
string |
gift.gift_receiver |
object |
gift.gift_receiver.customer_id |
string |
gift.gift_receiver.subscription_id |
string |
gift.gift_receiver.first_name |
string |
gift.gift_receiver.last_name |
string |
gift.gift_receiver.email |
string |
gift.gifter |
object |
gift.gifter.customer_id |
string |
gift.gifter.invoice_id |
string |
gift.gifter.signature |
string |
gift.gifter.note |
string |
gift.gifter.payment_src_id |
string |
gift.gift_timelines |
objectarray |
gift.gift_timelines.status |
string |
gift.gift_timelines.occurred_at |
number |
Invoices — List invoices
Delta configuration: use it to request incremental data.
| Setting | Value |
|---|---|
| Delta filter | updated_at[after] = {{{encodeURI lastExportDateTime}}} |
| Date format | X |
Response schema:
| Field | Type |
|---|---|
invoice |
object |
invoice.id |
string (Primary key) |
invoice.po_number |
string |
invoice.customer_id |
string |
invoice.subscription_id |
string |
invoice.recurring |
boolean |
invoice.status |
string |
invoice.vat_number |
string |
invoice.price_type |
string |
invoice.date |
number |
invoice.due_date |
number |
invoice.net_term_days |
string |
invoice.exchange_rate |
string |
invoice.currency_code |
string |
invoice.total |
number |
invoice.amount_paid |
number |
invoice.amount_adjusted |
number |
invoice.write_off_amount |
number |
invoice.credits_applied |
number |
invoice.amount_due |
number |
invoice.paid_at |
number |
invoice.updated_at |
number |
invoice.resource_version |
number |
invoice.dunning_status |
string |
invoice.next_retry_at |
number |
invoice.sub_total |
number |
invoice.sub_total_in_local_currency |
number |
invoice.total_in_local_currency |
number |
invoice.local_currency_code |
string |
invoice.tax |
number |
invoice.first_invoice |
boolean |
invoice.has_advance_charges |
boolean |
invoice.is_gifted |
boolean |
invoice.term_finalized |
string |
invoice.is_digital |
boolean |
invoice.generated_at |
number |
invoice.deleted |
boolean |
invoice.object |
string |
invoice.vat_number_prefix |
string |
invoice.channel |
string |
invoice.business_entity_id |
string |
invoice.amount_to_collect |
number |
invoice.round_off_amount |
number |
invoice.base_currency_code |
string |
invoice.new_sales_amount |
number |
invoice.line_items |
objectarray |
invoice.line_items.id |
string |
invoice.line_items.date_from |
number |
invoice.line_items.date_to |
number |
invoice.line_items.unit_amount |
number |
invoice.line_items.quantity |
number |
invoice.line_items.amount |
number |
invoice.line_items.pricing_model |
number |
invoice.line_items.is_taxed |
boolean |
invoice.line_items.tax_amount |
number |
invoice.line_items.tax_rate |
number |
invoice.line_items.unit_amount_in_decimal |
number |
invoice.line_items.quantity_in_decimal |
string |
invoice.line_items.amount_in_decimal |
string |
invoice.line_items.discount_amount |
number |
invoice.line_items.item_level_discount_amount |
number |
invoice.line_items.description |
string |
invoice.line_items.entity_type |
string |
invoice.line_items.entity_id |
string |
invoice.line_items.subscription_id |
string |
invoice.line_items.customer_id |
string |
invoice.line_items.reference_line_item_id |
string |
invoice.line_items.tax_exempt_reason |
string |
invoice.line_items.discount_type |
number |
invoice.line_items.object |
string |
invoice.discounts |
objectarray |
invoice.discounts.id |
string |
invoice.discounts.invoice_name |
string |
invoice.discounts.type |
string |
invoice.discounts.percentage |
number |
invoice.discounts.amount |
number |
invoice.discounts.currency_code |
string |
invoice.discounts.duration_type |
string |
invoice.discounts.period |
number |
invoice.discounts.period_unit |
string |
invoice.discounts.included_in_mrr |
boolean |
invoice.discounts.apply_on |
string |
invoice.discounts.item_price_id |
string |
invoice.discounts.created_at |
number |
invoice.discounts.apply_till |
number |
invoice.discounts.object |
string |
invoice.line_item_discounts |
objectarray |
invoice.line_item_discounts.line_item_id |
string |
invoice.line_item_discounts.discount_type |
string |
invoice.line_item_discounts.coupon_id |
string |
invoice.line_item_discounts.entity_id |
string |
invoice.line_item_discounts.discount_amount |
number |
invoice.line_item_discounts.object |
string |
invoice.taxes |
objectarray |
invoice.taxes.name |
string |
invoice.taxes.amount |
number |
invoice.taxes.description |
string |
invoice.line_item_taxes |
objectarray |
invoice.line_item_taxes.line_item_id |
string |
invoice.line_item_taxes.tax_name |
string |
invoice.line_item_taxes.tax_rate |
number |
invoice.line_item_taxes.tax_amount |
number |
invoice.line_item_taxes.tax_juris_type |
string |
invoice.line_item_taxes.tax_juris_name |
string |
invoice.line_item_taxes.tax_juris_code |
string |
invoice.line_item_taxes.tax_amount_in_local_currency |
number |
invoice.line_item_taxes.local_currency_code |
string |
invoice.line_item_taxes.object |
string |
invoice.line_item_tiers |
objectarray |
invoice.line_item_tiers.line_item_id |
string |
invoice.line_item_tiers.starting_unit |
number |
invoice.line_item_tiers.ending_unit |
number |
invoice.line_item_tiers.quantity_used |
number |
invoice.line_item_tiers.unit_amount |
number |
invoice.line_item_tiers.starting_unit_in_decimal |
string |
invoice.line_item_tiers.ending_unit_in_decimal |
string |
invoice.line_item_tiers.quantity_used_in_decimal |
string |
invoice.line_item_tiers.unit_amount_in_decimal |
string |
invoice.line_item_tiers.pricing_type |
string |
invoice.line_item_tiers.package_size |
number |
invoice.line_item_tiers.object |
string |
invoice.linked_payments |
objectarray |
invoice.linked_payments.txn_id |
string |
invoice.linked_payments.applied_amount |
string |
invoice.linked_payments.applied_at |
number |
invoice.linked_payments.txn_status |
string |
invoice.linked_payments.txn_date |
number |
invoice.linked_payments.txn_amount |
number |
invoice.linked_payments.object |
string |
invoice.dunning_attempts |
objectarray |
invoice.dunning_attempts.attempt |
number |
invoice.dunning_attempts.transaction_id |
string |
invoice.dunning_attempts.dunning_type |
number |
invoice.dunning_attempts.created_at |
number |
invoice.dunning_attempts.txn_amount |
number |
invoice.dunning_attempts.txn_status |
string |
invoice.dunning_attempts.object |
string |
invoice.applied_credits |
objectarray |
invoice.applied_credits.cn_id |
string |
invoice.applied_credits.applied_amount |
string |
invoice.applied_credits.applied_at |
number |
invoice.applied_credits.cn_reason_code |
string |
invoice.applied_credits.cn_create_reason_code |
number |
invoice.applied_credits.cn_date |
number |
invoice.applied_credits.cn_status |
number |
invoice.applied_credits.object |
string |
invoice.adjustment_credit_notes |
objectarray |
invoice.adjustment_credit_notes.cn_id |
string |
invoice.adjustment_credit_notes.cn_reason_code |
string |
invoice.adjustment_credit_notes.cn_create_reason_code |
number |
invoice.adjustment_credit_notes.cn_date |
number |
invoice.adjustment_credit_notes.cn_total |
number |
invoice.adjustment_credit_notes.cn_status |
string |
invoice.adjustment_credit_notes.cn_reference_invoice_id |
number |
invoice.adjustment_credit_notes.object |
string |
invoice.issued_credit_notes |
objectarray |
invoice.issued_credit_notes.cn_id |
string |
invoice.issued_credit_notes.cn_reason_code |
string |
invoice.issued_credit_notes.cn_create_reason_code |
number |
invoice.issued_credit_notes.cn_date |
number |
invoice.issued_credit_notes.cn_total |
number |
invoice.issued_credit_notes.cn_status |
string |
invoice.issued_credit_notes.cn_reference_invoice_id |
number |
invoice.issued_credit_notes.object |
string |
invoice.linked_orders |
objectarray |
invoice.linked_orders.id |
string |
invoice.linked_orders.document_number |
string |
invoice.linked_orders.status |
string |
invoice.linked_orders.order_type |
string |
invoice.linked_orders.reference_id |
string |
invoice.linked_orders.fulfillment_status |
string |
invoice.linked_orders.batch_id |
string |
invoice.linked_orders.created_at |
number |
invoice.linked_orders.object |
string |
invoice.notes |
objectarray |
invoice.notes.entity_type |
string |
invoice.notes.note |
string |
invoice.notes.entity_id |
string |
invoice.notes.object |
string |
invoice.shipping_address |
object |
invoice.shipping_address.first_name |
string |
invoice.shipping_address.last_name |
string |
invoice.shipping_address.email |
string |
invoice.shipping_address.company |
string |
invoice.shipping_address.phone |
string |
invoice.shipping_address.line1 |
string |
invoice.shipping_address.line2 |
string |
invoice.shipping_address.line3 |
string |
invoice.shipping_address.city |
string |
invoice.shipping_address.state_code |
string |
invoice.shipping_address.state |
string |
invoice.shipping_address.country |
string |
invoice.shipping_address.zip |
string |
invoice.shipping_address.validation_status |
string |
invoice.shipping_address.object |
string |
invoice.billing_address |
object |
invoice.billing_address.first_name |
string |
invoice.billing_address.last_name |
string |
invoice.billing_address.email |
string |
invoice.billing_address.company |
string |
invoice.billing_address.phone |
string |
invoice.billing_address.line1 |
string |
invoice.billing_address.line2 |
string |
invoice.billing_address.line3 |
string |
invoice.billing_address.city |
string |
invoice.billing_address.state_code |
string |
invoice.billing_address.state |
string |
invoice.billing_address.country |
string |
invoice.billing_address.zip |
string |
invoice.billing_address.validation_status |
string |
invoice.billing_address.object |
string |
invoice.einvoice |
object |
invoice.einvoice.id |
string |
invoice.einvoice.reference_number |
string |
invoice.einvoice.status |
string |
invoice.einvoice.message |
string |
invoice.einvoice.object |
string |
Item families — List item families
Delta configuration: use it to request incremental data.
| Setting | Value |
|---|---|
| Delta filter | updated_at[after] = {{{encodeURI lastExportDateTime}}} |
| Date format | X |
Response schema:
| Field | Type |
|---|---|
item_family |
object |
item_family.id |
string (Primary key) |
item_family.name |
string |
item_family.description |
string |
item_family.resource_version |
number |
item_family.updated_at |
number |
item_family.channel |
string |
item_family.status |
string |
item_family.business_entity_id |
string |
item_family.deleted |
boolean |
item_family.object |
string |
Item prices — List item prices
Delta configuration: use it to request incremental data.
| Setting | Value |
|---|---|
| Delta filter | updated_at[after] = {{{encodeURI lastExportDateTime}}} |
| Date format | X |
Response schema:
| Field | Type |
|---|---|
item_price |
object |
item_price.id |
string (Primary key) |
item_price.name |
string |
item_price.item_family_id |
string |
item_price.item_id |
string |
item_price.description |
string |
item_price.status |
string |
item_price.external_name |
number |
item_price.pricing_model |
string |
item_price.price |
number |
item_price.price_in_decimal |
string |
item_price.period |
number |
item_price.currency_code |
string |
item_price.period_unit |
string |
item_price.trial_period_unit |
string |
item_price.trial_period |
number |
item_price.trial_end_action |
string |
item_price.shipping_period |
number |
item_price.shipping_period_unit |
string |
item_price.billing_cycles |
number |
item_price.free_quantity |
number |
item_price.free_quantity_in_decimal |
string |
item_price.resource_version |
number |
item_price.updated_at |
number |
item_price.invoice_notes |
string |
item_price.created_at |
number |
item_price.archived_at |
string |
item_price.unit |
number |
item_price.is_taxable |
boolean |
item_price.metered |
string |
item_price.show_description_in_invoices |
boolean |
item_price.show_description_in_quotes |
boolean |
item_price.deleted |
boolean |
item_price.object |
string |
item_price.channel |
string |
item_price.business_entity_id |
string |
item_price.tiers |
objectarray |
item_price.tiers.starting_unit |
number |
item_price.tiers.ending_unit |
number |
item_price.tiers.price |
number |
item_price.tiers.starting_unit_in_decimal |
string |
item_price.tiers.ending_unit_in_decimal |
string |
item_price.tiers.price_in_decimal |
string |
item_price.tiers.pricing_type |
string |
item_price.tiers.package_size |
number |
item_price.tax_detail |
object |
item_price.tax_detail.tax_profile_id |
string |
item_price.tax_detail.avalara_sale_type |
string |
item_price.tax_detail.avalara_transaction_type |
number |
item_price.tax_detail.avalara_service_type |
number |
item_price.tax_detail.avalara_tax_code |
string |
item_price.tax_detail.hsn_code |
string |
item_price.tax_detail.taxjar_product_code |
string |
item_price.tax_detail.tax_included_in_price |
string |
item_price.accounting_detail |
object |
item_price.accounting_detail.sku |
string |
item_price.accounting_detail.accounting_code |
string |
item_price.accounting_detail.accounting_category1 |
string |
item_price.accounting_detail.accounting_category2 |
string |
item_price.accounting_detail.accounting_category3 |
string |
item_price.accounting_detail.accounting_category4 |
string |
item_price.metadata |
object |
Items — List items
Delta configuration: use it to request incremental data.
| Setting | Value |
|---|---|
| Delta filter | updated_at[after] = {{{encodeURI lastExportDateTime}}} |
| Date format | X |
Response schema:
| Field | Type |
|---|---|
item |
object |
item.id |
string (Primary key) |
item.name |
string |
item.external_name |
string |
item.description |
string |
item.status |
string |
item.resource_version |
number |
item.updated_at |
number |
item.item_family_id |
string |
item.type |
string |
item.is_shippable |
boolean |
item.is_giftable |
boolean |
item.redirect_url |
string |
item.enabled_for_checkout |
boolean |
item.enabled_in_portal |
boolean |
item.included_in_mrr |
string |
item.item_applicability |
string |
item.gift_claim_redirect_url |
string |
item.unit |
number |
item.metered |
boolean |
item.usage_calculation |
string |
item.deleted |
boolean |
item.object |
string |
item.channel |
string |
item.business_entity_id |
string |
item.applicable_items |
stringarray |
item.bundle_items |
stringarray |
item.bundle_configuration |
object |
item.bundle_configuration.type |
string |
item.metadata |
object |
Omnichannel one time orders — List omnichannel one time orders
Response schema:
| Field | Type |
|---|---|
omnichannel_one_time_order |
object |
omnichannel_one_time_order.id |
string (Primary key) |
omnichannel_one_time_order.app_id |
string |
omnichannel_one_time_order.customer_id |
string |
omnichannel_one_time_order.source |
string |
omnichannel_one_time_order.id_at_source |
string |
omnichannel_one_time_order.status |
string |
omnichannel_one_time_order.created_at |
number |
omnichannel_one_time_order.resource_version |
number |
omnichannel_one_time_order.updated_at |
number |
omnichannel_one_time_order.object |
string |
omnichannel_one_time_order.line_items |
objectarray |
omnichannel_one_time_order.line_items.id |
string |
omnichannel_one_time_order.line_items.id_at_source |
string |
omnichannel_one_time_order.line_items.item_id_at_source |
string |
omnichannel_one_time_order.line_items.quantity |
number |
omnichannel_one_time_order.line_items.purchased_at |
number |
omnichannel_one_time_order.line_items.object |
string |
Omnichannel subscriptions — List omnichannel subscriptions
Response schema:
| Field | Type |
|---|---|
omnichannel_subscription |
object |
omnichannel_subscription.id |
string (Primary key) |
omnichannel_subscription.app_id |
string |
omnichannel_subscription.customer_id |
string |
omnichannel_subscription.source |
string |
omnichannel_subscription.id_at_source |
string |
omnichannel_subscription.created_at |
number |
omnichannel_subscription.resource_version |
number |
omnichannel_subscription.updated_at |
number |
omnichannel_subscription.object |
string |
omnichannel_subscription.omnichannel_subscription_items |
objectarray |
omnichannel_subscription.omnichannel_subscription_items.id |
string |
omnichannel_subscription.omnichannel_subscription_items.id_at_source |
string |
omnichannel_subscription.omnichannel_subscription_items.item_id_at_source |
string |
omnichannel_subscription.omnichannel_subscription_items.status |
string |
omnichannel_subscription.omnichannel_subscription_items.current_term_start |
number |
omnichannel_subscription.omnichannel_subscription_items.current_term_end |
number |
omnichannel_subscription.omnichannel_subscription_items.expiration_date |
number |
omnichannel_subscription.omnichannel_subscription_items.object |
string |
Orders — List orders
Delta configuration: use it to request incremental data.
| Setting | Value |
|---|---|
| Delta filter | updated_at[after] = {{{encodeURI lastExportDateTime}}} |
| Date format | X |
Response schema:
| Field | Type |
|---|---|
order |
object |
order.id |
string (Primary key) |
order.document_number |
string |
order.invoice_id |
string |
order.subscription_id |
string |
order.customer_id |
string |
order.status |
string |
order.reference_id |
string |
order.fulfillment_status |
string |
order.order_type |
string |
order.price_type |
string |
order.reference_invoice_id |
string |
order.tax |
number |
order.amount_paid |
number |
order.amount_adjusted |
number |
order.refundable_credits_issued |
number |
order.refundable_credits |
number |
order.batch_id |
string |
order.created_at |
number |
order.order_date |
number |
order.shipping_date |
number |
order.note |
string |
order.tracking_id |
string |
order.tracking_url |
string |
order.batch_id_at_shipping_provider |
string |
order.shipping_provider |
string |
order.resource_version |
number |
order.updated_at |
number |
order.delivered_at |
number |
order.shipped_at |
number |
order.order_line_items |
objectarray |
order.order_line_items.id |
string |
order.order_line_items.invoice_id |
string |
order.order_line_items.invoice_line_item_id |
string |
order.order_line_items.unit_price |
number |
order.order_line_items.amount |
number |
order.order_line_items.fulfillment_status |
string |
order.order_line_items.reference_id |
string |
order.order_line_items.sku |
string |
order.order_line_items.description |
string |
order.order_line_items.entity_type |
string |
order.order_line_items.entity_id |
string |
order.order_line_items.item_level_discount_id |
string |
order.order_line_items.tax_amount |
string |
order.order_line_items.amount_paid |
number |
order.order_line_items.amount_adjusted |
number |
order.order_line_items.refundable_credits |
number |
order.order_line_items.refundable_credits_issued |
number |
order.order_line_items.is_shippable |
string |
order.order_line_items.sku_id |
string |
order.order_line_items.status |
string |
order.order_line_items.discount_amount |
number |
order.order_line_items.object |
string |
order.currency_code |
string |
order.discount |
number |
order.sub_total |
number |
order.total |
number |
order.rounding_adjustement |
number |
order.deleted |
boolean |
order.object |
string |
order.gift_id |
string |
order.resend_status |
string |
order.is_resent |
string |
order.original_order_id |
string |
order.business_entity_id |
string |
order.base_currency_code |
string |
order.line_items |
objectarray |
order.line_items.id |
string |
order.line_items.date_from |
number |
order.line_items.date_to |
number |
order.line_items.unit_amount |
number |
order.line_items.quantity |
number |
order.line_items.amount |
number |
order.line_items.pricing_model |
number |
order.line_items.is_taxed |
boolean |
order.line_items.tax_amount |
number |
order.line_items.tax_rate |
number |
order.line_items.unit_amount_in_decimal |
number |
order.line_items.quantity_in_decimal |
string |
order.line_items.amount_in_decimal |
string |
order.line_items.discount_amount |
number |
order.line_items.item_level_discount_amount |
number |
order.line_items.description |
string |
order.line_items.entity_type |
string |
order.line_items.entity_id |
string |
order.line_items.subscription_id |
string |
order.line_items.customer_id |
string |
order.line_items.reference_line_item_id |
string |
order.line_items.tax_exempt_reason |
string |
order.line_items.discount_type |
number |
order.line_items.object |
string |
order.discounts |
objectarray |
order.discounts.id |
string |
order.discounts.invoice_name |
string |
order.discounts.type |
string |
order.discounts.percentage |
number |
order.discounts.amount |
number |
order.discounts.currency_code |
string |
order.discounts.duration_type |
string |
order.discounts.period |
number |
order.discounts.period_unit |
string |
order.discounts.included_in_mrr |
boolean |
order.discounts.apply_on |
string |
order.discounts.item_price_id |
string |
order.discounts.created_at |
number |
order.discounts.apply_till |
number |
order.discounts.object |
string |
order.taxes |
objectarray |
order.taxes.name |
string |
order.taxes.amount |
number |
order.taxes.description |
string |
order.line_item_taxes |
objectarray |
order.line_item_taxes.line_item_id |
string |
order.line_item_taxes.tax_name |
string |
order.line_item_taxes.tax_rate |
number |
order.line_item_taxes.tax_amount |
number |
order.line_item_taxes.tax_juris_type |
string |
order.line_item_taxes.tax_juris_name |
string |
order.line_item_taxes.tax_juris_code |
string |
order.line_item_taxes.tax_amount_in_local_currency |
number |
order.line_item_taxes.local_currency_code |
string |
order.line_item_taxes.object |
string |
order.line_item_discounts |
objectarray |
order.line_item_discounts.line_item_id |
string |
order.line_item_discounts.discount_type |
string |
order.line_item_discounts.coupon_id |
string |
order.line_item_discounts.entity_id |
string |
order.line_item_discounts.discount_amount |
number |
order.line_item_discounts.object |
string |
order.linked_credit_notes |
objectarray |
order.linked_credit_notes.id |
string |
order.linked_credit_notes.amount |
number |
order.linked_credit_notes.date |
number |
order.linked_credit_notes.type |
string |
order.linked_credit_notes.status |
string |
order.linked_credit_notes.amount_available |
string |
order.linked_credit_notes.reference_invoice_id |
string |
order.linked_credit_notes.cn_reason_code |
string |
order.linked_credit_notes.cn_create_reason_code |
number |
order.linked_credit_notes.object |
string |
order.shipping_address |
object |
order.shipping_address.first_name |
string |
order.shipping_address.last_name |
string |
order.shipping_address.email |
string |
order.shipping_address.company |
string |
order.shipping_address.phone |
string |
order.shipping_address.line1 |
string |
order.shipping_address.line2 |
string |
order.shipping_address.line3 |
string |
order.shipping_address.city |
string |
order.shipping_address.state_code |
string |
order.shipping_address.state |
string |
order.shipping_address.country |
string |
order.shipping_address.zip |
string |
order.shipping_address.validation_status |
string |
order.shipping_address.object |
string |
order.billing_address |
object |
order.billing_address.first_name |
string |
order.billing_address.last_name |
string |
order.billing_address.email |
string |
order.billing_address.company |
string |
order.billing_address.phone |
string |
order.billing_address.line1 |
string |
order.billing_address.line2 |
string |
order.billing_address.line3 |
string |
order.billing_address.city |
string |
order.billing_address.state_code |
string |
order.billing_address.state |
string |
order.billing_address.country |
string |
order.billing_address.zip |
string |
order.billing_address.validation_status |
string |
order.billing_address.object |
string |
Payment sources — List payment sources
Delta configuration: use it to request incremental data.
| Setting | Value |
|---|---|
| Delta filter | updated_at[after] = {{{encodeURI lastExportDateTime}}} |
| Date format | X |
Response schema:
| Field | Type |
|---|---|
payment_source |
object |
payment_source.id |
string (Primary key) |
payment_source.customer_id |
string |
payment_source.type |
string |
payment_source.reference_id |
string |
payment_source.status |
string |
payment_source.gateway |
string |
payment_source.gateway_account_id |
string |
payment_source.ip_address |
string |
payment_source.issuing_country |
string |
payment_source.created_at |
number |
payment_source.updated_at |
number |
payment_source.resource_version |
number |
payment_source.deleted |
boolean |
payment_source.object |
string |
payment_source.business_entity_id |
string |
payment_source.card |
object |
payment_source.card.first_name |
string |
payment_source.card.last_name |
string |
payment_source.card.iin |
string |
payment_source.card.last4 |
string |
payment_source.card.funding_type |
string |
payment_source.card.expiry_month |
string |
payment_source.card.expiry_year |
string |
payment_source.card.billing_addr1 |
string |
payment_source.card.billing_addr2 |
string |
payment_source.card.billing_city |
string |
payment_source.card.billing_state_code |
string |
payment_source.card.billing_state |
string |
payment_source.card.billing_country |
string |
payment_source.card.billing_zip |
string |
payment_source.card.masked_number |
string |
payment_source.card.object |
string |
payment_source.card.brand |
string |
payment_source.bank_account |
object |
payment_source.bank_account.last4 |
string |
payment_source.bank_account.name_on_account |
string |
payment_source.bank_account.bank_name |
string |
payment_source.bank_account.mandate_id |
string |
payment_source.bank_account.account_type |
string |
payment_source.bank_account.echeck_type |
string |
payment_source.bank_account.account_holder_type |
string |
payment_source.bank_account.email |
string |
payment_source.amazon_payment |
object |
payment_source.amazon_payment.email |
string |
payment_source.amazon_payment.agreement_id |
string |
payment_source.paypal |
object |
payment_source.paypal.email |
string |
payment_source.paypal.agreement_id |
string |
payment_source.mandates |
objectarray |
payment_source.mandates.id |
string |
payment_source.mandates.subscription_id |
string |
payment_source.mandates.created_at |
number |
Price variants — List price variants
Delta configuration: use it to request incremental data.
| Setting | Value |
|---|---|
| Delta filter | updated_at[after] = {{{encodeURI lastExportDateTime}}} |
| Date format | X |
Response schema:
| Field | Type |
|---|---|
price_variant |
object |
price_variant.id |
string (Primary key) |
price_variant.name |
string |
price_variant.description |
string |
price_variant.status |
string |
price_variant.external_name |
string |
price_variant.created_at |
number |
price_variant.updated_at |
number |
price_variant.resource_version |
number |
price_variant.object |
string |
price_variant.business_entity_id |
string |
Products — List products
Delta configuration: use it to request incremental data.
| Setting | Value |
|---|---|
| Delta filter | updated_at[after] = {{{encodeURI lastExportDateTime}}} |
| Date format | X |
Response schema:
| Field | Type |
|---|---|
product |
object |
product.id |
string (Primary key) |
product.name |
string |
product.description |
string |
product.status |
string |
product.created_at |
number |
product.updated_at |
number |
product.resource_version |
number |
product.object |
string |
Promotional credits — List promotional credits
Delta configuration: use it to request incremental data.
| Setting | Value |
|---|---|
| Delta filter | created_at[after] = {{{encodeURI lastExportDateTime}}} |
| Date format | X |
Response schema:
| Field | Type |
|---|---|
promotional_credit |
object |
promotional_credit.id |
string (Primary key) |
promotional_credit.customer_id |
string |
promotional_credit.type |
string |
promotional_credit.amount |
number |
promotional_credit.description |
string |
promotional_credit.credit_type |
string |
promotional_credit.reference |
string |
promotional_credit.closing_balance |
number |
promotional_credit.done_by |
string |
promotional_credit.created_at |
number |
promotional_credit.object |
string |
promotional_credit.currency_code |
string |
promotional_credit.amount_in_decimal |
string |
Quotes — List quotes
Delta configuration: use it to request incremental data.
| Setting | Value |
|---|---|
| Delta filter | updated_at[after] = {{{encodeURI lastExportDateTime}}} |
| Date format | X |
Response schema:
| Field | Type |
|---|---|
quote |
object |
quote.id |
string (Primary key) |
quote.name |
string |
quote.po_number |
string |
quote.customer_id |
string |
quote.subscription_id |
string |
quote.invoice_id |
string |
quote.status |
string |
quote.operation_type |
string |
quote.vat_number |
string |
quote.price_type |
number |
quote.valid_till |
number |
quote.date |
number |
quote.total_payable |
number |
quote.charge_on_acceptance |
number |
quote.sub_total |
number |
quote.total |
number |
quote.credits_applied |
number |
quote.amount_paid |
number |
quote.amount_due |
number |
quote.version |
string |
quote.resource_version |
number |
quote.updated_at |
number |
quote.taxes_inclusive |
boolean |
quote.line_items |
objectarray |
quote.line_items.id |
string |
quote.line_items.date_from |
number |
quote.line_items.date_to |
number |
quote.line_items.unit_amount |
number |
quote.line_items.quantity |
number |
quote.line_items.amount |
number |
quote.line_items.pricing_model |
number |
quote.line_items.is_taxed |
boolean |
quote.line_items.tax_amount |
number |
quote.line_items.tax_rate |
number |
quote.line_items.unit_amount_in_decimal |
number |
quote.line_items.quantity_in_decimal |
string |
quote.line_items.amount_in_decimal |
string |
quote.line_items.discount_amount |
number |
quote.line_items.item_level_discount_amount |
number |
quote.line_items.description |
string |
quote.line_items.entity_type |
string |
quote.line_items.entity_id |
string |
quote.line_items.subscription_id |
string |
quote.line_items.customer_id |
string |
quote.line_items.reference_line_item_id |
string |
quote.line_items.tax_exempt_reason |
string |
quote.line_items.discount_type |
number |
quote.line_items.object |
string |
quote.currency_code |
string |
quote.notes |
string |
quote.expiry_date |
number |
quote.vat_number_prefix |
string |
quote.business_entity_id |
string |
quote.deleted |
boolean |
quote.object |
string |
quote.base_currency_code |
string |
quote.contract_term_start |
string |
quote.contract_term_end |
string |
quote.discounts |
objectarray |
quote.discounts.id |
string |
quote.discounts.invoice_name |
string |
quote.discounts.type |
string |
quote.discounts.percentage |
number |
quote.discounts.amount |
number |
quote.discounts.currency_code |
string |
quote.discounts.duration_type |
string |
quote.discounts.period |
number |
quote.discounts.period_unit |
string |
quote.discounts.included_in_mrr |
boolean |
quote.discounts.apply_on |
string |
quote.discounts.item_price_id |
string |
quote.discounts.created_at |
number |
quote.discounts.apply_till |
number |
quote.discounts.object |
string |
quote.line_item_discounts |
objectarray |
quote.line_item_discounts.line_item_id |
string |
quote.line_item_discounts.discount_type |
string |
quote.line_item_discounts.coupon_id |
string |
quote.line_item_discounts.entity_id |
string |
quote.line_item_discounts.discount_amount |
number |
quote.line_item_discounts.object |
string |
quote.taxes |
objectarray |
quote.taxes.name |
string |
quote.taxes.amount |
number |
quote.taxes.description |
string |
quote.line_item_taxes |
objectarray |
quote.line_item_taxes.line_item_id |
string |
quote.line_item_taxes.tax_name |
string |
quote.line_item_taxes.tax_rate |
number |
quote.line_item_taxes.tax_amount |
number |
quote.line_item_taxes.tax_juris_type |
string |
quote.line_item_taxes.tax_juris_name |
string |
quote.line_item_taxes.tax_juris_code |
string |
quote.line_item_taxes.tax_amount_in_local_currency |
number |
quote.line_item_taxes.local_currency_code |
string |
quote.line_item_taxes.object |
string |
quote.line_item_tiers |
objectarray |
quote.line_item_tiers.line_item_id |
string |
quote.line_item_tiers.starting_unit |
number |
quote.line_item_tiers.ending_unit |
number |
quote.line_item_tiers.quantity_used |
number |
quote.line_item_tiers.unit_amount |
number |
quote.line_item_tiers.starting_unit_in_decimal |
string |
quote.line_item_tiers.ending_unit_in_decimal |
string |
quote.line_item_tiers.quantity_used_in_decimal |
string |
quote.line_item_tiers.unit_amount_in_decimal |
string |
quote.line_item_tiers.pricing_type |
string |
quote.line_item_tiers.package_size |
number |
quote.line_item_tiers.object |
string |
quote.shipping_address |
object |
quote.shipping_address.first_name |
string |
quote.shipping_address.last_name |
string |
quote.shipping_address.email |
string |
quote.shipping_address.company |
string |
quote.shipping_address.phone |
string |
quote.shipping_address.line1 |
string |
quote.shipping_address.line2 |
string |
quote.shipping_address.line3 |
string |
quote.shipping_address.city |
string |
quote.shipping_address.state_code |
string |
quote.shipping_address.state |
string |
quote.shipping_address.country |
string |
quote.shipping_address.zip |
string |
quote.shipping_address.validation_status |
string |
quote.shipping_address.object |
string |
quote.billing_address |
object |
quote.billing_address.first_name |
string |
quote.billing_address.last_name |
string |
quote.billing_address.email |
string |
quote.billing_address.company |
string |
quote.billing_address.phone |
string |
quote.billing_address.line1 |
string |
quote.billing_address.line2 |
string |
quote.billing_address.line3 |
string |
quote.billing_address.city |
string |
quote.billing_address.state_code |
string |
quote.billing_address.state |
string |
quote.billing_address.country |
string |
quote.billing_address.zip |
string |
quote.billing_address.validation_status |
string |
quote.billing_address.object |
string |
Ramps — List subscription ramps
Delta configuration: use it to request incremental data.
| Setting | Value |
|---|---|
| Delta filter | updated_at[after] = {{{encodeURI lastExportDateTime}}} |
| Date format | X |
Response schema:
| Field | Type |
|---|---|
ramp |
object |
ramp.id |
string (Primary key) |
ramp.subscription_id |
string |
ramp.effective_from |
number |
ramp.status |
string |
ramp.created_at |
number |
ramp.updated_at |
number |
ramp.resource_version |
number |
ramp.description |
string |
ramp.object |
string |
ramp.item_prices |
objectarray |
ramp.item_prices.item_price_id |
string |
ramp.item_prices.item_type |
string |
ramp.item_prices.quantity |
number |
ramp.item_prices.quantity_in_decimal |
string |
ramp.item_prices.unit_price |
number |
ramp.item_prices.unit_price_in_decimal |
string |
ramp.item_prices.billing_period |
number |
ramp.item_prices.billing_period_unit |
string |
ramp.item_prices.object |
string |
ramp.discounts |
objectarray |
ramp.discounts.id |
string |
ramp.discounts.invoice_name |
string |
ramp.discounts.type |
string |
ramp.discounts.percentage |
number |
ramp.discounts.amount |
number |
ramp.discounts.currency_code |
string |
ramp.discounts.duration_type |
string |
ramp.discounts.period |
number |
ramp.discounts.period_unit |
string |
ramp.discounts.included_in_mrr |
boolean |
ramp.discounts.apply_on |
string |
ramp.discounts.item_price_id |
string |
ramp.discounts.created_at |
number |
ramp.discounts.apply_till |
number |
ramp.discounts.object |
string |
ramp.coupons |
objectarray |
ramp.coupons.coupon_id |
string |
ramp.coupons.object |
string |
ramp.item_tiers |
objectarray |
ramp.item_tiers.item_price_id |
string |
ramp.item_tiers.starting_unit |
number |
ramp.item_tiers.ending_unit |
number |
ramp.item_tiers.price |
number |
ramp.item_tiers.object |
string |
Subscriptions — List subscriptions
Delta configuration: use it to request incremental data.
| Setting | Value |
|---|---|
| Delta filter | updated_at[after] = {{{encodeURI lastExportDateTime}}} |
| Date format | X |
Response schema:
| Field | Type |
|---|---|
subscription |
object |
subscription.id |
string (Primary key) |
subscription.currency_code |
string |
subscription.start_date |
number |
subscription.trial_end |
number |
subscription.remaining_billing_cycles |
number |
subscription.po_number |
string |
subscription.customer_id |
string |
subscription.plan_id |
number |
subscription.plan_quantity |
number |
subscription.plan_unit_price |
number |
subscription.plan_amount |
number |
subscription.billing_period |
number |
subscription.billing_period_unit |
string |
subscription.plan_free_quantity |
number |
subscription.status |
string |
subscription.trial_start |
number |
subscription.trial_end_action |
string |
subscription.current_term_start |
number |
subscription.current_term_end |
number |
subscription.next_billing_at |
number |
subscription.created_at |
number |
subscription.started_at |
number |
subscription.activated_at |
number |
subscription.gift_id |
string |
subscription.override_relationship |
boolean |
subscription.pause_date |
number |
subscription.resume_date |
number |
subscription.contract_term_billing_cycle_on_renewal |
number |
subscription.created_from_ip |
string |
subscription.resource_version |
number |
subscription.updated_at |
number |
subscription.has_scheduled_changes |
boolean |
subscription.has_scheduled_advance_invoices |
boolean |
subscription.payment_source_id |
string |
subscription.plan_free_quantity_in_decimal |
string |
subscription.plan_amount_in_decimal |
string |
subscription.cancel_reason |
string |
subscription.cancelled_at |
number |
subscription.cancel_schedule_created_at |
number |
subscription.offline_payment_method |
string |
subscription.channel |
string |
subscription.net_term_days |
number |
subscription.active_id |
string |
subscription.due_invoices_count |
number |
subscription.due_since |
number |
subscription.total_dues |
number |
subscription.mrr |
number |
subscription.exchange_rate |
number |
subscription.base_currency_code |
string |
subscription.invoice_notes |
string |
subscription.deleted |
boolean |
subscription.object |
string |
subscription.coupon |
string |
subscription.auto_collection |
string |
subscription.due_compliant |
boolean |
subscription.business_entity_id |
string |
subscription.brand_identifier |
string |
subscription.create_pending_invoices |
boolean |
subscription.auto_close_invoices |
boolean |
subscription.cancel_reason_code |
string |
subscription.free_period |
number |
subscription.free_period_unit |
string |
subscription.changes_scheduled_at |
number |
subscription.subscription_items |
objectarray |
subscription.subscription_items.item_price_id |
string |
subscription.subscription_items.item_type |
string |
subscription.subscription_items.quantity |
number |
subscription.subscription_items.quantity_in_decimal |
string |
subscription.subscription_items.metered_quantity |
string |
subscription.subscription_items.unit_price |
number |
subscription.subscription_items.unit_price_in_decimal |
string |
subscription.subscription_items.amount |
number |
subscription.subscription_items.amount_in_decimal |
string |
subscription.subscription_items.free_quantity |
number |
subscription.subscription_items.free_quantity_in_decimal |
string |
subscription.subscription_items.trial_end |
number |
subscription.subscription_items.billing_cycles |
number |
subscription.subscription_items.service_period_days |
number |
subscription.subscription_items.charge_on_event |
string |
subscription.subscription_items.charge_once |
boolean |
subscription.subscription_items.charge_on_option |
string |
subscription.subscription_items.proration_type |
string |
subscription.subscription_items.installment_number |
number |
subscription.subscription_items.object |
string |
subscription.item_tiers |
objectarray |
subscription.item_tiers.item_price_id |
string |
subscription.item_tiers.starting_unit |
number |
subscription.item_tiers.ending_unit |
number |
subscription.item_tiers.price |
number |
subscription.item_tiers.starting_unit_in_decimal |
string |
subscription.item_tiers.ending_unit_in_decimal |
string |
subscription.item_tiers.price_in_decimal |
string |
subscription.item_tiers.pricing_type |
string |
subscription.item_tiers.package_size |
number |
subscription.charged_items |
objectarray |
subscription.charged_items.item_price_id |
string |
subscription.charged_items.last_charged_at |
number |
subscription.coupons |
objectarray |
subscription.coupons.coupon_id |
string |
subscription.coupons.apply_till |
number |
subscription.coupons.applied_count |
number |
subscription.coupons.coupon_code |
string |
subscription.coupons.object |
string |
subscription.shipping_address |
object |
subscription.shipping_address.first_name |
string |
subscription.shipping_address.last_name |
string |
subscription.shipping_address.email |
string |
subscription.shipping_address.company |
string |
subscription.shipping_address.phone |
string |
subscription.shipping_address.line1 |
string |
subscription.shipping_address.line2 |
string |
subscription.shipping_address.line3 |
string |
subscription.shipping_address.city |
string |
subscription.shipping_address.state_code |
string |
subscription.shipping_address.state |
string |
subscription.shipping_address.country |
string |
subscription.shipping_address.zip |
string |
subscription.shipping_address.validation_status |
string |
subscription.shipping_address.object |
string |
subscription.contract_term |
object |
subscription.contract_term.id |
string |
subscription.contract_term.status |
string |
subscription.contract_term.contract_start |
number |
subscription.contract_term.contract_end |
number |
subscription.contract_term.billing_cycle |
number |
subscription.contract_term.action_at_term_end |
string |
subscription.contract_term.total_contract_value |
number |
subscription.contract_term.total_contract_value_before_tax |
number |
subscription.contract_term.cancellation_cutoff_period |
number |
subscription.contract_term.created_at |
number |
subscription.contract_term.subscription_id |
string |
subscription.contract_term.remaining_billing_cycles |
number |
subscription.contract_term.object |
string |
subscription.referral_info |
object |
subscription.referral_info.referral_code |
string |
subscription.referral_info.coupon_code |
string |
subscription.referral_info.referrer_id |
string |
subscription.referral_info.external_reference_id |
string |
subscription.referral_info.reward_status |
string |
subscription.referral_info.referral_system |
string |
subscription.referral_info.account_id |
string |
subscription.referral_info.campaign_id |
string |
subscription.referral_info.external_campaign_id |
string |
subscription.referral_info.friend_offer_type |
string |
subscription.referral_info.referrer_reward_type |
string |
subscription.referral_info.notify_referral_system |
string |
subscription.referral_info.destination_url |
string |
subscription.referral_info.post_purchase_widget_enabled |
boolean |
subscription.discounts |
objectarray |
subscription.discounts.id |
string |
subscription.discounts.invoice_name |
string |
subscription.discounts.type |
string |
subscription.discounts.percentage |
number |
subscription.discounts.amount |
number |
subscription.discounts.currency_code |
string |
subscription.discounts.duration_type |
string |
subscription.discounts.period |
number |
subscription.discounts.period_unit |
string |
subscription.discounts.included_in_mrr |
boolean |
subscription.discounts.apply_on |
string |
subscription.discounts.item_price_id |
string |
subscription.discounts.created_at |
number |
subscription.discounts.apply_till |
number |
subscription.discounts.object |
string |
subscription.meta_data |
object |
Transactions — List transactions
Delta configuration: use it to request incremental data.
| Setting | Value |
|---|---|
| Delta filter | updated_at[after] = {{{encodeURI lastExportDateTime}}} |
| Date format | X |
Response schema:
| Field | Type |
|---|---|
transaction |
object |
transaction.id |
string (Primary key) |
transaction.customer_id |
string |
transaction.subscription_id |
string |
transaction.gateway_account_id |
string |
transaction.payment_source_id |
string |
transaction.payment_method |
string |
transaction.reference_number |
string |
transaction.gateway |
string |
transaction.type |
string |
transaction.date |
number |
transaction.settled_at |
number |
transaction.exchange_rate |
number |
transaction.currency_code |
string |
transaction.amount |
number |
transaction.id_at_gateway |
string |
transaction.status |
string |
transaction.fraud_flag |
string |
transaction.initiator_type |
string |
transaction.three_d_secure |
number |
transaction.authorization_reason |
string |
transaction.error_code |
string |
transaction.error_text |
string |
transaction.voided_at |
number |
transaction.resource_version |
number |
transaction.updated_at |
number |
transaction.amount_unused |
number |
transaction.masked_card_number |
string |
transaction.reference_transaction_id |
string |
transaction.refunded_txn_id |
string |
transaction.reference_authorization_id |
string |
transaction.amount_capturable |
number |
transaction.reversal_transaction_id |
boolean |
transaction.deleted |
boolean |
transaction.object |
string |
transaction.gateway_settlement_key |
string |
transaction.payment_method_details |
string |
transaction.business_entity_id |
string |
transaction.base_currency_code |
string |
transaction.linked_invoices |
objectarray |
transaction.linked_invoices.invoice_id |
string |
transaction.linked_invoices.applied_amount |
string |
transaction.linked_invoices.applied_at |
number |
transaction.linked_invoices.invoice_date |
number |
transaction.linked_invoices.invoice_total |
number |
transaction.linked_invoices.invoice_status |
string |
transaction.linked_invoices.object |
string |
transaction.linked_credit_notes |
objectarray |
transaction.linked_credit_notes.cn_id |
string |
transaction.linked_credit_notes.applied_amount |
string |
transaction.linked_credit_notes.applied_at |
number |
transaction.linked_credit_notes.cn_reason_code |
string |
transaction.linked_credit_notes.cn_create_reason_code |
number |
transaction.linked_credit_notes.cn_date |
number |
transaction.linked_credit_notes.cn_total |
number |
transaction.linked_credit_notes.cn_status |
string |
transaction.linked_credit_notes.cn_reference_invoice_id |
string |
transaction.linked_credit_notes.object |
string |
transaction.linked_refunds |
objectarray |
transaction.linked_refunds.txn_id |
string |
transaction.linked_refunds.txn_status |
string |
transaction.linked_refunds.txn_date |
number |
transaction.linked_refunds.txn_amount |
number |
transaction.linked_refunds.object |
string |
transaction.linked_payments |
objectarray |
transaction.linked_payments.id |
string |
transaction.linked_payments.status |
string |
transaction.linked_payments.amount |
number |
transaction.linked_payments.date |
number |
transaction.linked_payments.object |
string |
Unbilled charges — List unbilled charges
Response schema:
| Field | Type |
|---|---|
unbilled_charge |
object |
unbilled_charge.id |
string (Primary key) |
unbilled_charge.customer_id |
string |
unbilled_charge.subscription_id |
string |
unbilled_charge.date_from |
number |
unbilled_charge.date_to |
number |
unbilled_charge.unit_amount |
number |
unbilled_charge.pricing_model |
string |
unbilled_charge.quantity |
number |
unbilled_charge.amount |
number |
unbilled_charge.currency_code |
string |
unbilled_charge.discount_amount |
number |
unbilled_charge.description |
string |
unbilled_charge.entity_type |
string |
unbilled_charge.entity_id |
string |
unbilled_charge.is_voided |
boolean |
unbilled_charge.voided_at |
number |
unbilled_charge.updated_at |
number |
unbilled_charge.resource_version |
number |
unbilled_charge.deleted |
boolean |
unbilled_charge.object |
string |
unbilled_charge.quantity_in_decimal |
string |
unbilled_charge.unit_amount_in_decimal |
string |
unbilled_charge.amount_in_decimal |
string |
unbilled_charge.discount_type |
number |
unbilled_charge.subscription_currency_code |
string |
unbilled_charge.tiers |
objectarray |
unbilled_charge.tiers.starting_unit |
number |
unbilled_charge.tiers.ending_unit |
number |
unbilled_charge.tiers.quantity_used |
number |
unbilled_charge.tiers.unit_amount |
number |
unbilled_charge.tiers.object |
string |
unbilled_charge.line_item_tiers |
objectarray |
unbilled_charge.line_item_tiers.line_item_id |
string |
unbilled_charge.line_item_tiers.starting_unit |
number |
unbilled_charge.line_item_tiers.ending_unit |
number |
unbilled_charge.line_item_tiers.quantity_used |
number |
unbilled_charge.line_item_tiers.unit_amount |
number |
unbilled_charge.line_item_tiers.starting_unit_in_decimal |
string |
unbilled_charge.line_item_tiers.ending_unit_in_decimal |
string |
unbilled_charge.line_item_tiers.quantity_used_in_decimal |
string |
unbilled_charge.line_item_tiers.unit_amount_in_decimal |
string |
unbilled_charge.line_item_tiers.pricing_type |
string |
unbilled_charge.line_item_tiers.package_size |
number |
unbilled_charge.line_item_tiers.object |
string |
Usages — List usages
Delta configuration: use it to request incremental data.
| Setting | Value |
|---|---|
| Delta filter | updated_at[after] = {{{encodeURI lastExportDateTime}}} |
| Date format | X |
Response schema:
| Field | Type |
|---|---|
usage |
object |
usage.id |
string (Primary key) |
usage.subscription_id |
string |
usage.item_price_id |
string |
usage.quantity |
number |
usage.quantity_in_decimal |
string |
usage.usage_date |
number |
usage.source |
string |
usage.note |
string |
usage.created_at |
number |
usage.updated_at |
number |
usage.resource_version |
number |
usage.line_item_id |
string |
usage.deleted |
boolean |
usage.object |
string |
Virtual bank accounts — List virtual bank accountss
Delta configuration: use it to request incremental data.
| Setting | Value |
|---|---|
| Delta filter | updated_at[after] = {{{encodeURI lastExportDateTime}}} |
| Date format | X |
Response schema:
| Field | Type |
|---|---|
virtual_bank_account |
object |
virtual_bank_account.id |
string (Primary key) |
virtual_bank_account.customer_id |
string |
virtual_bank_account.email |
string |
virtual_bank_account.scheme |
string |
virtual_bank_account.bank_name |
string |
virtual_bank_account.account_number |
string |
virtual_bank_account.routing_number |
string |
virtual_bank_account.swift_code |
string |
virtual_bank_account.gateway |
string |
virtual_bank_account.gateway_account_id |
string |
virtual_bank_account.resource_version |
string |
virtual_bank_account.updated_at |
number |
virtual_bank_account.created_at |
number |
virtual_bank_account.reference_id |
string |
virtual_bank_account.iban |
string |
virtual_bank_account.deleted |
boolean |
virtual_bank_account.object |
string |
virtual_bank_account.account_type |
string |
virtual_bank_account.account_holder_name |
string |