Integrations

Data Exports

In addition to our default exporting options we also support data exports to your data warehouse and object storage location directly.

🤝 Premium Add-on

Please contact our commercial team if you are interested in using this functionality.

Integrations

We currently support the following destinations when it comes to exporting data from the Solvimon Platform:

Data warehouses

The following data warehouse destinations are supported:

Object storage

The following object storage locations are supported:

Note that for object storage locations we only support full overwrite syncs and incremental append syncs with at least once delivery.

If your preferred source is not listed, please get in touch with us and we should be able to facilitate this.

Configuration

We support the following frequencies when it comes to data syncing:

  • One-off: We can make an one-off data export into your preferred location.
  • Daily: We can replicate data daily to your preferred location, where we update the table with updates on a daily basis.
  • Hourly: We also support hourly syncs, but allow this on a case-by-case basis.

In addition we support the following data syncing modes:

  • Full Refresh (Overwrite): The table or object storage folder is overwritten each data sync. For object storage this means any data that was previously in the folder will be deleted.
  • Full Refresh (Append): Previous and new data is appended to the table or object storage each data sync. This means all data is synced into the destination without affecting previous data. This causes data duplication for data warehouse destinations.
  • Incremental Sync (Append): Each sync new data is appended (inserted) into the relevant table or object storage location. This mode does not guarantee only once delivery hence data duplication might occur.
  • Incremental Sync (Append + Deduplication): Same as previous mode but also de-duplicates data in the table destination. This mode is not supported when choosing for object storage. For most data warehouses we can support append with deduplication.

For most of our exports the data syncing mode is automatically selected.

Datasets

We currently support the following datasets that can be exported:

  • Customers: An export of all your customers with relevant columns.
    • Supported frequencies: One-off, Daily, (Hourly).
    • Data syncing mode: Full Refresh (Overwrite).
  • Subscriptions: An export of all your subscriptions with relevant columns.
    • Supported frequencies: One-off, Daily, (Hourly).
    • Data syncing mode: Full Refresh (Overwrite).
  • Invoice lines: An export of all invoice lines with relevant columns.
    • Supported frequencies: One-off, Daily, (Hourly).
    • Data syncing mode: Full Refresh (Overwrite).
  • Products: An export of all products with relevant columns.
    • Supported frequencies: One-off, Daily, (Hourly).
    • Data syncing mode: Full Refresh (Overwrite).

The dataset definitions can be found below.

Dataset definitions

📘 Additional Solvimon columns

Together with the dataset columns listed, also some additional Solvimon columns are present in the data export. This includes an export timestamp, unique row identifier and perhaps additional columns if necessary.

Customers

ColumnColumn NameTypeDescription
Address Linecustomer_address_lineSTRINGThe address line of the customer.
Citycustomer_citySTRINGThe city of the customer.
Country Codecustomer_country_codeSTRINGThe ISO country code of the customer.
Created Datecustomer_created_dateTIMESTAMPThe timestamp that the customer was created.
Emailcustomer_emailSTRINGThe email address of the customer.
Namecustomer_nameSTRINGThe name of the customer. In case of an organization this is the legal name, in case of an individual this is first and last name.
Postal Codecustomer_postal_codeSTRINGThe postal code of the customer.
Referencecustomer_referenceSTRINGThe reference of the customer.
Resource IDcustomer_resource_idSTRINGThe customer ID (Solvimon generated) used in Solvimon Desk and API’s.
Statecustomer_stateSTRINGThe state (location) of the customer, e.g. New York.
Statuscustomer_statusSTRINGThe status of the customer, e.g. active.
Typecustomer_typeSTRINGThe type of the customer, e.g. organization or individual.
Tax IDtax_idSTRINGThe VAT code to identify the tax of your customers.
Customer custom fieldscustom_fieldsJSONThe customer custom fields and its values that you have defined in the platform.

Subscriptions

