HALOWERKTechnische Prüfungen & Formate
F TD2000 DOCUMENTS 05 / xlsx multiple criteria wildcard conditional aggregate reconstruction
Reconstruct conditional matched rows, count, sum and average from a complete supplied spreadsheet criterion set.
POST https://detect.halowerk.com/v1/F-TD2000-DOCUMENTS-05/xlsx-multiple-criteria-wildcard-conditional-aggregate-reconstructionEingaben
| Feld | Typ | Pflicht | Beschreibung |
|---|---|---|---|
| artifact | object | Ja |
Vollständiges Eingabeschema anzeigen
{
"type": "object",
"additionalProperties": false,
"required": [
"artifact"
],
"properties": {
"artifact": {
"type": "object",
"additionalProperties": false,
"required": [
"spreadsheetCriteria"
],
"properties": {
"spreadsheetCriteria": {
"type": "object",
"additionalProperties": false,
"required": [
"data",
"claim"
],
"properties": {
"data": {
"type": "object",
"additionalProperties": false,
"required": [
"values",
"criteria"
],
"properties": {
"values": {
"type": "array",
"items": {
"type": "number",
"minimum": -1000000,
"maximum": 1000000
},
"maxItems": 256,
"minItems": 1
},
"criteria": {
"type": "array",
"items": {
"type": "object",
"additionalProperties": false,
"required": [
"range",
"criterion"
],
"properties": {
"range": {
"type": "array",
"items": {
"anyOf": [
{
"type": "number",
"minimum": -1000000,
"maximum": 1000000
},
{
"type": "string",
"maxLength": 256,
"minLength": 0
}
]
},
"maxItems": 256,
"minItems": 1
},
"criterion": {
"anyOf": [
{
"type": "number",
"minimum": -1000000,
"maximum": 1000000
},
{
"type": "string",
"maxLength": 256,
"minLength": 0
}
]
}
}
},
"maxItems": 16,
"minItems": 1
}
}
},
"claim": {
"anyOf": [
{
"type": "null"
},
{
"type": "object",
"additionalProperties": false,
"required": [
"average",
"count",
"matched_rows",
"sum"
],
"properties": {
"average": {
"anyOf": [
{
"type": "number",
"minimum": -1000000000000,
"maximum": 1000000000000
},
{
"type": "null"
}
]
},
"count": {
"type": "integer",
"minimum": 0,
"maximum": 1000000
},
"matched_rows": {
"type": "array",
"maxItems": 4096,
"items": {
"type": "integer",
"minimum": 0,
"maximum": 1000000
}
},
"sum": {
"type": "number",
"minimum": -1000000000000,
"maximum": 1000000000000
}
}
}
]
}
}
}
}
}
}
}Ergebnis & Dokumentation
Maschinenlesbare Dokumentation dieses Hubs
Quelle dieser Seite: der veröffentlichte HALOWERK-Katalog. Stand: 2026-11-01, 15:19 UTC.
Weitere Endpunkte dieses Hubs
- Technische Prüfungen & Formate0,003 USDC
aria concrete role property support closure
POSThttps://detect.halowerk.com/u/aria-concrete-role-property-support-closureA component API exporter needs properties that are unsupported or prohibited for its selected explicit ARIA role rather than losing them silently during conversion.
- Technische Prüfungen & Formate0,003 USDC
aria description author source precedence
POSThttps://detect.halowerk.com/u/aria-description-author-source-precedenceA description-metadata exporter needs which author ARIA source survives precedence and which competing source is overridden before transferring help text.
- Technische Prüfungen & Formate0,003 USDC
aria explicit concrete role token fallback
POSThttps://detect.halowerk.com/u/aria-explicit-concrete-role-token-fallbackBefore removing compatibility role tokens, a website migration agent needs which concrete source role survives the normative fallback order.