Automate TPT ⇄ FundsXML conversion

Monthly TPT deliveries for dozens of share classes are a job for a script, not for a browser. The converter exposes its conversion as one HTTP request: POST /api/convert with the file as multipart form data. The direction follows from the file — a TPT (XLSX/CSV) becomes FundsXML, a FundsXML document becomes TPT.

curl

API=https://www.fund-data-converter.eu/api/convert

# TPT → FundsXML: save the XML and print the X-Conversion-* headers
curl -sS --fail-with-body -F file=@fund.xlsx -F response=file -OJ -D - "$API"

# FundsXML → TPT V8 as CSV: file, report.json and issues.csv in one zip
curl -sS --fail-with-body -F file=@fundsxml.xml -F tpt_version=V8 \
  -F output_format=csv -F response=zip -OJ "$API"

Python

import base64, requests

with open("fund.xlsx", "rb") as f:
    r = requests.post("https://www.fund-data-converter.eu/api/convert", files={"file": f}, data={"preview": "false"}, timeout=120)
r.raise_for_status()
report = r.json()
with open(report["output"]["filename"], "wb") as out:
    out.write(base64.b64decode(report["output"]["base64"]))
print(report["validation"]["valid"], report["issueCounts"], report["dataLoss"])

What comes back

• response=json (default): the report with the converted file base64-encoded.
• response=file: the converted file; key figures in X-Conversion-* headers (portfolios, positions, valid, warnings, errors, data lost).
• response=zip: the file, report.json and issues.csv together.

The report holds the XSD validation result, issueCounts, every message (see conversion messages), dataLoss and meta with versions, SHA-256 of input and output and the duration.

Options

The API documentation has PowerShell examples and every field; the OpenAPI description is at /api/docs.

Read the API documentation