ColumnColumn NameTypeDescription
SubscriptionsubscriptionSTRINGThe name of the subscription.
Referencesubscription_referenceSTRINGThe reference of the subscription.
Resource IDsubscription_resource_idSTRINGThe subscription ID (Solvimon generated) used in Solvimon Desk and API’s.
Statussubscription_statusSTRINGThe status of the subscription
Created Datesubscription_created_dateTIMESTAMPThe creation timestamp of the subscription.
Last Modifiedsubscription_last_modifiedTIMESTAMPThe last modified timestamp of the subscription.
Billing Entitybilling_entitySTRINGThe name of the billing entity.
Billing Entity Resource IDbilling_entity_resource_idSTRINGThe billing entity ID (Solvimon generated) used in Solvimon Desk and API’s.
Billing Entity Tax IDbilling_entity_tax_idSTRINGThe tax ID of the billing entity.
Billing Period Frequencybilling_period_frequencySTRINGThe frequency of the billing period type, e.g. 3 with period type month, means every 3 months.
Billing Period Typebilling_period_typeSTRINGThe type of the billing period, e.g. month
Billing Timebilling_timeSTRINGThe billing time of the billing period type, e.g. calendar or exact.
Customercustomer_nameSTRINGThe name of the customer. In case of an organization this is the legal name, in case of an individual this is first and last name.
Customer Referencecustomer_referenceSTRINGThe reference of the customer used in the subscription..
Customer Resource IDcustomer_resource_idSTRINGThe customer ID (Solvimon generated) used in Solvimon Desk and API’s.
Due Date Period Typedue_date_period_typeSTRINGThe type of the due date period setting, e.g. day.
Due Date Perioddue_date_period_valueSTRINGThe value of the due date period setting, e.g. 14 when due date period type is day means the due date period is 14 days.
Initial Term Typeinitial_term_typeSTRINGThe type of the initial term of the subscription.
Initial Terminitial_term_valueSTRINGThe value of the initial term.
Renewal Term Typerenewal_term_typeSTRINGThe type of the renewal term of the subscription.
Renewal Termrenewal_term_valueSTRINGThe value of the renewal term.
Payment Acceptor Resource IDpayment_acceptor_resource_idSTRINGThe payment acceptor ID (Solvimon generated) used in Solvimon Desk and API’s.
Pricing Planpricing_planSTRINGThe name of the pricing plan used in the subscription.
Pricing Plan Referencepricing_plan_referenceSTRINGThe reference of the pricing plan used in the subscription.
Pricing Plan Resource IDpricing_plan_resource_idSTRINGThe pricing plan ID (Solvimon generated) used in Solvimon Desk and API’s.
Schedule Startpricing_plan_schedule_startTIMESTAMPThe schedule start date of the subscription.
Schedule Endpricing_plan_schedule_endTIMESTAMPThe schedule end date of the subscription.
Pricing Plan Versionpricing_plan_versionSTRINGThe version of the pricing plan used in the subscription.
Pricing Plan Creation Datepricing_plan_version_create_dateSTRINGThe creation date of the version of the pricing plan used in the subscription.
Pricing Plan Last Modified Datepricing_plan_version_last_modifiedSTRINGThe last modified date of the version of the pricing plan.

Invoice lines

