--- title: "POST /api/rpc/queryInsuranceValues" method: POST path: "/api/rpc/queryInsuranceValues" tags: ["insurance"] --- # POST /api/rpc/queryInsuranceValues `POST /api/rpc/queryInsuranceValues` ## Request - Base URL: `https://21risk.com` - URL: `https://21risk.com/api/rpc/queryInsuranceValues` - Auth: OAuth 2 (client credentials, token URL `/api/v1/oauth/token`) Query insurance COPE values for a specific period, with optional filters and pagination ## Request body - object - `tenant` unknown, required - `query` string - `period` string, required - `name` string: Operands must be strings. Comma-separated values for OR, semicolon for AND. Use ! to exclude, ^ for exact match, * for any value, !* for empty. Use the facet query to discover valid values. - `valueStatus` string: Valid operands: -, in progress, completed. Comma-separated values for OR, semicolon for AND. Use ! to exclude, ^ for exact match, * for any value, !* for empty. - `copeStatus` string: Valid operands: -, in progress, completed. Comma-separated values for OR, semicolon for AND. Use ! to exclude, ^ for exact match, * for any value, !* for empty. - `biPeriod` string: Operands must represent integer IDs, such as "1,2" or "!3". Comma-separated values for OR, semicolon for AND. Use ! to exclude, ^ for exact match, * for any value, !* for empty. - `smokeVents` string: Operands must be true or false, such as "true" or "!false". Comma-separated values for OR, semicolon for AND. Use ! to exclude, ^ for exact match, * for any value, !* for empty. - `fireSections` string: Operands must be true or false, such as "true" or "!false". Comma-separated values for OR, semicolon for AND. Use ! to exclude, ^ for exact match, * for any value, !* for empty. - `closureMechanisms` string: Operands must be true or false, such as "true" or "!false". Comma-separated values for OR, semicolon for AND. Use ! to exclude, ^ for exact match, * for any value, !* for empty. - `cableAndPiping` string: Operands must be true or false, such as "true" or "!false". Comma-separated values for OR, semicolon for AND. Use ! to exclude, ^ for exact match, * for any value, !* for empty. - `highRackStorage` string: Operands must be true or false, such as "true" or "!false". Comma-separated values for OR, semicolon for AND. Use ! to exclude, ^ for exact match, * for any value, !* for empty. - `spillDropCol` string: Operands must be true or false, such as "true" or "!false". Comma-separated values for OR, semicolon for AND. Use ! to exclude, ^ for exact match, * for any value, !* for empty. - `electricalInstallation` string: Operands must be true or false, such as "true" or "!false". Comma-separated values for OR, semicolon for AND. Use ! to exclude, ^ for exact match, * for any value, !* for empty. - `lithiumBatteries` string: Operands must be true or false, such as "true" or "!false". Comma-separated values for OR, semicolon for AND. Use ! to exclude, ^ for exact match, * for any value, !* for empty. - `unmannedMachinery` string: Operands must be true or false, such as "true" or "!false". Comma-separated values for OR, semicolon for AND. Use ! to exclude, ^ for exact match, * for any value, !* for empty. - `seperateCharging` string: Operands must be true or false, such as "true" or "!false". Comma-separated values for OR, semicolon for AND. Use ! to exclude, ^ for exact match, * for any value, !* for empty. - `markedCharging` string: Operands must be true or false, such as "true" or "!false". Comma-separated values for OR, semicolon for AND. Use ! to exclude, ^ for exact match, * for any value, !* for empty. - `sharedOccupancy` string: Operands must be true or false, such as "true" or "!false". Comma-separated values for OR, semicolon for AND. Use ! to exclude, ^ for exact match, * for any value, !* for empty. - `electricalHeating` string: Operands must be true or false, such as "true" or "!false". Comma-separated values for OR, semicolon for AND. Use ! to exclude, ^ for exact match, * for any value, !* for empty. - `fireDetection` string: Operands must be true or false, such as "true" or "!false". Comma-separated values for OR, semicolon for AND. Use ! to exclude, ^ for exact match, * for any value, !* for empty. - `fireLogbook` string: Operands must be true or false, such as "true" or "!false". Comma-separated values for OR, semicolon for AND. Use ! to exclude, ^ for exact match, * for any value, !* for empty. - `fireAutSprinklers` string: Operands must be true or false, such as "true" or "!false". Comma-separated values for OR, semicolon for AND. Use ! to exclude, ^ for exact match, * for any value, !* for empty. - `fireExting` string: Operands must be true or false, such as "true" or "!false". Comma-separated values for OR, semicolon for AND. Use ! to exclude, ^ for exact match, * for any value, !* for empty. - `externalHydrants` string: Operands must be true or false, such as "true" or "!false". Comma-separated values for OR, semicolon for AND. Use ! to exclude, ^ for exact match, * for any value, !* for empty. - `extingService` string: Operands must be true or false, such as "true" or "!false". Comma-separated values for OR, semicolon for AND. Use ! to exclude, ^ for exact match, * for any value, !* for empty. - `thermographicSurvey` string: Operands must be true or false, such as "true" or "!false". Comma-separated values for OR, semicolon for AND. Use ! to exclude, ^ for exact match, * for any value, !* for empty. - `hotWorkPermit` string: Operands must be true or false, such as "true" or "!false". Comma-separated values for OR, semicolon for AND. Use ! to exclude, ^ for exact match, * for any value, !* for empty. - `inspectionRegularHousekeeping` string: Operands must be true or false, such as "true" or "!false". Comma-separated values for OR, semicolon for AND. Use ! to exclude, ^ for exact match, * for any value, !* for empty. - `inspectionSandwichPanels` string: Operands must be true or false, such as "true" or "!false". Comma-separated values for OR, semicolon for AND. Use ! to exclude, ^ for exact match, * for any value, !* for empty. - `inspectionFireDoors` string: Operands must be true or false, such as "true" or "!false". Comma-separated values for OR, semicolon for AND. Use ! to exclude, ^ for exact match, * for any value, !* for empty. - `smokePolicy` string: Operands must be true or false, such as "true" or "!false". Comma-separated values for OR, semicolon for AND. Use ! to exclude, ^ for exact match, * for any value, !* for empty. - `biPlan` string: Operands must be true or false, such as "true" or "!false". Comma-separated values for OR, semicolon for AND. Use ! to exclude, ^ for exact match, * for any value, !* for empty. - `solarInstallted` string: Operands must be true or false, such as "true" or "!false". Comma-separated values for OR, semicolon for AND. Use ! to exclude, ^ for exact match, * for any value, !* for empty. - `roof` string: Operands must be strings. Comma-separated values for OR, semicolon for AND. Use ! to exclude, ^ for exact match, * for any value, !* for empty. Use the facet query to discover valid values. - `internalWalls` string: Operands must be strings. Comma-separated values for OR, semicolon for AND. Use ! to exclude, ^ for exact match, * for any value, !* for empty. Use the facet query to discover valid values. - `externalWalls` string: Operands must be strings. Comma-separated values for OR, semicolon for AND. Use ! to exclude, ^ for exact match, * for any value, !* for empty. Use the facet query to discover valid values. - `occupancyType` string: Operands must be strings. Comma-separated values for OR, semicolon for AND. Use ! to exclude, ^ for exact match, * for any value, !* for empty. Use the facet query to discover valid values. - `storageTypes` string: Operands must be strings. Comma-separated values for OR, semicolon for AND. Use ! to exclude, ^ for exact match, * for any value, !* for empty. Use the facet query to discover valid values. - `waterPumps` string: Operands must be strings. Comma-separated values for OR, semicolon for AND. Use ! to exclude, ^ for exact match, * for any value, !* for empty. Use the facet query to discover valid values. - `waterSupply` string: Operands must be strings. Comma-separated values for OR, semicolon for AND. Use ! to exclude, ^ for exact match, * for any value, !* for empty. Use the facet query to discover valid values. - `country` string: Operands must be strings. Comma-separated values for OR, semicolon for AND. Use ! to exclude, ^ for exact match, * for any value, !* for empty. Use the facet query to discover valid values. - `city` string: Operands must be strings. Comma-separated values for OR, semicolon for AND. Use ! to exclude, ^ for exact match, * for any value, !* for empty. Use the facet query to discover valid values. - `region` string: Operands must be strings. Comma-separated values for OR, semicolon for AND. Use ! to exclude, ^ for exact match, * for any value, !* for empty. Use the facet query to discover valid values. - `district` string: Operands must be strings. Comma-separated values for OR, semicolon for AND. Use ! to exclude, ^ for exact match, * for any value, !* for empty. Use the facet query to discover valid values. - `postcode` string: Operands must be strings. Comma-separated values for OR, semicolon for AND. Use ! to exclude, ^ for exact match, * for any value, !* for empty. Use the facet query to discover valid values. - `locality` string: Operands must be strings. Comma-separated values for OR, semicolon for AND. Use ! to exclude, ^ for exact match, * for any value, !* for empty. Use the facet query to discover valid values. - `neighborhood` string: Operands must be strings. Comma-separated values for OR, semicolon for AND. Use ! to exclude, ^ for exact match, * for any value, !* for empty. Use the facet query to discover valid values. - `tags` string: Operands must be strings. Comma-separated values for OR, semicolon for AND. Use ! to exclude, ^ for exact match, * for any value, !* for empty. Use the facet query to discover valid values. - `createdDate` string: ISO dates (2024-01-15), periods (2024, 2024-01), comparisons (>=2024, <2024-06), ranges (2024-01-01..2024-12-31), or relative dates (@today, @today-7d). Units: d, w, m, y. Use * for any date, !* for empty. - `tiv` string: Exact match (=42), comparisons (>42, <=42), or ranges (10..20). Use * for any value, !* for empty. - `tivChange` string: Exact match (=42), comparisons (>42, <=42), or ranges (10..20). Use * for any value, !* for empty. - `totalPD` string: Exact match (=42), comparisons (>42, <=42), or ranges (10..20). Use * for any value, !* for empty. - `totalPDChange` string: Exact match (=42), comparisons (>42, <=42), or ranges (10..20). Use * for any value, !* for empty. - `totalBI` string: Exact match (=42), comparisons (>42, <=42), or ranges (10..20). Use * for any value, !* for empty. - `totalBIChange` string: Exact match (=42), comparisons (>42, <=42), or ranges (10..20). Use * for any value, !* for empty. - `tivIncludingOffSite` string: Exact match (=42), comparisons (>42, <=42), or ranges (10..20). Use * for any value, !* for empty. - `stockAndSuppliesIncludingOffSite` string: Exact match (=42), comparisons (>42, <=42), or ranges (10..20). Use * for any value, !* for empty. - `machineryAndEquipmentIncludingOffSite` string: Exact match (=42), comparisons (>42, <=42), or ranges (10..20). Use * for any value, !* for empty. - `area` string: Exact match (=42), comparisons (>42, <=42), or ranges (10..20). Use * for any value, !* for empty. - `buildings` string: Exact match (=42), comparisons (>42, <=42), or ranges (10..20). Use * for any value, !* for empty. - `machineryAndEquipment` string: Exact match (=42), comparisons (>42, <=42), or ranges (10..20). Use * for any value, !* for empty. - `leaseImprovements` string: Exact match (=42), comparisons (>42, <=42), or ranges (10..20). Use * for any value, !* for empty. - `furnitureAndFixtures` string: Exact match (=42), comparisons (>42, <=42), or ranges (10..20). Use * for any value, !* for empty. - `stockAndSupplies` string: Exact match (=42), comparisons (>42, <=42), or ranges (10..20). Use * for any value, !* for empty. - `businessInterruption` string: Exact match (=42), comparisons (>42, <=42), or ranges (10..20). Use * for any value, !* for empty. - `buildingsChange` string: Exact match (=42), comparisons (>42, <=42), or ranges (10..20). Use * for any value, !* for empty. - `machineryAndEquipmentChange` string: Exact match (=42), comparisons (>42, <=42), or ranges (10..20). Use * for any value, !* for empty. - `leaseImprovementsChange` string: Exact match (=42), comparisons (>42, <=42), or ranges (10..20). Use * for any value, !* for empty. - `furnitureAndFixturesChange` string: Exact match (=42), comparisons (>42, <=42), or ranges (10..20). Use * for any value, !* for empty. - `stockAndSuppliesChange` string: Exact match (=42), comparisons (>42, <=42), or ranges (10..20). Use * for any value, !* for empty. - `businessInterruptionChange` string: Exact match (=42), comparisons (>42, <=42), or ranges (10..20). Use * for any value, !* for empty. - `businessInterruptionScaled` string: Exact match (=42), comparisons (>42, <=42), or ranges (10..20). Use * for any value, !* for empty. - `businessInterruptionScaledChange` string: Exact match (=42), comparisons (>42, <=42), or ranges (10..20). Use * for any value, !* for empty. - `numberOfBuildings` string: Exact match (=42), comparisons (>42, <=42), or ranges (10..20). Use * for any value, !* for empty. - `stories` string: Exact match (=42), comparisons (>42, <=42), or ranges (10..20). Use * for any value, !* for empty. - `whiteCollarEmployees` string: Exact match (=42), comparisons (>42, <=42), or ranges (10..20). Use * for any value, !* for empty. - `blueCollarEmployees` string: Exact match (=42), comparisons (>42, <=42), or ranges (10..20). Use * for any value, !* for empty. - `normalOperatingDaysAWeek` string: Exact match (=42), comparisons (>42, <=42), or ranges (10..20). Use * for any value, !* for empty. - `buildingConstructionYear` string: Exact match (=42), comparisons (>42, <=42), or ranges (10..20). Use * for any value, !* for empty. - `fireBrigade` string: Exact match (=42), comparisons (>42, <=42), or ranges (10..20). Use * for any value, !* for empty. - `fireDetectionArea` string: Exact match (=42), comparisons (>42, <=42), or ranges (10..20). Use * for any value, !* for empty. - `sprinklerProtection` string: Exact match (=42), comparisons (>42, <=42), or ranges (10..20). Use * for any value, !* for empty. - `smokeVentsPerc` string: Exact match (=42), comparisons (>42, <=42), or ranges (10..20). Use * for any value, !* for empty. - `normalOperationShifts` string: Exact match (=42), comparisons (>42, <=42), or ranges (10..20). Use * for any value, !* for empty. - `includes` string[]: Only include records whose IDs are in this list. - `excludes` string[]: Exclude records whose IDs are in this list. - `after` string: Cursor-based pagination: return results after this cursor. Use pageInfo.endCursor from the previous page. - `before` string: Cursor-based pagination: return results before this cursor. Use pageInfo.startCursor from the current/previous page. - `first` union - integer - 'all' - `last` integer: Cursor-based pagination: number of results to return before the before cursor. Use for backward pagination. - `sort` 'name' | 'createdDate' | 'tiv' | 'tivChange' | 'totalPD' | 'totalPDChange' | 'totalBI' | 'totalBIChange' | 'tivIncludingOffSite' | 'stockAndSuppliesIncludingOffSite' | 'machineryAndEquipmentIncludingOffSite' | 'valueStatus' | 'copeStatus' | 'area' | 'buildings' | 'machineryAndEquipment' | 'leaseImprovements' | 'furnitureAndFixtures' | 'stockAndSupplies' | 'businessInterruption' | 'buildingsChange' | 'machineryAndEquipmentChange' | 'leaseImprovementsChange' | 'furnitureAndFixturesChange' | 'stockAndSuppliesChange' | 'businessInterruptionChange' | 'businessInterruptionScaled' | 'businessInterruptionScaledChange' | 'numberOfBuildings' | 'stories' | 'whiteCollarEmployees' | 'blueCollarEmployees' | 'normalOperatingDaysAWeek' | 'buildingConstructionYear' | 'fireBrigade' | 'fireDetectionArea' | 'sprinklerProtection' | 'smokeVentsPerc' | 'normalOperationShifts' | 'biPeriod' | 'smokeVents' | 'fireSections' | 'closureMechanisms' | 'cableAndPiping' | 'highRackStorage' | 'spillDropCol' | 'electricalInstallation' | 'lithiumBatteries' | 'unmannedMachinery' | 'seperateCharging' | 'markedCharging' | 'sharedOccupancy' | 'electricalHeating' | 'fireDetection' | 'fireLogbook' | 'fireAutSprinklers' | 'fireExting' | 'externalHydrants' | 'extingService' | 'thermographicSurvey' | 'hotWorkPermit' | 'inspectionRegularHousekeeping' | 'inspectionSandwichPanels' | 'inspectionFireDoors' | 'smokePolicy' | 'biPlan' | 'solarInstallted' | 'roof' | 'internalWalls' | 'externalWalls' | 'occupancyType' | 'storageTypes' | 'waterPumps' | 'waterSupply' | 'country' | 'address' | 'city' | 'region' | 'district' | 'postcode' | 'locality' | 'neighborhood' | 'street' | 'latitude' | 'longitude' - `direction` 'asc' | 'desc' ## Response `200` Successful response --- [API](https://skmtc.dev/21risk/apis/21risk-api.md) · [All operations](https://skmtc.dev/21risk/apis/21risk-api/llms.txt) · [OpenAPI document](https://skmtc.dev/21risk/apis/21risk-api/revisions/b8a9eff9eb27?raw)