Mercos

Overview

Mercos data synced to V4MOS.AI, through the integration's own endpoints

The V4MOS.AI Mercos API gives you the raw records synced from the Mercos accounts connected to your organization: B2B orders, customers, products and product categories. Rows come as they were synced, with the warehouse column names (snake_case), so you can load them straight into your BI. All endpoints use the /v1/mercos prefix and the same authentication, pagination and response format.

Getting started

Base URL: https://data.v4mos.ai. Every call requires your API credentials and the organizationId — see Authentication.

  1. Connect Mercos in app.v4mos.ai (Connected accounts) and wait for the first sync.
  2. Call any endpoint below with your organizationId, for example GET /v1/mercos/orders?organizationId=….
  3. Every row carries integration_id and integration_name: the connected account it came from. To read a single account, pass that value as integrationId.

Available endpoints

Resources

EndpointWhat one row isdateFrom / dateTo filter
GET /v1/mercos/ordersOne row per B2B order: number, customer, status, billing status, total, freight, payment terms and items. Field names follow the Mercos API (Portuguese).data_emissao
GET /v1/mercos/customersOne row per customer (client) of the Mercos account: type, segment, network, city and state.ultima_alteracao
GET /v1/mercos/productsOne row per product: code, category, unit, table and minimum prices, stock balance and status.ultima_alteracao
GET /v1/mercos/product-categoriesOne row per product category, with its parent category.ultima_alteracao

Pagination and filters

  • page (default 1) and limit (default 500, max 5000). meta.hasNextPage says whether another page exists; rows come in a stable order, so walk the pages until it is false.
  • dateFrom / dateTo (YYYY-MM-DD, inclusive) filter by the date column shown in the table above. Resources without one reject them.
  • integrationId keeps the rows of one connected account.
  • Answers are cached for 30 minutes and the data is synced once a day — see Data sync.

Personal data

Some Mercos resources carry personal data of your customers and contacts (such as email). Store and process it according to the LGPD and your own privacy policy.

Response format

{
  "data": [{ "...": "one object per row, with the columns listed on each endpoint" }],
  "meta": {
    "page": 1,
    "limit": 500,
    "hasNextPage": true,
    "hasPreviousPage": false
  }
}

Amounts and large counters (fields with format: decimal or format: int64 in each endpoint schema) come as strings, e.g. "125.50", so no precision is lost. Convert them to a decimal type on your side.

On this page