ColumnColumn NameTypeDescription
Customer Citycustomer_citySTRINGThe city associated with the customer.
Customer Countrycustomer_country_codeSTRING2 letter ISO-code of the customer’s country.
CustomercustomerSTRINGIn case of an organization this is the legal name, in case of an individual this is first and last name.
Customer Postal Codecustomer_postal_codeSTRINGThe postal code of the customer.
Customer Referencecustomer_referenceSTRINGReference of the customer.
Customer Timezonecustomer_timezoneSTRINGTimezone of the customer.
Created Dateinvoice_created_dateTIMESTAMPThe created timestamp of the invoice in UTC.
Currencyinvoice_currencySTRINGThe currency used for the invoice.
Dateinvoice_dateTIMESTAMPThe invoice timestamp/date in UTC.
Due Dateinvoice_due_dateTIMESTAMPThe invoice due timestamp/date in UTC.
Billing Start Datebilling_period_start_dateTIMESTAMPThe start timestamp/date of the billing period associated with the product in UTC.
Billing End Datebilling_period_end_dateTIMESTAMPThe end timestamp/date of the billing period associated with the product in UTC.
Base Amount Currencybase_amount_currencySTRINGThe currency code of the base quantity on the invoice line.
Base Amount Quantitybase_amount_quantityFLOATThe base amount (without tax in the base amount currency) quantity.
Total Amount Currencytotal_amount_currencySTRINGThe currency code of the total quantity on the invoice line.
Total Amount Quantitytotal_amount_quantityNUMBERThe total amount (with tax in the total amount currency) quantity.
Line Typeinvoice_line_typeSTRINGThe type of the invoice line, can be COMMITMENT, DISCOUNT, ADJUSTMENT and PRICING.
Numberinvoice_numberSTRINGInvoice number to identify the invoices.
Quantityinvoice_quantityNUMBERThe invoice amount quantity in the invoice currency.
Resource IDinvoice_resource_idSTRINGThe invoice ID (Solvimon generated) used in Solvimon Desk and API’s.
Statusinvoice_statusSTRINGThe status of the invoice.
Last Updateinvoice_update_dateTIMESTAMPThe last update timestamp/date of the invoice.
Pricing Planpricing_planSTRINGThe name of the pricing plan associated with the invoice line.
Pricing Plan Versionpricing_versionNUMBERThe pricing plan version associated with the invoice line.
Product Categoryproduct_categorySTRINGThe product category name associated with the invoice line.
Product Item(s)product_itemsSTRINGThe product item name(s) which are associated with the invoice line.
Product(s)productsSTRINGThe product name(s) which are associated with the invoice line.
Product referencesproduct_referencesSTRINGUnique reference for the products.

Products

ColumnColumn NameTypeDescription
Meter Value Calculation Typemeter_value_calculation_typeSTRINGType of the meter value calculation associated with the product.
Meter Value Resource IDmeter_value_resource_idSTRINGResource ID of the meter value associated with the product.
Meter Value Calculation Namemeter_value_calculation_nameSTRINGName of the meter value calculation associated with the product.
Meter Value Calculation Resource IDmeter_value_calculation_resource_idSTRINGResource ID of the meter value calculation associated with the product.
Meter Value Calculation Referencemeter_value_calculation_referenceSTRINGReference of the meter value calculation associated with the product.
Parent Product Descriptionparent_product_descriptionSTRINGParent product description associated with the product.
Parent Product Nameparent_product_nameSTRINGThe name of the parent product associated with the product.
Parent Product Referenceparent_product_referenceSTRINGParent product reference associated with the product.
Parent Product Resource IDparent_product_resource_idSTRINGParent product resource ID associated with the product.
Parent Product Statusparent_product_statusSTRINGParent product status associated with the product.
Parent Product Typeparent_product_typeSTRINGParent product type associated with the product.
Category Descriptionproduct_category_descriptionSTRINGDescription of the product category associated with the product.
Product Categoryproduct_categorySTRINGThe product category name associated with the product.
Category Referenceproduct_category_referenceSTRINGReference of the category associated with the product.
Category Resource IDproduct_category_resource_idSTRINGResource ID of the category associated with the product.
Descriptionproduct_descriptionSTRINGDescription of the product(s).
Item Charge Typeproduct_item_charge_typeSTRINGCharging type of the product item(s) associated to the product.
Item Descriptionproduct_item_descriptionSTRINGDescription of the product item(s) associated to the product.
Item(s)product_itemSTRINGName of the product item(s) associated to the product.
Item Referenceproduct_item_referenceSTRINGReference of the product item(s) associated to the product.
Item Resource IDproduct_item_resource_idSTRINGResource ID of the product item(s) associated to the product.
Product(s)productSTRINGThe name of the product(s).
Referenceproduct_referenceSTRINGReference of the product.
Resource IDproduct_resource_idSTRINGResource ID of the product.
Statusproduct_statusSTRINGThe status of the product.
Typeproduct_typeSTRINGThe type of the product.