Formatwerk
xlsx pivot doc
Follows the relationships worksheet to pivotTable to pivotCacheDefinition and decodes the pivot table definition: location, pivot fields mapped to cache field names, row/column fields, page filters with the selected item, data fields with aggregation and show-data-as, calculated fields and items, grouping, grand totals and layout. The cache source is resolved and the refresh date converted from its serial. Basis: ECMA-376, 5th edition, §18.10.
POST https://format.halowerk.com/v1/xlsx-pivot-docInputs
| Field | Type | Required | Description |
|---|---|---|---|
| content_base64 | string | No | The XLSX file as base64 (a data: prefix and whitespace are tolerated); at most 10 MB decoded. |
| url | string | No | Public http(s) URL of the XLSX file (at most 10 MB). Private, local and reserved addresses are refused. |
Show full input schema
{
"type": "object",
"additionalProperties": false,
"properties": {
"content_base64": {
"type": "string",
"minLength": 8,
"maxLength": 13981016,
"description": "The XLSX file as base64 (a data: prefix and whitespace are tolerated); at most 10 MB decoded."
},
"url": {
"type": "string",
"format": "uri",
"maxLength": 2048,
"description": "Public http(s) URL of the XLSX file (at most 10 MB). Private, local and reserved addresses are refused."
}
}
}Published input example
{
"content_base64": "UEsDBBQAAAAIAAAAYl0cdPw42AAAAPYBAAATAAAAW0NvbnRlbnRfVHlwZXNdLnhtbK2RvU4DMQzHX+WUtWpcGDqgXhfKCgy8gJvz9aLLl2K3XN++uVAYUIGFyUr+Hz9L3rydE3EzeRe4VYNIegBgM5BH1jFRKEofs0cpz3yAhGbEA8H9arUGE4NQkKXMHWq72VGPRyfN01S+2cbQqkyOVfP4YZxZrcKUnDUoRYdT6L5RlleCLsnq4cEmXhSDgpuEWfkZcM29nChn21Hzilme0RcXTA7eYx73MY7695IbW8a+t4a6aI6+RDSnTNjxQCTe6Tq1RxsWf/OrmaGOu39e5Kv/cw+o595eAFBLAwQUAAAACAAAAGJd/luGcooAAADwAAAACwAAAF9yZWxzLy5yZWxzjc8xDsIwDAXQq1Q+QF0YGFDaiaUr4gImddqqTRw5QZTbk7EgBkbrf70vmyuvlGcJaZpjqja/htTClHM8IyY7sadUS+RQEifqKZdTR4xkFxoZj01zQt0b0Jm9WfVDC9oPB6hur8j/2OLcbPki9uE55B8TX40ik46cW9hWfIoud5GlLihgZ/Djwe4NUEsDBBQAAAAIAAAAYl22VKrPjgAAAPEAAAAaAAAAeGwvX3JlbHMvd29ya2Jvb2sueG1sLnJlbHONzz0OwjAMBeCrVDlA3TIwoCYTS1fEBaLUbaI2P7KNgNsTMaAiMTBZfpa+Jw8X3KyEnNiHws0jbom18iLlBMDOY7Tc5oKpXuZM0UpdaYFi3WoXhEPXHYH2hjLD3mzGSSsap14112fBf+w8z8HhObtbxCQ/KuCeaWWPKBW1tKBo9YkY3qNvq6rADPD1oXkBUEsDBBQAAAAIAAAAYl124Es9kgAAAOMAAAAPAAAAeGwvd29ya2Jvb2sueG1sjY8xDoMwDEWvEvkANXTogICpC3NPkAbTRJA4soPa4xdB2TvZ/3/5fbl9s8xP5tl84pK0A19KbhDVeYpWL5wpbcnEEm3ZpLxQs5Ad1ROVuOC1qm4YbUhwEBr5h8HTFBzd2a2RUjkgQostgZP6kBX6dm/Q3zTJRurgUdjNYHZrGDuowUgTtkWGsQbsWzyv8Hys/wJQSwMEFAAAAAgAAABiXdOY6AsKAQAAhQIAABgAAAB4bC93b3Jrc2hlZXRzL3NoZWV0MS54bWx1ksFugzAQRH8F+ZhDF3DVQ2QsEcihUg8tTT7AIqZYxTayt0n79wWKaEBw845n7DfSspt1n76WEoNv3RifkBqx3QP4spZa+AfbStPdVNZpgd3oPsC3TorLENINxGH4BFooQzi7KC2NV9YETlYJSaN9TglwNnhzgYIzZ2+BS0jUucv+kEYkwIQo0ygj39F1uvKcIX/OGSBn0E9Qju7DlvvtSxhU+LOSybYyZ6Pw1alSroTyrdDJomjmAeg6TcXiqVi88UJWpKfjWrc+euUxg+s9/aiGcznv5Yof4l3WBare8vhvmRHRiYhuEBXnl2OxRkSHv6MF0aguiegfEd1ldCSKlkRwtwgwbR7/BVBLAQIUAxQAAAAIAAAAYl0cdPw42AAAAPYBAAATAAAAAAAAAAAAAACAAQAAAABbQ29udGVudF9UeXBlc10ueG1sUEsBAhQDFAAAAAgAAABiXf5bhnKKAAAA8AAAAAsAAAAAAAAAAAAAAIABCQEAAF9yZWxzLy5yZWxzUEsBAhQDFAAAAAgAAABiXbZUqs+OAAAA8QAAABoAAAAAAAAAAAAAAIABvAEAAHhsL19yZWxzL3dvcmtib29rLnhtbC5yZWxzUEsBAhQDFAAAAAgAAABiXXbgSz2SAAAA4wAAAA8AAAAAAAAAAAAAAIABggIAAHhsL3dvcmtib29rLnhtbFBLAQIUAxQAAAAIAAAAYl3TmOgLCgEAAIUCAAAYAAAAAAAAAAAAAACAAUEDAAB4bC93b3Jrc2hlZXRzL3NoZWV0MS54bWxQSwUGAAAAAAUABQBFAQAAgQQAAAAA"
}Result & documentation
Machine-readable documentation of this hub
Source of this page: the published HALOWERK catalog. Updated: 2026-11-17 UTC.
More endpoints in this hub
- Formatwerk0.004 USDC
accounting csv unify
POSThttps://format.halowerk.com/v1/accounting-csv-unifyDATEV booking batch files (EXTF/DTVF, category 21) are read by their documented field positions: amount and S/H become a signed amount relative to the account, Belegdatum TTMM is resolved within the fiscal year from the header. Other export
- Formatwerk0.005 USDC
avv checklist
POSThttps://format.halowerk.com/v1/avv-checklistChecklist after Art. 28 GDPR (Regulation (EU) 2016/679 Art. 28 (GDPR), https://eur-lex.europa.eu/eli/reg/2016/679/oj, German and English text retrieved from the EU Publications Office 2026-11-01): Art. 28(3) sentence 1 (subject-matter, dura
- Formatwerk0.004 USDC
bagit package
POSThttps://format.halowerk.com/v1/bagit-packageCreate: files go to data/, manifest-<alg>.txt and tagmanifest-<alg>.txt are written for SHA-256 (default), SHA-512 or legacy SHA-1/MD5, bag-info.txt gets your metadata plus Bagging-Date, Bag-Size and Payload-Oxum; paths are checked (no abso