---
title: "Normalize mutual-fund RTA files"
method: POST
path: "/v1/rta-sync/normalize"
tags: ["RTA Sync"]
---

# Normalize mutual-fund RTA files

`POST /v1/rta-sync/normalize`

## Request

- Base URL: `https://api.casparser.in`
- URL: `https://api.casparser.in/v1/rta-sync/normalize`
- Auth: API key in header `x-api-key`

Upload one or more CAMS or KFintech reverse-feed files and receive typed
canonical data sets. The endpoint accepts CSV, XLS, XLSX, and DBF files,
detects the source report from the headers, applies provider-specific
cleanup rules, and returns normalized records with warnings and a batch
summary.

RTA Sync preserves reported holdings and brokerage payouts as source-backed
records. It does not calculate portfolio valuations or commissions.

## Headers

- `X-Request-ID` string

## Request body `multipart/form-data`

- object
  - `files` string[], required: One or more CAMS or KFintech RTA files in CSV, XLS, XLSX, or DBF format.
  - `reference` string, required: Opaque tenant, distributor, sub-distributor, or batch reference echoed in the response.
  - `report_code` string, nullable: Optional report identifier when all submitted files are the same report type.
  - `provider` 'auto' | 'cams' | 'kfintech': Optional provider hint. `auto` detects the provider schema from file headers.
  - `include_source` boolean: Include all original source fields in record provenance, including fields that were normalized.

## Response `200`

RTA file synced successfully

