mark05e

{
    "compilerOptions": {
        "target": "ES6"
    },
    "exclude": [
        "node_modules",
        "**/node_modules/*"
    ]
}

mark05e

// https://github.com/choraria/gas-url-shortener/blob/master/apps-script/Helper.gs
function removeEmptyColumns(sheetName) {
  var activeSheet = ss.getSheetByName(sheetName)
  var maxColumns = activeSheet.getMaxColumns(); 
  var lastColumn = activeSheet.getLastColumn();
  if (maxColumns-lastColumn != 0){
    activeSheet.deleteColumns(lastColumn+1, maxColumns-lastColumn);
  }
}

mark05e

Clasp Notes

.clasp.json

{
	"scriptId":"XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX",
	"rootDir":"src"
}

mark05e

Transcribe Audio Files Using Azure

Based on Transcribe large amounts of audio data with Batch Transcription - Learn | Microsoft Docs

by Mark05E

Requirements

1. Powershell
2. Azure CLI
3. Azure Subscription

mark05e

// postman-nice-codegen.js
// Mark05E

var log = false
var version = 0.6

var prefix = 'REQUEST'

var pm_request
var insidePostman = false

mark05e

Newsletters

• https://email.jointaro.com/
• https://www.techcareergrowth.co/
• https://www.lennysnewsletter.com/
• https://www.quastor.org/
• https://bigtechnology.substack.com/
• https://blog.bytebytego.com/
• https://newsletter.pragmaticengineer.com/
• https://www.newcomer.co/

mark05e

// check if we are inside GAS
// source - https://github.com/WildH0g/UnitTestingApp/blob/master/UnitTestingApp.js
function inGas() {
  return typeof ScriptApp !== 'undefined';
}

// get the sheet ID from a url
// source - https://stackoverflow.com/questions/16840038/easiest-way-to-get-file-id-from-url-on-google-apps-script
function getIdFromUrl(url) { 
    try {

mark05e

// from https://github.com/MicrosoftDocs/azure-docs/blob/main/articles/azure-app-configuration/rest-api-postman.md

// TODO: Replace the following placeholders with your access key
var credential = "<Credential>"; // Id
var secret = "<Secret>"; // Value

var isBodyEmpty = pm.request.body === null || pm.request.body === undefined || pm.request.body.isEmpty();

var headers = signRequest(
    pm.request.url.getHost(),

mark05e

$listenerPort = "8007"
$ServerThreadCode = {
  $listenerPort = $args[0]
  $listener = New-Object System.Net.HttpListener
  $listenerString = "http://+:$listenerPort/"
  $listener.Prefixes.Add($listenerString)
 
  $listener.Start()
 
  while ($listener.IsListening) {

mark05e

@ECHO OFF
REM https://stackoverflow.com/questions/56928545/how-to-make-a-batch-file-react-differently-based-on-the-success-percent-of-a-pin
REM Ben Personick

@(
  SetLocal EnableDelayedExpansion
  ECHO OFF
  SET "_PingAddress=www.aol.com"
  SET "_Count=0"
)