transaction_columns: openspending.nl Transaction Columns
read only REST
- Catalog:
OpenSpendingNl - Schema:
OpenSpendingNl - Primary Keys:
id - Label: Transaction Columns
Can only retrieve data.
API Source
- Endpoint:
/transactions/columns/?limit=1000
Table Columns
The columns of the table transaction_columns are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.
| Name | Data Type | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
created_ |
datetime |
itgen_osnl_created_at | filters on the platform, writable | ||
document_ |
varchar2 |
itgen_osnl_document_byline | filters on the platform, writable, document. |
||
document_ |
datetime |
itgen_osnl_document_created_at | filters on the platform, writable, document. |
||
document_ |
varchar2 |
itgen_osnl_document_doc_type | filters on the platform, writable, document. |
||
document_ |
varchar2 |
itgen_osnl_document_document | filters on the platform, writable, document. |
||
document_ |
varchar2 |
itgen_osnl_document_government_aggregation | filters on the platform, writable, document. |
||
document_ |
varchar2 |
itgen_osnl_document_government_code | filters on the platform, writable, document. |
||
document_ |
varchar2 |
itgen_osnl_document_government_country | filters on the platform, writable, document. |
||
document_ |
datetime |
itgen_osnl_document_government_created_at | filters on the platform, writable, document. |
||
document_ |
varchar2 |
itgen_osnl_document_government_display_kind | filters on the platform, writable, document. |
||
document_ |
int32 |
itgen_osnl_document_government_id | filters on the platform, writable, document. |
||
document_ |
varchar2 |
itgen_osnl_document_government_intro | filters on the platform, writable, document. |
||
document_ |
varchar2 |
itgen_osnl_document_government_kind | filters on the platform, writable, document. |
||
document_ |
double |
itgen_osnl_document_government_latitude | filters on the platform, writable, document. |
||
document_ |
varchar2 |
itgen_osnl_document_government_location | filters on the platform, writable, document. |
||
document_ |
double |
itgen_osnl_document_government_longitude | filters on the platform, writable, document. |
||
document_ |
varchar2 |
itgen_osnl_document_government_metrics | filters on the platform, writable, document. |
||
document_ |
varchar2 |
itgen_osnl_document_government_name | filters on the platform, writable, document. |
||
document_ |
varchar2 |
itgen_osnl_document_government_resource_uri | filters on the platform, writable, document. |
||
document_ |
varchar2 |
itgen_osnl_document_government_slug | filters on the platform, writable, document. |
||
document_ |
varchar2 |
itgen_osnl_document_government_state | filters on the platform, writable, document. |
||
document_ |
varchar2 |
itgen_osnl_document_government_updated_at | filters on the platform, writable, document. |
||
document_ |
varchar2 |
itgen_osnl_document_government_website | filters on the platform, writable, document. |
||
document_ |
int32 |
itgen_osnl_document_id | filters on the platform, writable, document. |
||
document_ |
varchar2 |
itgen_osnl_document_index_name | filters on the platform, writable, document. |
||
document_ |
varchar2 |
itgen_osnl_document_kind | filters on the platform, writable, document. |
||
document_ |
datetime |
itgen_osnl_document_parsed_at | filters on the platform, writable, document. |
||
document_ |
varchar2 |
itgen_osnl_document_resource_uri | filters on the platform, writable, document. |
||
document_ |
varchar2 |
itgen_osnl_document_title | filters on the platform, writable, document. |
||
document_ |
datetime |
itgen_osnl_document_updated_at | filters on the platform, writable, document. |
||
document_ |
varchar2 |
itgen_osnl_document_year | filters on the platform, writable, document. |
||
id |
int32 |
itgen_osnl_id | filters on the platform, writable | ||
key |
varchar2 |
itgen_osnl_key | filters on the platform, writable | ||
label |
varchar2 |
itgen_osnl_label | filters on the platform, writable | ||
resource_ |
varchar2 |
itgen_osnl_resource_uri | filters on the platform, writable | ||
updated_ |
datetime |
itgen_osnl_updated_at | filters on the platform, writable |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: