zurück zur Übersicht

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,
        "etl_processes": [
        {
            "id": 1,
            "type": "FME Workspace",
            "name": "workspace.fmw",
            "description": "Beschreibung",
            "folder": "Repo",
            "host": "FMWE Flow Host",
            "interval_custom": null,
            "start_date": 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
        }
    ],
    "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
    },
    "collections": [
        {
            "collection_id": 1,
            "name": "collection",
            "source_data_type": 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,
            "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
                }
            ]
        }
    ]
]