Datensätze holen¶
Es wird eine Liste sämtlicher Datensätze mit allen Attributen zurückgegeben. Optional können alle Datensätze, für die ein spezieller User berechtigt ist, geholt werden.
URL : /backend/getdatasetsda[?dataset_id=:dataset_id]
URL Parameter (optional) : dataset_id=[Integer] wobei dataset_id die ID eines Datensatzes als Integer ist.
Methode : GET
Antwort bei Erfolg¶
Code : 200 OK
Beispiel für eine Rückgabe
[
{
"dataset_id": 50,
"shortname": "kurzname",
"db_connection_r_id": 1,
"db_connection_w_id": 2,
"desired_publication_date": null,
"dataset_datatype": "Beides",
"collection_datatype": {
"1234": "Vektor",
"5678": "Raster"
},
"etl_processes": [
{
"id": 1,
"type": "FME Workspace",
"name": "workspace.fmw",
"description": "Beschreibung",
"folder": "Repo",
"host": "FMWE Flow Host",
"interval_custom": null,
"last_run": null,
"dataset_id": 1143,
"mapped_collections": [
{
"id": 1,
"name": "collection"
}
],
"interval_number": null,
"interval_unit": "unregelmäßig",
"repo": null,
"service_definition": null,
"doclink": null,
"start_date": null,
"interval_cron_day": null,
"interval_cron_hour": null,
"interval_cron_weekday": null
}
],
"collections": [
{
"collection_id": 1,
"name": "collection",
"source_data_type": null,
"source_data_dbms": null,
"source_data_location": null,
"source_data_name": null,
"source_data_table": null,
"source_data_schema": null,
"source_data_query": null,
"source_db_connection_id": null,
"source_data_port": 11111,
"source_data_user": "user",
"source_data_db": "db",
"source_data_host": "host",
"source_data_pw": "pw",
"db_schema": "schema",
"db_table": "table",
"attribute_config": [
{
"attr_name_source": null,
"attr_name_db": "gid",
"attr_name_db_ignore": false,
"attr_name_service": "gid",
"attr_name_service_ignore": false,
"attr_name_masterportal_ignore": true,
"attr_name_masterportal": "Identifikator",
"attr_datatype": "number",
"description": null,
"pk": true,
"primary_geom": false,
"primary_date": false,
"unit": null,
"rule_mandatory": false,
"rule_filter_vis": null,
"rule_filter_data": null,
"rule_order": null,
"rule_date": null,
"rule_georef": null,
"rule_note": null
},
{
"attr_name_source": "TITEL",
"attr_name_db": "titel",
"attr_name_db_ignore": false,
"attr_name_service": "titel",
"attr_name_service_ignore": false,
"attr_name_masterportal_ignore": false,
"attr_name_masterportal": "Titel",
"attr_datatype": "text",
"description": "Titel",
"pk": false,
"primary_geom": false,
"primary_date": false,
"unit": null,
"rule_mandatory": false,
"rule_filter_vis": null,
"rule_filter_data": null,
"rule_order": null,
"rule_date": null,
"rule_georef": null,
"rule_note": null
},
{
"attr_name_source": null,
"attr_name_db": "geom",
"attr_name_db_ignore": false,
"attr_name_service": "geom",
"attr_name_service_ignore": false,
"attr_name_masterportal_ignore": true,
"attr_name_masterportal": "Geometrie",
"attr_datatype": "geometry [point]",
"description": null,
"pk": false,
"primary_geom": true,
"primary_date": false,
"unit": null,
"rule_mandatory": false,
"rule_filter_vis": null,
"rule_filter_data": null,
"rule_order": null,
"rule_date": null,
"rule_georef": null,
"rule_note": null
}
]
}
],
"db_connection_w": {
"id": 2,
"name": "name",
"host": "host.de",
"port": 5432,
"database": "fachdaten",
"user": "user",
"password": "hashed_pw",
"use_as_default_r": false,
"use_as_default_w": true
},
"db_connection_r": {
"id": 1,
"name": "name",
"host": "host.de",
"port": 5432,
"database": "fachdaten",
"user": "user",
"password": "hashed_pw",
"use_as_default_r": false,
"use_as_default_w": true
}
}
]