> ## 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 TV Inspection details > Operation is used to retrieve full details of given TV Inspection Id, including nested SnTvObservation rows. ## OpenAPI ````json GET /tv-inspection/{id}/ { "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": { "/tv-inspection/{id}/": { "get": { "tags": [ "TV Inspection" ], "summary": "Get TV Inspection details", "description": "Operation is used to retrieve full details of given TV Inspection Id,\nincluding nested SnTvObservation rows.\n", "operationId": "getTvInspectionDetails", "parameters": [ { "name": "id", "in": "path", "description": "Id of TV Inspection", "required": true, "schema": { "type": "integer" } } ], "responses": { "200": { "description": "Retrieved TV Inspection (object)", "content": { "application/json": { "schema": { "$ref": "#/components/schemas/SnTvInspection" } } } }, "401": { "$ref": "#/components/responses/Http401" }, "404": { "$ref": "#/components/responses/Http404" } }, "security": [ { "Token": [] } ] } } }, "components": { "schemas": { "SnTvInspection": { "type": "object", "properties": { "added_date": { "type": "string", "description": "Date the report was created in DANDAS (DatoOprettet). Distinct from created, which is the import timestamp. The column is DATE (KP-5729).", "format": "date" }, "car_number": { "type": "string", "description": "Vehicle number (DANDAS Vognnummer)" }, "created": { "type": "string", "description": "When this record was imported. Shared by every record of one import run.", "format": "date-time", "readOnly": true }, "dk_case_name": { "type": "string", "description": "DCCTV - case name" }, "dk_cleaned": { "$ref": "#/components/schemas/TxtConstant" }, "dk_contractor": { "type": "string", "description": "DCCTV - contractor" }, "dk_customer_name": { "type": "string", "description": "DCCTV - customer name" }, "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_name": { "type": "string", "description": "DCCTV - document name" }, "dk_duct_number": { "type": "integer", "description": "DCCTV - duct number" }, "dk_end_point_type": { "$ref": "#/components/schemas/TxtConstant" }, "dk_end_point_type_sup": { "$ref": "#/components/schemas/TxtConstant" }, "dk_fi": { "type": "number", "description": "DCCTV - FI condition index", "format": "float" }, "dk_film_file": { "type": "string", "description": "DCCTV - film file" }, "dk_flow_with_stream": { "$ref": "#/components/schemas/TxtConstant" }, "dk_fra_knude_guid": { "type": "string", "description": "DCCTV - from-node GUID (store only)" }, "dk_fra_knudenavn": { "type": "string", "description": "DCCTV - from-node name (topological direction)" }, "dk_has_doc_file": { "type": "boolean", "description": "DCCTV - whether a document file exists" }, "dk_inspection_method": { "$ref": "#/components/schemas/TxtConstant" }, "dk_koordinatsys_kode": { "$ref": "#/components/schemas/TxtConstant" }, "dk_kotesys_kode": { "$ref": "#/components/schemas/TxtConstant" }, "dk_ledning_fra_knudenavn": { "type": "string", "description": "DCCTV - LedningReference from-node name (Phase 1, name-based lookup)" }, "dk_ledning_guid": { "type": "string", "description": "DCCTV - LedningReference GUID (store only)" }, "dk_ledning_mod_knudenavn": { "type": "string", "description": "DCCTV - LedningReference to-node name (Phase 1, name-based lookup)" }, "dk_ledning_objekt_items": { "type": "array", "items": { "type": "object" }, "description": "DCCTV - LedningObjektItems, stored as JSON" }, "dk_ledningsnummer": { "type": "string", "description": "DCCTV - duct reference number (Phase 2 reference)" }, "dk_lobenummer": { "type": "integer", "description": "DCCTV - running number (Phase 2 reference)" }, "dk_media_number": { "type": "string", "description": "DCCTV - media number" }, "dk_media_type": { "type": "string", "description": "DCCTV - media type" }, "dk_mod_knude_guid": { "type": "string", "description": "DCCTV - to-node GUID (store only)" }, "dk_mod_knudenavn": { "type": "string", "description": "DCCTV - to-node name (topological direction)" }, "dk_report_number": { "type": "string", "description": "DCCTV - report number" }, "dk_report_type": { "$ref": "#/components/schemas/TxtConstant" }, "dk_start_point_type": { "$ref": "#/components/schemas/TxtConstant" }, "dk_start_point_type_sup": { "$ref": "#/components/schemas/TxtConstant" }, "dk_start_station": { "type": "number", "description": "DCCTV - start station (Phase 2 reference)", "format": "float" }, "dk_system_code": { "$ref": "#/components/schemas/TxtConstant" }, "dk_text_file": { "type": "string", "description": "DCCTV - text file" }, "dk_usage_code": { "$ref": "#/components/schemas/TxtConstant" }, "dk_weather": { "$ref": "#/components/schemas/TxtConstant" }, "duct_id": { "type": "integer", "description": "Id of the linked sewer duct (snsewerduct)" }, "id": { "type": "integer", "description": "Primary key", "readOnly": true }, "inspection_cause": { "type": "string", "description": "Inspection cause (DANDAS Aarsag)" }, "inspection_date": { "type": "string", "description": "Date of report (DANDAS DatoRapport)", "format": "date" }, "inspector": { "type": "string", "description": "Inspector initials (DANDAS Initialer)" }, "mass_update_disabled": { "type": "boolean", "description": "Whether the inspection is left out when the CCTV Uploader mass updates the ducts of its file.", "default": false }, "observations": { "type": "array", "items": { "$ref": "#/components/schemas/SnTvObservation" }, "description": "Nested TV observations for this inspection. Read-only in this endpoint - use PATCH /tv-inspection/{id}/observation/{obs_id}/ to update one.", "readOnly": true }, "source_filename": { "type": "string", "description": "Name of the XML file this record was imported from", "readOnly": true }, "streetname": { "type": "string", "description": "Street name / locality (DANDAS Lokalitet)" } } }, "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)" } } }, "SnTvObservation": { "type": "object", "properties": { "code_id": { "$ref": "#/components/schemas/SnConstants" }, "comments": { "type": "string", "description": "Observation comment (DANDAS TVBemaerk, else Bemaerkning)", "readOnly": true }, "distance": { "type": "number", "description": "Distance in metres from the start of the inspection (DANDAS MaaltStationStart)", "format": "float", "readOnly": true }, "dk_clock_ref1": { "type": "integer", "description": "DCCTV - clock reference 1" }, "dk_clock_ref2": { "type": "integer", "description": "DCCTV - clock reference 2" }, "dk_continuous": { "type": "boolean", "description": "DCCTV - whether the observation is continuous" }, "dk_dim_determination": { "$ref": "#/components/schemas/TxtConstant" }, "dk_duct_dimension": { "type": "integer", "description": "DCCTV - duct dimension" }, "dk_duct_form": { "$ref": "#/components/schemas/TxtConstant" }, "dk_maal_determination": { "$ref": "#/components/schemas/TxtConstant" }, "dk_mat_determination": { "$ref": "#/components/schemas/TxtConstant" }, "dk_material": { "$ref": "#/components/schemas/TxtConstant" }, "dk_measurement": { "type": "number", "description": "DCCTV - measurement value", "format": "float" }, "dk_obs_code": { "type": "object", "properties": { "id": { "type": "integer" }, "logical_abbreviation": { "type": "string", "description": "The DANDAS code, e.g. RB" }, "logical_txt": { "type": "string" }, "txt": { "type": "string", "description": "Translated label" } }, "description": "DCCTV - DAS5 observation code (DANDAS TVObsKode, group DK_K_DAS5TVOBS)", "readOnly": true }, "dk_position": { "type": "string", "description": "DCCTV - position" }, "dk_station_end": { "type": "number", "description": "DCCTV - end station", "format": "float" }, "dk_text_angle": { "type": "number", "description": "DCCTV - text angle", "format": "float" }, "dk_type1": { "type": "string", "description": "DCCTV - observation type 1" }, "dk_type2": { "type": "string", "description": "DCCTV - observation type 2" }, "dk_x_end": { "type": "number", "description": "DCCTV - end X coordinate", "format": "float" }, "dk_y_end": { "type": "number", "description": "DCCTV - end Y coordinate", "format": "float" }, "id": { "type": "integer", "description": "Primary key", "readOnly": true }, "inspection_id": { "type": "integer", "description": "Id of the parent TV inspection", "readOnly": true }, "location": { "type": "string", "description": "Observation start point as EWKT (DANDAS MaaltXStart/MaaltYStart)", "readOnly": true }, "review_state": { "enum": [ "updated", "reviewed", "disabled_from_update" ], "type": "string", "description": "DCCTV - review state. Null if nobody has judged the observation.", "nullable": true, "readOnly": true }, "reviewed_by": { "type": "string", "description": "DCCTV - username of the user who judged the observation", "nullable": true, "readOnly": true }, "reviewed_ts": { "type": "string", "description": "DCCTV - when the observation was judged", "format": "date-time", "nullable": true, "readOnly": true }, "value": { "type": "integer", "description": "Observation class (DANDAS TVObsKlasse)", "readOnly": true } } }, "ErrorDetailsResponse": { "required": [ "details" ], "type": "object", "properties": { "details": { "type": "string", "description": "Detailed description of error" } }, "description": "Standard error response payload" }, "SnConstants": { "required": [ "groupname" ], "type": "object", "properties": { "groupname": { "type": "string", "description": "Group name of constant. Group name must contain only uppercase letters separated by underscores." }, "id": { "type": "integer", "description": "Primary key", "readOnly": true }, "num_value": { "type": "integer", "description": "Numerical value of the constant" }, "orderno": { "type": "integer", "description": "Order number" }, "txt": { "type": "string", "description": "Human readable textual representation" }, "txt_2": { "type": "string", "description": "Human readable textual representation" }, "value": { "type": "string", "description": "Logical textual value" } } } }, "responses": { "Http401": { "description": "Authentication credentials are missing or invalid", "content": { "application/json": { "schema": { "$ref": "#/components/schemas/ErrorDetailsResponse" }, "example": { "details": "Authentication credentials were not provided" } } } }, "Http404": { "description": "Object was not found", "content": { "application/json": { "schema": { "$ref": "#/components/schemas/ErrorDetailsResponse" }, "example": { "details": "Not found." } } } } }, "securitySchemes": { "Token": { "type": "apiKey", "description": "Token issued for API consumer.", "name": "Authorization", "in": "header" } } } } ````