ChargeOver

ChargeOver is a cloud-based billing tool that automates payment acceptance, invoicing, and contacting customers.

Data integration: Skyvia supports importing data to and from ChargeOver, exporting ChargeOver data to CSV files, replicating ChargeOver data to relational databases, and synchronizing ChargeOver data with other cloud apps and relational databases.

Backup: Skyvia Backup does not support ChargeOver.

Query: Skyvia Query supports ChargeOver.

ChargeOver-Specific Features and Limitations

Skyvia has the following features and limitations for ChargeOver:

  • The Pricemodel field of the Items table is a JSON array. If you insert data to this field the values have to be specified in the JSON array format. For example:
    [
        {
            "currency_iso4217": "USD",
            "base": 195.95,
            "paycycle": "mon",
            "pricemodel": "fla"
        },
        {
            "currency_iso4217": "CAD",
            "base": 195.95,
            "paycycle": "mon",
            "pricemodel": "fla"
        }
    ]
  • You can use the following stored procedures to update the data in the Subscriptions table:

    call CancelSubscription(:Id,:Comments,:CancelReasonId) - cancels the subscription.

    call SuspendSubscription(:Id,:Suspendfrom_datetime,:Suspendto_datetime) - pauses the subscription for the undefined period of time.

    call UnsuspendSubscription(:Id) - renews the subscription.

Custom Fields

Skyvia supports the custom fields in the AdminWorkers, Contacts, Customers, Invoices, InvoiceLineItems, Items, Subscriptions, SubscriptionLineItems and Transactions tables. In Skyvia these fields have static names like Custom1, Custom2, Custom3…Custom20. 3 such fields are available for the Items table, 5 for AdminWorkers, InvoiceLineItems, and Transactions tables, and 20 — for other tables from this list. They have static string data type and default length of 256 characters. You can perform DML operations against such fields in case these fields were created in ChargeOver UI. Otherwise you will get the error: You must provide a valid [custom_ХХ] value

DML Operations

Skyvia supports the following DML operations for ChargeOver objects:

  • INSERT, UPDATE, DELETE: Contacts, Customers, Items, Subscriptions.
  • INSERT, DELETE - CreditCards.
  • INSERT, UPDATE - Invoices, Quotes.
  • INSERT - Transactions.

Replication with Incremental Updates and Synchronization

Replication with Incremental Updates is supported for the following objects:

Customers, Contacts, Subscriptions, Items, ItemTierSets, CreditCards, Coupons, AdminWorkers, Invoices, Quotes.

The CreditCards, Coupons, Invoices-, and Quotes have only the CreatedDate field and do not have the UpdatedDate. It means that only the new records will be considered by the Incremental Replication.

Synchronization is supported for the following objects: Customers, Subscriptions, Items, Contacts.

ChargeOver Connections

To connect to ChargeOver, you need to specify the following connection parameters:

  • Subdomain — your ChargeOver subdomain value. You can obtain it from the URL of ChargeOver page you work with. For example, if the URL is https://yoursubdomain.chargeover.com/ you need only the yoursubdomain part.
  • Public Key — the public key generated on ChargeOver side, that you obtain when enabling REST API.
  • Private Key — the private key generated on ChargeOver side, that you obtain when enabling REST API.

    To obtain the Public Key and Private Key, you need to sign in with ChargeOver, click on the gear symbol in the top right corner of the ChargeOver window. On the left menu click Developer –> More dev tools. Select the REST API block and click Get Started.

    enable api

  • Source TimeZone - change the timezone if the ChargeOver timezone differs from your local timezone.
  • Optionally, select the Suppress Extended Requests checkbox to reduce the number of API calls. For some objects Trello API returns only part of the fields when querying multiple records. In order to query values of additional fields, Skyvia performs additional extended requests. Such API requests can be performed for each record of such object. However, this can decrease performance and significantly increase the number of API calls used.

    To reduce the number of API calls, you can select the Suppress Extended Requests checkbox. However, please note that some of the fields in such objects will not be available in Skyvia (will return empty values) even if they have values in ChargeOver because its API does not return them without extended requests.

    Connection window

At the end, use the Test Connection button to make sure that the connection is successful and then click Create Connection.

Supported Actions and Actions Specifics

ChargeOver connector supports the following actions: