Data Mapping

Instantly map any dataset — no schema, no ETL

Connect and understand any dataset instantly.

Drop in CSV files, JSON records, or table names from multiple sources. Get back a unified schema with every field mapped, explained, and ready to run decisions on.

What it detects:

  • Matching fields across sources (revenue ↔ sales, qty ↔ quantity)
  • Value distributions (lognormal for prices, triangular for ranges)
  • Polarity (cost → negative, revenue → positive)
  • Join keys between tables (background if slow)
  • Derived formulas A×B≈C (background if slow)
  • Confidence and plain-English reasoning for every mapping

Two-speed pipeline: Phase 1 (schema + column matches) returns in <300ms. Phase 2 (join detection + relation detection) is embedded in the response if it finishes within 200ms, otherwise deep_analysis_pending: true is set and results can be retrieved via GET /v1/map/{map_id}.

The data funnel: Upload → Map → Query → Decide → Optimize

post/v1/map

Request

  • Base URL: https://api.algenta.ai
  • URL: https://api.algenta.ai/v1/map
  • Auth: one of:
    • HTTP bearer
    • API key in header X-API-Key

Request body

min_confidencenumber

Minimum confidence threshold for mappings (default: 0.5)

include_statisticsboolean

Include value distribution statistics in response

Response

Successful Response

map_idstring required
sources_analyzedinteger required
total_fieldsinteger required
join_keysobject[] required
derived_relationshipsobject[] required
simulation_readyboolean required
simulation_payloadobject nullable required
deep_analysis_pendingboolean
latency_msnumber required

Changes

No recorded changes to this operation across all 1 revision of this API.