AndreasFurster

/** @CustomFunction */
function test(input: string): string {
  return `Test: ${input}`
}

AndreasFurster

name: helpers
description: ''
host: EXCEL
api_set: {}
script:
  content: |
    /** @CustomFunction */
    function getRegexCapture(input: string, regex: string): string {
      const r = new RegExp(regex);
      const match = r.exec(input);

AndreasFurster

let result = [];

var receiptsResp = await fetch("https://mijn.karwei.nl/api/receipts", {
  "headers": {
    "accept": "application/json",
    "accept-language": "en-US,en;q=0.9,nl;q=0.8",
    "cache-control": "no-cache",
    "content-type": "application/json",
    "pragma": "no-cache",
    "sec-fetch-dest": "empty",

AndreasFurster

[
   {
      "title":"The Shawshank Redemption",
      "link":"https://www.imdb.com/title/tt0111161/?ref_=ttls_li_tt",
      "image":"https://m.media-amazon.com/images/M/MV5BMDFkYTc0MGEtZmNhMC00ZDIzLWFmNTEtODM1ZmRlYWMwMWFmXkEyXkFqcGdeQXVyMTMxODk2OTU@._V1_UY209_CR0,0,140,209_AL_.jpg",
      "description":"Two imprisoned men bond over a number of years, finding solace and eventual redemption through acts of common decency."
   },
   {
      "title":"The Godfather",
      "link":"https://www.imdb.com/title/tt0068646/?ref_=ttls_li_tt",

AndreasFurster

$mypath = $ENV:PATH

$mypath -split ';'  | ForEach {
    $_
    

    if(![System.IO.File]::Exists($_))
    {
        $_ | Write-Host -ForegroundColor Red
    }

AndreasFurster

wget https://github.com/wkhtmltopdf/wkhtmltopdf/releases/download/0.12.4/wkhtmltox-0.12.4_linux-generic-amd64.tar.xz
unxz wkhtmltox-0.12.4_linux-generic-amd64.tar.xz
tar -xvf wkhtmltox-0.12.4_linux-generic-amd64.tar
mv wkhtmltox/bin/* /usr/local/bin/
rm -rf wkhtmltox
rm -f wkhtmltox-0.12.4_linux-generic-amd64.tar