Eksportuoti lentelės eilutes

Eksportuoja atrinktas lentelės eilutes kaip atsisiunčiamo failo srautą (ndjson, json, csv arba parquet).

Query Parameters

format?string

Output file format: ndjson (default), json, csv, xlsx (Excel, capped at 1,000,000 rows) or parquet.

Request Body

application/json

TypeScript Definitions

Use the request body type in TypeScript.

Query definition sent as the JSON request body. All fields are optional; an empty body {} returns the first page of all columns.

limit?integer

Maximum number of rows to return (page size). Maps to SQL LIMIT.

offset?integer

Number of rows to skip before returning results. offset = (page − 1) × limit. Maps to SQL OFFSET.

filter?string

URL-style filter: column=value conditions joined with &, values bare. Dotted two-letter operators: ._gt ._ge ._lt ._le ._co ._sw ._ew. Combine with _and. / _or. Use ._ge not ._gte (three-letter forms are rejected).

sort?string

Comma-separated sort keys. Prefix - for descending, + or none for ascending.

select?string

Comma-separated list of column names to return. Omit for all columns.

exclude_nulls?array<string>

Column name(s) that must be non-null; rows with a null in any listed column are dropped. Repeat the parameter for several columns.

Response Body

curl -X POST "https://example.com/namespaces/string/tables/string/export?format=ndjson" \  -H "Content-Type: application/json" \  -d '{    "limit": 10,    "offset": 0,    "select": "lytis,mirties_metai,pavadinimas",    "filter": "lytis=Moteris",    "sort": "-mirties_metai",    "exclude_nulls": [      "m_konc"    ]  }'

Empty

{
  "error": "string",
  "error_code": "string"
}

{
  "message": "string",
  "error_code": "string"
}

{
  "detail": [
    {
      "loc": [
        null
      ],
      "msg": "string",
      "type": "string",
      "input": "string",
      "ctx": {
        "property1": null,
        "property2": null
      }
    }
  ]
}

{
  "error": "string",
  "error_code": "string"
}

{
  "error": "string",
  "error_code": "string"
}

Path Parameters

Query Parameters

Request Body

Response Body

Taip pat žiūrėkite

Eksportuoti lentelės eilutes

Path Parameters

Query Parameters

Request Body

Response Body

200

400text/csv

404text/csv

422text/csv

502text/csv

504text/csv

Taip pat žiūrėkite