{"service":"HALOWERK finopswerk","endpoint":"/v1/typed-logical-byte-projection","method":"POST","content_type":"application/json","inputSchema":{"type":"object","properties":{"fields":{"type":"array","items":{"type":"object","properties":{"name":{"type":"string","pattern":"^[a-z][a-z0-9_]{0,7}$","minLength":1,"maxLength":8},"kind":{"enum":["BOOL","INT64","STRING","BYTES","NUMERIC","BIGNUMERIC","STRUCT","ARRAY_INT64","ARRAY_STRING","ARRAY_STRUCT"]},"fields":{"type":"array","items":{"type":"object","properties":{"name":{"type":"string","pattern":"^[a-z][a-z0-9_]{0,7}$","minLength":1,"maxLength":8},"kind":{"enum":["BOOL","INT64","STRING","BYTES","NUMERIC","BIGNUMERIC"]}},"required":["name","kind"],"additionalProperties":false},"minItems":0,"maxItems":2}},"required":["name","kind","fields"],"additionalProperties":false},"minItems":1,"maxItems":2},"rows":{"type":"array","items":{"type":"object","maxProperties":2,"propertyNames":{"type":"string","pattern":"^[a-z][a-z0-9_]{0,7}$","minLength":1,"maxLength":8},"additionalProperties":{"anyOf":[{"anyOf":[{"type":"null"},{"type":"boolean"},{"type":"string","maxLength":40}]},{"type":"object","maxProperties":2,"propertyNames":{"type":"string","pattern":"^[a-z][a-z0-9_]{0,7}$","minLength":1,"maxLength":8},"additionalProperties":{"anyOf":[{"type":"null"},{"type":"boolean"},{"type":"string","maxLength":40}]}},{"type":"array","items":{"anyOf":[{"type":"boolean"},{"type":"string","maxLength":40},{"type":"object","maxProperties":2,"propertyNames":{"type":"string","pattern":"^[a-z][a-z0-9_]{0,7}$","minLength":1,"maxLength":8},"additionalProperties":{"anyOf":[{"type":"null"},{"type":"boolean"},{"type":"string","maxLength":40}]}}]},"minItems":0,"maxItems":3}]}},"minItems":1,"maxItems":3},"projection":{"type":"array","items":{"type":"string","pattern":"^[a-z][a-z0-9_]{0,7}(\\.[a-z][a-z0-9_]{0,7})?$","minLength":1,"maxLength":17},"minItems":1,"maxItems":4},"report":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","properties":{"logical_bytes":{"anyOf":[{"type":"integer","minimum":0,"maximum":3000},{"type":"null"}]},"selected_bytes":{"anyOf":[{"type":"integer","minimum":0,"maximum":3000},{"type":"null"}]}},"required":["logical_bytes","selected_bytes"],"additionalProperties":false},"minItems":1,"maxItems":3},"columns":{"type":"array","items":{"type":"object","properties":{"path":{"anyOf":[{"type":"string","pattern":"^[a-z][a-z0-9_]{0,7}(\\.[a-z][a-z0-9_]{0,7})?$","minLength":1,"maxLength":17},{"type":"null"}]},"logical_bytes":{"anyOf":[{"type":"integer","minimum":0,"maximum":3000},{"type":"null"}]}},"required":["path","logical_bytes"],"additionalProperties":false},"minItems":1,"maxItems":4},"selected_leaves":{"type":"array","items":{"anyOf":[{"type":"string","pattern":"^[a-z][a-z0-9_]{0,7}(\\.[a-z][a-z0-9_]{0,7})?$","minLength":1,"maxLength":17},{"type":"null"}]},"minItems":1,"maxItems":4},"table_bytes":{"anyOf":[{"type":"integer","minimum":0,"maximum":3000},{"type":"null"}]},"selected_bytes":{"anyOf":[{"type":"integer","minimum":0,"maximum":3000},{"type":"null"}]}},"required":["rows","columns","selected_leaves","table_bytes","selected_bytes"],"additionalProperties":false}},"required":["fields","rows","projection","report"],"additionalProperties":false},"requestExample":{"fields":[{"name":"meta","kind":"STRUCT","fields":[{"name":"ok","kind":"BOOL"},{"name":"name","kind":"STRING"}]},{"name":"items","kind":"ARRAY_STRUCT","fields":[{"name":"count","kind":"INT64"},{"name":"data","kind":"BYTES"}]}],"rows":[{"meta":{"ok":true,"name":"abc"},"items":[{"count":"42","data":"00ff"},{"count":"-1","data":""}]},{"meta":null,"items":[]}],"projection":["meta"],"report":{"rows":[{"logical_bytes":28,"selected_bytes":6},{"logical_bytes":0,"selected_bytes":0}],"columns":[{"path":"meta.ok","logical_bytes":1},{"path":"meta.name","logical_bytes":5},{"path":"items.count","logical_bytes":16},{"path":"items.data","logical_bytes":6}],"selected_leaves":["meta.ok","meta.name"],"table_bytes":28,"selected_bytes":6}},"operations":[{"method":"POST","inputSchema":{"type":"object","properties":{"fields":{"type":"array","items":{"type":"object","properties":{"name":{"type":"string","pattern":"^[a-z][a-z0-9_]{0,7}$","minLength":1,"maxLength":8},"kind":{"enum":["BOOL","INT64","STRING","BYTES","NUMERIC","BIGNUMERIC","STRUCT","ARRAY_INT64","ARRAY_STRING","ARRAY_STRUCT"]},"fields":{"type":"array","items":{"type":"object","properties":{"name":{"type":"string","pattern":"^[a-z][a-z0-9_]{0,7}$","minLength":1,"maxLength":8},"kind":{"enum":["BOOL","INT64","STRING","BYTES","NUMERIC","BIGNUMERIC"]}},"required":["name","kind"],"additionalProperties":false},"minItems":0,"maxItems":2}},"required":["name","kind","fields"],"additionalProperties":false},"minItems":1,"maxItems":2},"rows":{"type":"array","items":{"type":"object","maxProperties":2,"propertyNames":{"type":"string","pattern":"^[a-z][a-z0-9_]{0,7}$","minLength":1,"maxLength":8},"additionalProperties":{"anyOf":[{"anyOf":[{"type":"null"},{"type":"boolean"},{"type":"string","maxLength":40}]},{"type":"object","maxProperties":2,"propertyNames":{"type":"string","pattern":"^[a-z][a-z0-9_]{0,7}$","minLength":1,"maxLength":8},"additionalProperties":{"anyOf":[{"type":"null"},{"type":"boolean"},{"type":"string","maxLength":40}]}},{"type":"array","items":{"anyOf":[{"type":"boolean"},{"type":"string","maxLength":40},{"type":"object","maxProperties":2,"propertyNames":{"type":"string","pattern":"^[a-z][a-z0-9_]{0,7}$","minLength":1,"maxLength":8},"additionalProperties":{"anyOf":[{"type":"null"},{"type":"boolean"},{"type":"string","maxLength":40}]}}]},"minItems":0,"maxItems":3}]}},"minItems":1,"maxItems":3},"projection":{"type":"array","items":{"type":"string","pattern":"^[a-z][a-z0-9_]{0,7}(\\.[a-z][a-z0-9_]{0,7})?$","minLength":1,"maxLength":17},"minItems":1,"maxItems":4},"report":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","properties":{"logical_bytes":{"anyOf":[{"type":"integer","minimum":0,"maximum":3000},{"type":"null"}]},"selected_bytes":{"anyOf":[{"type":"integer","minimum":0,"maximum":3000},{"type":"null"}]}},"required":["logical_bytes","selected_bytes"],"additionalProperties":false},"minItems":1,"maxItems":3},"columns":{"type":"array","items":{"type":"object","properties":{"path":{"anyOf":[{"type":"string","pattern":"^[a-z][a-z0-9_]{0,7}(\\.[a-z][a-z0-9_]{0,7})?$","minLength":1,"maxLength":17},{"type":"null"}]},"logical_bytes":{"anyOf":[{"type":"integer","minimum":0,"maximum":3000},{"type":"null"}]}},"required":["path","logical_bytes"],"additionalProperties":false},"minItems":1,"maxItems":4},"selected_leaves":{"type":"array","items":{"anyOf":[{"type":"string","pattern":"^[a-z][a-z0-9_]{0,7}(\\.[a-z][a-z0-9_]{0,7})?$","minLength":1,"maxLength":17},{"type":"null"}]},"minItems":1,"maxItems":4},"table_bytes":{"anyOf":[{"type":"integer","minimum":0,"maximum":3000},{"type":"null"}]},"selected_bytes":{"anyOf":[{"type":"integer","minimum":0,"maximum":3000},{"type":"null"}]}},"required":["rows","columns","selected_leaves","table_bytes","selected_bytes"],"additionalProperties":false}},"required":["fields","rows","projection","report"],"additionalProperties":false},"requestExample":{"fields":[{"name":"meta","kind":"STRUCT","fields":[{"name":"ok","kind":"BOOL"},{"name":"name","kind":"STRING"}]},{"name":"items","kind":"ARRAY_STRUCT","fields":[{"name":"count","kind":"INT64"},{"name":"data","kind":"BYTES"}]}],"rows":[{"meta":{"ok":true,"name":"abc"},"items":[{"count":"42","data":"00ff"},{"count":"-1","data":""}]},{"meta":null,"items":[]}],"projection":["meta"],"report":{"rows":[{"logical_bytes":28,"selected_bytes":6},{"logical_bytes":0,"selected_bytes":0}],"columns":[{"path":"meta.ok","logical_bytes":1},{"path":"meta.name","logical_bytes":5},{"path":"items.count","logical_bytes":16},{"path":"items.data","logical_bytes":6}],"selected_leaves":["meta.ok","meta.name"],"table_bytes":28,"selected_bytes":6}}}]}