BrowserAppCode.js

// Copyright © 2024 SVIETE Andrzej Raczkowski
// Description: Script to get report from AsReporter - you can run it on any app/webpage
let url = 'https://script.google.com/macros/s/AKfycbx_V5pYTR9iTjcWpi4u1R8u2K850i8FFx6JoGH_1FpBr36SVJVkN_TPlVTIvguMLaxN/exec';
let bodyData = {
    template:"Demo report template",
    data:{
        placeholders:{
            Name:"Celina ❤️",
            TemplatePlaceholder1:"This is imporant data from JSON",
            DYN_COL_2: "Column 2"
         },
         tables:{
            0: [
              ['r1c1', 'r1c2', 'r1c3', 'r1c4'],
              ['r2c1', 'r2c2', 'r2c3', 'r2c4']
            ],
            1: [['❤️', '☠️☠️'], ['👍👍👍', '👏👏👏👏']]
         }
    }
 }
let fileType = "application/pdf";
let fileName = "ImportantReportNo1.pdf";

fetch(url, { method: 'POST', redirect: 'follow', body: JSON.stringify(bodyData) })
    .then(response => response.text())
    .then((text) => {
        console.log(text.length);
        downloadTheRaportResult(text);
    })
    .catch(err => {
        console.log(err);
    }
    )

//
function downloadTheRaportResult(rawdata) {
    // decode base64 to bytes
    const base64ToDecode = atob(rawdata);
    const bytesArr = new Array(base64ToDecode.length);
    for (i = 0; i < base64ToDecode.length; i++) {
        bytesArr[i] = base64ToDecode.charCodeAt(i);
    }
    const bytes4Blob = new Uint8Array(bytesArr)
    const blob = new Blob([bytes4Blob], { "type": fileType });

    // create a link element, hide it, direct it towards the blob, and then 'click' it programatically
    const downloadLink = document.createElement("a");
    downloadLink.href = URL.createObjectURL(blob);
    downloadLink.download = fileName;
    downloadLink.click();
    downloadLink.remove();
}