HALOWERKTechnische Prüfungen & Formate
F TD2000 DOCUMENTS 05 / xlsx linear xlookup exact nearest wildcard return projection
Reconstruct XLOOKUP first/last matches, numerical nearest alternatives and returned values.
POST https://detect.halowerk.com/v1/F-TD2000-DOCUMENTS-05/xlsx-linear-xlookup-exact-nearest-wildcard-return-projectionEingaben
| Feld | Typ | Pflicht | Beschreibung |
|---|---|---|---|
| artifact | object | Ja |
Vollständiges Eingabeschema anzeigen
{
"type": "object",
"additionalProperties": false,
"required": [
"artifact"
],
"properties": {
"artifact": {
"type": "object",
"additionalProperties": false,
"required": [
"spreadsheetLookup"
],
"properties": {
"spreadsheetLookup": {
"type": "object",
"additionalProperties": false,
"required": [
"data",
"claim"
],
"properties": {
"data": {
"type": "object",
"additionalProperties": false,
"required": [
"lookup",
"returns",
"value",
"match_mode",
"search_mode",
"if_not_found"
],
"properties": {
"lookup": {
"type": "array",
"items": {
"anyOf": [
{
"type": "number",
"minimum": -1000000,
"maximum": 1000000
},
{
"type": "string",
"maxLength": 256,
"minLength": 0
}
]
},
"maxItems": 256,
"minItems": 1
},
"returns": {
"type": "array",
"items": {
"anyOf": [
{
"type": "number",
"minimum": -1000000,
"maximum": 1000000
},
{
"type": "string",
"maxLength": 256,
"minLength": 0
},
{
"type": "null"
}
]
},
"maxItems": 256,
"minItems": 1
},
"value": {
"anyOf": [
{
"type": "number",
"minimum": -1000000,
"maximum": 1000000
},
{
"type": "string",
"maxLength": 256,
"minLength": 0
}
]
},
"match_mode": {
"enum": [
-1,
0,
1,
2
]
},
"search_mode": {
"enum": [
-1,
1
]
},
"if_not_found": {
"anyOf": [
{
"type": "number",
"minimum": -1000000,
"maximum": 1000000
},
{
"type": "string",
"maxLength": 256,
"minLength": 0
},
{
"type": "null"
}
]
}
}
},
"claim": {
"anyOf": [
{
"type": "null"
},
{
"type": "object",
"additionalProperties": false,
"required": [
"found",
"index",
"value"
],
"properties": {
"found": {
"type": "boolean"
},
"index": {
"anyOf": [
{
"type": "integer",
"minimum": 0,
"maximum": 1000000
},
{
"type": "null"
}
]
},
"value": {
"anyOf": [
{
"type": "number",
"minimum": -1000000000000,
"maximum": 1000000000000
},
{
"type": "string",
"maxLength": 20000
},
{
"type": "null"
}
]
}
}
}
]
}
}
}
}
}
}
}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.