- RtaSyncResponse
  - `status` 'success', required
  - `data` RtaSyncData, required
    - `schema_version` string, required: Version of the canonical RTA Sync response contract.
    - `key_version` string, required: Version of the deterministic record-key algorithm.
    - `batch_key` string, required: Lowercase sha256 of UTF-8 bytes for schema_version + newline + key_version + newline + lexicographically sorted source_sha256:mapping_version pairs joined by newline. Duplicate pairs are preserved.
    - `reference` string, required: Opaque tenant, distributor, sub-distributor, or batch reference echoed from the request.
    - `files` RtaSyncFileResult[], required
      - `file_index` integer, required: Zero-based upload position. File results preserve request order.
      - `filename` string, required
      - `provider` 'cams' | 'kfintech', required
      - `report_code` string, nullable, required: Provider report identifier when detected or supplied.
      - `report_family` string, required: Normalized report family.
      - `detection_confidence` 'strong' | 'weak', required: Ambiguous detection fails the batch instead of returning a successful file result.
      - `source_sha256` string, required: SHA-256 hash of the source file bytes.
      - `mapping_version` string, required: Version of the RTA Sync mapping rules used for the file.
      - `source_schema` string, required: Detected provider schema; this is stable source metadata, not an internal class name.
      - `data_sets` RtaSyncDataSet[], required
        - union
          - RtaSyncInvestorDataSet
            - `object_type` 'investor', required
            - `record_count` integer, required: Number of records in this data set; equals records.length.
            - `warnings` RtaSyncWarning[], required
              - …
            - `records` RtaSyncInvestorRecord[], required
              - …
          - RtaSyncFolioDataSet
            - `object_type` 'folio', required
            - `record_count` integer, required: Number of records in this data set; equals records.length.
            - `warnings` RtaSyncWarning[], required
              - …
            - `records` RtaSyncFolioRecord[], required
              - …
          - RtaSyncSchemeDataSet
            - `object_type` 'scheme', required
            - `record_count` integer, required: Number of records in this data set; equals records.length.
            - `warnings` RtaSyncWarning[], required
              - …
            - `records` RtaSyncSchemeRecord[], required
              - …
          - RtaSyncTransactionDataSet
            - `object_type` 'transaction', required
            - `record_count` integer, required: Number of records in this data set; equals records.length.
            - `warnings` RtaSyncWarning[], required
              - …
            - `records` RtaSyncTransactionRecord[], required
              - …
          - RtaSyncPositionSnapshotDataSet
            - `object_type` 'position_snapshot', required
            - `record_count` integer, required: Number of records in this data set; equals records.length.
            - `warnings` RtaSyncWarning[], required
              - …
            - `records` RtaSyncPositionSnapshotRecord[], required
              - …
          - RtaSyncSystematicInstructionDataSet
            - `object_type` 'systematic_instruction', required
            - `record_count` integer, required: Number of records in this data set; equals records.length.
            - `warnings` RtaSyncWarning[], required
              - …
            - `records` RtaSyncSystematicInstructionRecord[], required
              - …
          - RtaSyncNavDataSet
            - `object_type` 'nav', required
            - `record_count` integer, required: Number of records in this data set; equals records.length.
            - `warnings` RtaSyncWarning[], required
              - …
            - `records` RtaSyncNavRecord[], required
              - …
          - RtaSyncCorporateActionDataSet
            - `object_type` 'corporate_action', required
            - `record_count` integer, required: Number of records in this data set; equals records.length.
            - `warnings` RtaSyncWarning[], required
              - …
            - `records` RtaSyncCorporateActionRecord[], required
              - …
          - RtaSyncExceptionDataSet
            - `object_type` 'exception', required
            - `record_count` integer, required: Number of records in this data set; equals records.length.
            - `warnings` RtaSyncWarning[], required
              - …
            - `records` RtaSyncExceptionRecord[], required
              - …
          - RtaSyncBrokeragePayoutDataSet
            - `object_type` 'brokerage_payout', required
            - `record_count` integer, required: Number of records in this data set; equals records.length.
            - `warnings` RtaSyncWarning[], required
              - …
            - `records` RtaSyncBrokeragePayoutRecord[], required
              - …
          - RtaSyncMandateDataSet
            - `object_type` 'mandate', required
            - `record_count` integer, required: Number of records in this data set; equals records.length.
            - `warnings` RtaSyncWarning[], required
              - …
            - `records` RtaSyncMandateRecord[], required
              - …
          - RtaSyncSettlementExceptionDataSet
            - `object_type` 'settlement_exception', required
            - `record_count` integer, required: Number of records in this data set; equals records.length.
            - `warnings` RtaSyncWarning[], required
              - …
            - `records` RtaSyncSettlementExceptionRecord[], required
              - …
          - RtaSyncAnalyticsReportDataSet
            - `object_type` 'analytics_report', required
            - `record_count` integer, required: Number of records in this data set; equals records.length.
            - `warnings` RtaSyncWarning[], required
              - …
            - `records` RtaSyncAnalyticsReportRecord[], required
              - …
      - `rejected_rows` RtaSyncRejectedRow[], required: Every rejected source row appears once at file level.
        - `source_row` RtaSyncSourceRowRef, required
          - `row_number` integer, required
          - `sheet` string, nullable: Worksheet or DBF table name when applicable.
          - `source_row_key` string, nullable: Stable provider row reference when available.
        - `source_fields` object: Original row fields when include_source is true.
        - `code` string, required
        - `message` string, required
        - `fields` string[]
      - `summary` RtaSyncFileSummary, required
        - `source_rows` integer, required
        - `output_records` integer, required
        - `rejected_rows` integer, required
        - `warning_count` integer, required
      - `warnings` RtaSyncWarning[], required
        - `row_number` integer, nullable
        - `code` string, required
        - `message` string, required
        - `fields` string[]
    - `summary` RtaSyncBatchSummary, required
      - `source_rows` integer, required
      - `output_records` integer, required
      - `rejected_rows` integer, required
      - `warning_count` integer, required
      - `input_files` integer, required
    - `warnings` RtaSyncWarning[], required
      - `row_number` integer, nullable
      - `code` string, required
      - `message` string, required
      - `fields` string[]

## Other responses

- `400`: Any file-level failure fails the entire batch
- `401`: Unauthorized. This can happen if the `x-api-key` header is missing.
- `403`: Forbidden. This can happen if the API key is invalid or the quota has been exceeded.
- `500`: Internal server error

## Changes

- **2026-10-18** `9d8f1445bad3`: 1 info
  - endpoint added
- **2026-09-13** `cf1b57c0f2f7`: 1 breaking
  - api path removed without deprecation
- **2026-09-12** `fba427a7d680`: 1 info
  - endpoint added

[Operation history](https://skmtc.dev/casparser/apis/cas-parser-track-portfolios-from-cdsl-nsdl-cams-kfintech-2/changes/v1/rta-sync/normalize/post.md)

---

[API](https://skmtc.dev/casparser/apis/cas-parser-track-portfolios-from-cdsl-nsdl-cams-kfintech-2.md) - [All operations](https://skmtc.dev/casparser/apis/cas-parser-track-portfolios-from-cdsl-nsdl-cams-kfintech-2/llms.txt) - [OpenAPI document](https://skmtc.dev/casparser/apis/cas-parser-track-portfolios-from-cdsl-nsdl-cams-kfintech-2/revisions/9d8f1445bad3?raw)
