Data API

The DMS, data centre of the NXW apps

Every NXW app reads the DMS tables with one web address: the table, the fields, the conditions, the number of rows and the file format (XLSX, CSV, tab delimited, RDS, XML or JSON). Build the address below, copy it or send it.

Address builder

Build a data address

1 · Account

API key

One key per app. Generate makes a key (valid 1 hour by default) and puts it in the address and the examples (administrators: log in on the ADMIN side). Keys are also made and revoked in Administration > API.

2 · Table and fields

Table

Fields all · none

3 · Codes and conditions

Codes clear

Tick several codes: they make one condition CODE in (a|b|...). None ticked: every code.

START DATE

END

4 · Order, limit and format

Order by

Direction

Limit (rows)

Skip (rows)

Format

Return a file to save (download), not a page to read

5 · The address

Documentation

How the address works

Parameter	Value	Example
api	`data` for the data, `tables` for the list of tables and fields (JSON), `help` for this help as text	`api=data`
key	The API key of the app (or user with pass or sha)	`key=dms_8f3k...`
user, pass, sha	Email of an approved user or administrator, and the password in clear (pass) or its SHA-256 (sha)	`[email protected]&sha=5e88...`
table	One of the tables below	`table=prices`
fields	Fields separated by commas; all when left out	`fields=CODE,DATE,CLOSE`
where	Conditions separated by `;`, each `FIELD:OPERATOR:VALUE`	`where=CODE:in:STKBTHAAPL\|STKBTHMSFT;DATE:ge:2026-01-01`
order	A field; `-` in front for descending	`order=-DATE`
limit, offset	Rows returned (1000 by default, 100000 at most) and rows skipped first	`limit=500&offset=500`
format	`xlsx`, `csv`, `tsv` (tab delimited), `rds`, `xml` or `json` (default)	`format=csv`
download	`1` returns a file to save, `0` a page to read (XLSX and RDS are always files)	`download=1`

Operators

eq equal · ne not equal · gt ge greater (or equal) · lt le lower (or equal) · in one of the values, separated by | · like contains (any case) · starts starts with. Dates as YYYY-MM-DD; text compared in any case.

Answers

JSON: {table, total, offset, rows, fields, data: [...]}. The other formats hold the rows only; the headers X-DMS-Rows and X-DMS-Total give the counts. Errors come back as JSON with an HTTP status: 400 (request), 401 (account), 404 (table), 429 (more than 120 requests a minute).

From R

url <- "ADDRESS&format=csv"
x <- read.csv(url)
# or: x <- readRDS(url("ADDRESS&format=rds"))

From Python and Excel

import pandas as pd
x = pd.read_csv("ADDRESS&format=csv")
# Excel: Data > From Web > paste the address (format=csv)

Tables

Tables and fields served

The list of tables is read from the DMS app.