> ## Documentation Index > Fetch the complete documentation index at: https://support.keypro.fi/llms.txt > Use this file to discover all available pages before exploring further. # Get list of Manhole Inspections > Operation is used to get a list of DCCTV Manhole Inspections. Results can be filtered by giving filtering parameters at HTTP querystring (see parameters), including `records` (Rapportnr) and `snsewernode` (linked sewer node id). ## OpenAPI ````json GET /manhole-inspection/ { "openapi": "3.0.4", "info": { "title": "Keyduct REST API", "termsOfService": "https://www.keypro.fi/en/terms-of-service", "contact": { "name": "Keypro Oy", "url": "https://keypro.fi/", "email": "keypro@keypro.fi" }, "license": { "name": "Copyright (C) Keypro Oy. All rights reserved.", "url": "https://www.keypro.fi/" }, "version": "2.0.0" }, "servers": [ { "url": "/api/v2" } ], "tags": [ { "name": "Task", "description": "Task related operations." }, { "name": "Subregion", "description": "Subregion related operations." }, { "name": "SAttribute", "description": "SAttribute related operations." }, { "name": "Fault", "description": "Fault related operations." }, { "name": "Maintenance history", "description": "Maintenance history related operations." }, { "name": "Deflection", "description": "Deflection related operations." }, { "name": "Fault Component", "description": "Fault Component related operations." }, { "name": "Task Comment", "description": "Task comment related operations." }, { "name": "FaultComponentFault", "description": "FaultComponentFault related operations." }, { "name": "Collections", "description": "Collection related operations." }, { "name": "Contact Person", "description": "ContactPerson related operations" }, { "name": "Contact Person Connection", "description": "ContactPersonConnection related operations" }, { "name": "Plan", "description": "Plan related operations." }, { "name": "FreeArea", "description": "FreeArea related operations." }, { "name": "Address", "description": "Building address related operations." }, { "name": "Apartment", "description": "Building apartments related operations." }, { "name": "Customer", "description": "Customer data related operations." }, { "name": "Customer Contract", "description": "Customer contract related operations." }, { "name": "Extra Attribute", "description": "Extra attributes related operations." }, { "name": "Extra Value", "description": "Extra attribute values related operations." }, { "name": "Consumer Point", "description": "Consumer point related operations." }, { "name": "Consumer Point Linked Address", "description": "Consumer point address link related operations." }, { "name": "Flow Meter", "description": "Flow Meter related operations." }, { "name": "Text Constant", "description": "Text Constant related operations." }, { "name": "Sn Constant", "description": "Sn Constant related operations." }, { "name": "Gas Meter", "description": "Gas Meter related operations." }, { "name": "Junction", "description": "Junction related operations." }, { "name": "Junction Connection", "description": "Junction Connection related operations." }, { "name": "External Document", "description": "External documents related operations." }, { "name": "Water Duct Renovation", "description": "Water duct renovation related operations." }, { "name": "Sewer Duct Renovation", "description": "Sewer duct renovation related operations." }, { "name": "Water Duct", "description": "Water duct related operations." }, { "name": "Water Other Node", "description": "Water other node related operations." }, { "name": "Water Hydrant", "description": "Water hydrant related operations." }, { "name": "Water Branch", "description": "Water branch related operations." }, { "name": "Water Measuring Point", "description": "Water measuring point related operations." }, { "name": "Fire Water Station", "description": "Fire water station related operations." }, { "name": "Water Fireplug", "description": "Water fireplug related operations." }, { "name": "Sewer Duct", "description": "Sewer duct related operations." }, { "name": "Flow Meter Reading", "description": "Flow Meter Reading related operations." }, { "name": "Gas Meter Reading", "description": "Gas meter reading related operations." }, { "name": "Gas Cable", "description": "Gas cable related operations." }, { "name": "Gas Other Node", "description": "Gas other node related operations." }, { "name": "Gas Valve", "description": "Gas valve related operations." }, { "name": "Water Node", "description": "Water node related operations." }, { "name": "Consumer Point Property", "description": "Consumer point property related operations." }, { "name": "Dh Manhole", "description": "Dh manhole related operations." }, { "name": "Dh Manhole Link Connection", "description": "Dh Manhole Link Connection related operations." }, { "name": "Dh Cable", "description": "Dh cable related operations." }, { "name": "Error Report", "description": "Error report related operations." }, { "name": "Failure Report", "description": "Failure report related operations." }, { "name": "DCCTV Comparison", "description": "DCCTV comparison (nearest object lookup + manual pick) related operations." }, { "name": "TV Inspection", "description": "CCTV TV inspection related operations." }, { "name": "Manhole Inspection", "description": "Manhole inspection related operations." }, { "name": "Dh Duct", "description": "Dh duct related operations." }, { "name": "Dh Conduit", "description": "Dh conduit related operations." }, { "name": "Dh Division", "description": "Dh division related operations." }, { "name": "Dh Valve", "description": "Dh valve related operations." }, { "name": "Consumer Point User", "description": "Consumer Point User related operations." }, { "name": "Consumer Point Real Estate", "description": "Consumer point real estate related operations." }, { "name": "Consumer Point User Email", "description": "Consumer point user email related operations." }, { "name": "Water Pumping Station", "description": "Water pumping station related operations." }, { "name": "Dh Meter Reading", "description": "Dh Meter Reading related operations." }, { "name": "Consumer Point Connection", "description": "Consumer point connection related operations." }, { "name": "Modeling Data", "description": "Modeling data related operations.\n\n*NOTE:* Contrary to what is described in chapter 1.5, the base path for all of these operations is `/keyaqua_modeling`\n" }, { "name": "Gas Manhole", "description": "Gas manhole related operations." }, { "name": "KeyDh Observation", "description": "KeyDh Observation related operations." }, { "name": "KeyDh Supply Interruption", "description": "KeyDh Supply Interruption related operations." }, { "name": "KeyDh Supply Interruption Connection", "description": "KeyDh Supply Interruption Connection related operations." }, { "name": "Keydh Node", "description": "Keydh Node related operations." }, { "name": "Keygas Duct", "description": "Keygas Duct related operations." }, { "name": "Real Estate", "description": "Real Estate related operations." }, { "name": "Keydh Connection", "description": "Keydh Connection related operations." }, { "name": "Water Tank", "description": "Water Tank related operations." }, { "name": "Water Valve", "description": "Water Valve related operations." }, { "name": "Point", "description": "Point related operations." }, { "name": "Sn Modeling", "description": "Sn Modeling related operations." }, { "name": "Sewer Manholes v2", "description": "Sewer Manholes v2 related operations." }, { "name": "Sewer Ducts", "description": "Sewer Ducts related operations." }, { "name": "Sewer Valves", "description": "Sewer Valves related operations." }, { "name": "Sewer Pumping Stations", "description": "Sewer Pumping Stations related operations." }, { "name": "Sewer Branches", "description": "Sewer Branches related operations." }, { "name": "Sewer Measuring Poins", "description": "Sewer Measuring Poins related operations." }, { "name": "Sewer Other Nodes", "description": "Sewer Other Nodes related operations." }, { "name": "Keydh Conduit Link", "description": "Keydh Conduit Link related operations." }, { "name": "Duct Condition Detail", "description": "Duct condition detail related operations." }, { "name": "KeyDh Conduit Error", "description": "KeyDh Conduit Error related operations." }, { "name": "AquaObjectType", "description": "AquaObjectType related operations." }, { "name": "AquaMeasuringPointTypes", "description": "AquaMeasuringPointTypes related operations." }, { "name": "AquaPumpType", "description": "AquaPumpType related operations." }, { "name": "AquaBranchType", "description": "AquaBranchType related operations." }, { "name": "AquaValveType", "description": "AquaValveType related operations." }, { "name": "AquaManholeType", "description": "AquaManholeType related operations." }, { "name": "AquaDuctType", "description": "AquaDuctType related operations." }, { "name": "SnDuctType", "description": "SnDuctType related operations." }, { "name": "SnManholeType", "description": "SnManholeType related operations." }, { "name": "SnLidType", "description": "SnLidType related operations." }, { "name": "Sewer Nodes", "description": "Sewer Node related operations." }, { "name": "Sn Control", "description": "Sn Control related operations." }, { "name": "KeyDh Shell Type", "description": "KeyDh Shell Type related operations." }, { "name": "Sewer Branch Type", "description": "Sewer Branch Type related operations." }, { "name": "Sewer Valve Type", "description": "Sewer Valve Type related operations." } ], "paths": { "/manhole-inspection/": { "get": { "tags": [ "Manhole Inspection" ], "summary": "Get list of Manhole Inspections", "description": "Operation is used to get a list of DCCTV Manhole Inspections.\n\nResults can be filtered by giving filtering parameters at HTTP querystring (see parameters),\nincluding `records` (Rapportnr) and `snsewernode` (linked sewer node id).\n", "operationId": "getManholeInspections", "parameters": [ { "$ref": "#/components/parameters/offsetParam" }, { "$ref": "#/components/parameters/limitParam" }, { "$ref": "#/components/parameters/filterParam" }, { "$ref": "#/components/parameters/orderParam" }, { "name": "records", "in": "query", "description": "Filter by report number (Rapportnr)", "schema": { "type": "string" } }, { "name": "snsewernode", "in": "query", "description": "Filter by the id of a linked sewer node", "schema": { "type": "integer" } } ], "responses": { "200": { "description": "A result response object", "content": { "application/json": { "schema": { "type": "object", "properties": { "Next": { "type": "string", "description": "Url to next page of the list if applicable. (Null if none)", "format": "url" }, "Previous": { "type": "string", "description": "Url to previous page of the list if applicable. (Null if none)", "format": "url" }, "Results": { "type": "array", "items": { "$ref": "#/components/schemas/ManholeInspection" }, "description": "List of fetched Manhole Inspections" }, "Total": { "type": "integer", "description": "Total number of Manhole Inspection objects in the list" } } } } } }, "401": { "$ref": "#/components/responses/Http401" } }, "security": [ { "Token": [] } ] } } }, "components": { "parameters": { "offsetParam": { "name": "offset", "in": "query", "description": "Offset to start returning results.", "schema": { "minimum": 0, "type": "integer" } }, "limitParam": { "name": "limit", "in": "query", "description": "Limit number of results returned. Set to -1 to use maximum limit set in the environment. Default limit will be used if parameter is not specified. Special value -1 is available from product version 3.2.18.", "schema": { "minimum": 1, "type": "integer" } }, "filterParam": { "name": "__any of the object fields__", "in": "query", "description": "Filters list by selected object field value.\nSupports structured queries via +++__+++ delimiter.\nSupports ending keywords via +++__+++ delimiter:\n- For string fields: istartswith, startswith, iendswith, endswith, contains, icontains, isnull\n- For numerics: gt, lt, gte, lte, isnull\n- For spatial fields: contains, isnull, within, intersects, disjoint, touches, overlaps, covers, coveredby\n**Examples:** `+++usage_state__txt__istartswith=in+++` ,\n`+++plan__state__txt__startswith=In+++` , `+++creation_date__gte=2019-01-02T15:32:01+++`,\n`+++location__within=POLYGON ((641503.89 6944059.81, 641406.52 6943933.87, 641369.48 6943772.48, 641474.25 6943704.74, 641873.78 6943735.96, 641848.38 6943975.15, 641607.08 6944167.76, 641653.11 6944102.15, 641503.89 6944059.81))+++`\nSupports exclusive queries by field value using a not-operator preceding the field lookup:\n**Examples:** `+++not__type__txt__istartswith=Tie+++` , `+++not__id=1390+++`\n", "schema": { "type": "string" } }, "orderParam": { "name": "orderby", "in": "query", "description": "Selects the object field to order the returned objects by.\nCan be used to sort in reverse order with '-' prefix.\nCan have several ordering rules separated by comma.\nCan be used only for object own fields and does not support structured queries.\n**Example:** `orderby=creator,-creation_date`\n", "schema": { "type": "string" } } }, "schemas": { "ManholeInspection": { "type": "object", "properties": { "Inspection_method": { "$ref": "#/components/schemas/TxtConstant" }, "Lid_material": { "$ref": "#/components/schemas/TxtConstant" }, "Lid_type": { "$ref": "#/components/schemas/TxtConstant" }, "Manhole_location_fk": { "$ref": "#/components/schemas/TxtConstant" }, "Manhole_material": { "$ref": "#/components/schemas/TxtConstant" }, "Manhole_shape": { "$ref": "#/components/schemas/TxtConstant" }, "Weather_condition": { "$ref": "#/components/schemas/TxtConstant" }, "br_vurdering": { "type": "array", "items": { "type": "object" }, "description": "DCCTV - BRVurderingItems, stored as JSON" }, "created": { "type": "string", "description": "When this record was imported. Shared by every record of one import run.", "format": "date-time", "readOnly": true }, "creation_date": { "type": "string", "description": "DCCTV - date the report was created (DatoOprettet) — see the note above; not writable on this endpoint.", "format": "date-time", "readOnly": true }, "dk_access_type": { "$ref": "#/components/schemas/TxtConstant" }, "dk_address_number": { "type": "integer", "description": "DCCTV - address number" }, "dk_case_name": { "type": "string", "description": "DCCTV - case name" }, "dk_contractor": { "type": "string", "description": "DCCTV - contractor" }, "dk_cover_level": { "type": "number", "description": "DCCTV - cover level", "format": "float" }, "dk_date_fault_identified": { "type": "string", "description": "DCCTV - date a fault was identified", "format": "date-time" }, "dk_date_performed": { "type": "string", "description": "DCCTV - date the inspection was performed", "format": "date-time" }, "dk_date_updated": { "type": "string", "description": "DCCTV - date the report was last updated", "format": "date-time" }, "dk_document_count": { "type": "integer", "description": "DCCTV - document count" }, "dk_document_name": { "type": "string", "description": "DCCTV - document name" }, "dk_documentation": { "type": "string", "description": "DCCTV - documentation" }, "dk_has_doc_file": { "type": "boolean", "description": "DCCTV - whether a document file exists" }, "dk_inspection_cause": { "type": "string", "description": "DCCTV - inspection cause" }, "dk_inspection_interrupted": { "$ref": "#/components/schemas/TxtConstant" }, "dk_inspection_method": { "$ref": "#/components/schemas/TxtConstant" }, "dk_invert_level": { "type": "number", "description": "DCCTV - invert level (Bundkote)", "format": "float" }, "dk_knude_guid": { "type": "string", "description": "DCCTV - node GUID (store only, not used for lookup)" }, "dk_koordinatsys_kode": { "$ref": "#/components/schemas/TxtConstant" }, "dk_kotesys_kode": { "$ref": "#/components/schemas/TxtConstant" }, "dk_lid_material": { "$ref": "#/components/schemas/TxtConstant" }, "dk_lid_type": { "$ref": "#/components/schemas/TxtConstant" }, "dk_linie_guid": { "type": "string", "description": "DCCTV - line GUID (store only, not used for lookup)" }, "dk_manhole_code": { "$ref": "#/components/schemas/TxtConstant" }, "dk_manhole_material": { "$ref": "#/components/schemas/TxtConstant" }, "dk_manhole_shape": { "$ref": "#/components/schemas/TxtConstant" }, "dk_media_number": { "type": "string", "description": "DCCTV - media number" }, "dk_project_engineer": { "type": "string", "description": "DCCTV - project engineer" }, "dk_report_comment": { "type": "string", "description": "DCCTV - report comment" }, "dk_report_guid": { "type": "string", "description": "DCCTV - unique report GUID from the source system", "readOnly": true }, "dk_report_type": { "$ref": "#/components/schemas/TxtConstant" }, "dk_system_medie": { "$ref": "#/components/schemas/TxtConstant" }, "dk_usage_code": { "$ref": "#/components/schemas/TxtConstant" }, "dk_vehicle_number": { "type": "string", "description": "DCCTV - vehicle number" }, "dk_weather": { "$ref": "#/components/schemas/TxtConstant" }, "dk_x_coordinate": { "type": "number", "description": "DCCTV - X coordinate", "format": "float" }, "dk_y_coordinate": { "type": "number", "description": "DCCTV - Y coordinate", "format": "float" }, "id": { "type": "integer", "description": "Primary key", "readOnly": true }, "inspection_date": { "type": "string", "description": "DCCTV - date of the report (DatoRapport) — see the note above; not writable on this endpoint.", "format": "date-time", "readOnly": true }, "inspector": { "type": "string", "description": "DCCTV - inspector initials (Initialer) — see the note above; not writable on this endpoint.", "readOnly": true }, "lid_size": { "type": "string", "description": "DCCTV - lid size (Daekseldim) — see the note above; not writable on this endpoint.", "readOnly": true }, "manhole_diameter": { "type": "string", "description": "DCCTV - manhole diameter (Broenddim) — see the note above; not writable on this endpoint.", "readOnly": true }, "manhole_place": { "type": "string", "description": "DCCTV - street name (Vejnavn) — see the note above; not writable on this endpoint.", "readOnly": true }, "mh_centrum": { "type": "string", "description": "DCCTV - the manhole's point in the map's coordinate system, from the X/Y coordinates; null when they are absent or their coordinate system is not recognised", "format": "ewkt", "readOnly": true }, "mh_position_identifier": { "type": "string", "description": "DCCTV - manhole number (Broendnr) — see the note above; not writable on this endpoint.", "readOnly": true }, "orderer": { "type": "string", "description": "DCCTV - customer name (Kundenavn) — see the note above; not writable on this endpoint.", "readOnly": true }, "records": { "type": "string", "description": "Report number (Rapportnr)" }, "source_filename": { "type": "string", "description": "Name of the XML file this record was imported from", "readOnly": true }, "tilslutning": { "type": "array", "items": { "$ref": "#/components/schemas/ManholeInspectionTilslutning" }, "description": "Nested BRTilslutning connections for this inspection. Read-only in this endpoint.", "readOnly": true } }, "description": "A DCCTV manhole inspection imported from a DANVA XML file.\n\nMost values are held in `dk_*` columns added for DCCTV. A number of DANVA\nvalues are instead written to columns the manhole inspection already had\nbefore DCCTV (`inspector`, `orderer`, `mh_position_identifier`,\n`manhole_place`, `manhole_diameter`, `lid_size`, `creation_date`,\n`inspection_date`, and the `Weather_condition`, `Inspection_method`,\n`Manhole_shape`, `Manhole_material`, `Lid_type`, `Lid_material` and\n`Manhole_location_fk` constants). Those are readable here but not writable:\nthey may hold data that predates the import, which this endpoint must not\noverwrite. Update them through the manhole inspection's own endpoints.\n" }, "TxtConstant": { "required": [ "id", "groupname", "logical_txt", "txt" ], "type": "object", "properties": { "groupname": { "type": "string", "description": "Group name of constant. Same as groupname parameter." }, "id": { "type": "integer", "description": "Unique id of constant" }, "logical_txt": { "type": "string", "description": "Logical textual value" }, "txt": { "type": "string", "description": "Human readable textual representation (translated)" } } }, "ManholeInspectionTilslutning": { "type": "object", "properties": { "andre_forhold": { "type": "string", "description": "Other conditions" }, "bemaerkning": { "type": "string", "description": "Remark" }, "dato_fejlkonstateret": { "type": "string", "description": "Date fault identified", "format": "date-time" }, "dato_opdateret": { "type": "string", "description": "Date updated", "format": "date-time" }, "dim": { "type": "integer", "description": "Dimension" }, "dim_bst": { "$ref": "#/components/schemas/TxtConstant" }, "guid": { "type": "string", "description": "Primary key, from source XML", "readOnly": true }, "initialer": { "type": "string", "description": "Inspector initials" }, "knude_haendelse_kode": { "type": "integer", "description": "Node event code" }, "kote": { "type": "number", "description": "Elevation", "format": "float" }, "materiale_bst": { "$ref": "#/components/schemas/TxtConstant" }, "materiale_kode": { "$ref": "#/components/schemas/TxtConstant" }, "nedstik": { "type": "number", "description": "Drop connection", "format": "float" }, "stik_nr": { "type": "integer", "description": "Connection number" }, "tilloebspunkt": { "type": "string", "description": "Inflow point" }, "tilslutning_kode": { "type": "integer", "description": "Connection type code" }, "tvaersnit": { "$ref": "#/components/schemas/TxtConstant" }, "ur_reference1": { "type": "integer", "description": "Clock reference" } } }, "ErrorDetailsResponse": { "required": [ "details" ], "type": "object", "properties": { "details": { "type": "string", "description": "Detailed description of error" } }, "description": "Standard error response payload" } }, "responses": { "Http401": { "description": "Authentication credentials are missing or invalid", "content": { "application/json": { "schema": { "$ref": "#/components/schemas/ErrorDetailsResponse" }, "example": { "details": "Authentication credentials were not provided" } } } } }, "securitySchemes": { "Token": { "type": "apiKey", "description": "Token issued for API consumer.", "name": "Authorization", "in": "header" } } } } ````