For AI agents: a documentation index is available at the root level at /llms.txt and /llms-full.txt. Append /llms.txt to any URL for a page-level index, or .md for the markdown version of any page.
Logo
LoginSandbox
Platform GuidesAPI DocsSDKMCP ServerChangelog
Platform GuidesAPI DocsSDKMCP ServerChangelog
  • Getting started
    • Introduction
    • Concepts
    • Onboarding guide
  • Use cases
    • Monetizing an AI agent
    • Pricing models for AI products
    • Configuring entitlements for AI products
  • Usage metering & events
    • Meters
    • Usage events
    • Unmatched events
    • Event reprocessing
  • Products & plans
    • Product Catalog
    • Pricing Plans
    • Features & Entitlements
  • Wallets & credits
    • Credit types & wallets
    • Credits in pricing plans
  • Customers & subscriptions
    • Customers
    • Subscriptions
    • Quotes
  • Invoicing
    • Invoices
    • Invoice corrections
    • Payment Collections
    • Tax
    • Currencies & Exchange rates
    • E-invoicing
  • Analytics & reporting
    • Insights
    • Report downloads
    • Revenue Recognition & Deferred Revenue
  • Integrations
    • CRM
    • ERP
    • Email Providers
    • Data Imports: Event File Uploads
    • Data Exports
    • Payment Service Providers
  • Settings & admin
    • Billing entities
    • Payment Options
    • User management
    • Customising invoices
    • Custom fields
    • Default platform settings
    • API key creation
    • Alert Rules
    • Workflows
  • Workflows
    • Workflow Triggers
    • Workflow Actions
    • Monitoring and Audit
    • Common Use Cases
  • For developers
    • Introduction
    • Authentication
    • Local development setup
    • API
    • Errors
    • Troubleshooting
    • Query Parameters
    • Expanding Responses
    • Idempotency
    • Timestamp formatting
    • Webhooks
    • Locale
    • MCP Server
LoginSandbox
On this page
  • CSV formatting
  • Field mapping
  • Overview
  • Preparing Your CSV File
  • API Endpoint
  • Desk Environment
  • Instructions for CSV Upload
Integrations

Data Imports: Event File Uploads

Was this page helpful?
Previous

Data Exports

Next
Built with

CSV formatting

This step details the formatting of the CSV files which should be written to your cloud storage destination.

The following CSV formatting is assumed:

CSV formatting propertyDescription
DelimiterThe character delimiting individual cells in the CSV data. This may only be a 1-character string. For tab-delimited data enter \\t. By default we assume this to be ,.
Double QuoteThe character delimiting individual cells in the CSV data. This may only be a 1-character string. For tab-delimited data enter ‘\t’.
EncodingThe character encoding of the CSV data. By default we assume this to be utf8.
Escape CharacterThe character used for escaping special characters. By default we disallow escaping.
False ValuesA set of case-sensitive strings that should be interpreted as false values. By default this is set to the following set: n, no, f, false, off, 0.
True ValuesA set of case-sensitive strings that should be interpreted as true values. BY default this is set to the following set: y, yes, t, true, on, 1.
Null ValuesA set of case-sensitive strings that should be interpreted as null values. By default we interpret NA as a null value.
Quote CharacterThe character used for quoting CSV values. By default we assume this to be using double quoting ".

If your CSV file is formatted differently than the above, please inform us. If your CSV formatting is in line with the above, you will need to make sure your data is written into CSV files in your particular cloud storage location.

Field mapping

Overview

In Solvimon, the ingestion of events is directly associated with meters. Each event that you wish to ingest must be linked to a specific meter, and all fields associated with that meter must be accurately populated to ensure successful event ingestion.

Preparing Your CSV File

To facilitate the correct preparation of your CSV files for event ingestion, ensure that all necessary fields associated with the meter in question are included. We provide a convenient API endpoint to assist you in generating a template CSV file with the required headers, or you can download the template from our desk environment.

API Endpoint

GET https://live.api.solvimon.com/v1/meters/{meter_id}/meter-data-file

Please find the api reference of this endpoint here. This endpoint retrieves a CSV file containing all the necessary headers required for the event ingestion associated with a specific meter. The CSV file generated by this endpoint serves as a template to guide the formatting of your data for successful upload.

Desk Environment

Another option is to retrieve the template from desk. Navigate to the file tab in solvimon desk and select upload (or you can find it directly by going to https://desk.solvimon.com/files/upload. When selecting a meter a card will pop up which will allow you to download a template to ingest events for that meter.

Instructions for CSV Upload

  1. Use the Provided CSV Template: Download the CSV template via the aforementioned API endpoint. Fill in the event data in the fields as specified in the template to ensure compatibility with our system.
  2. Uploading Your CSV File: If you follow the template format exactly, you can upload your CSV file directly to our system without the need for additional mapping.
  3. Custom Column Names and Ordering: If you prefer to maintain your own column names and ordering, contact us to set up a custom mapping. This will allow us to accurately process your CSV files according to your specific format.