Skip to content
HALOWERK

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-doc

Inputs

Fields of the published input schema
FieldTypeRequiredDescription
content_base64stringNoThe XLSX file as base64 (a data: prefix and whitespace are tolerated); at most 10 MB decoded.
urlstringNoPublic 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."
    }
  }
}

Open original schema

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

All endpoints in this hub →