dansayo

AD0 - Account expires

aws lambda invoke --function-name p21-28-prod-ad0 --log-type Tail --region=ap-southeast-1 --profile misprod response.json

After execution, inspect the response.json outfile for success or failure execution.

AD1 - OneCG fields

aws lambda invoke --function-name p21-28-prod-ad1 --log-type Tail --region=ap-southeast-1 --profile misprod response.json

Country holidays - GSheet

dansayo

A Simpler Way to setup the API key in Zappa

Steps

1. Prior to zappa deploy stage-name, specify these 2 attributes in the zappa_settings.json

    "api_key_required": true,
    "api_key": "some existing API KEY id to use",

dansayo

Use case on say 6 columns having email addresses, and you want to get only the unique values.
  
  Copy-paste the formulas in column pairs [iterate, scrubbedapp]

iterate2 column formula:
=SUBSTITUTE([iterate1]2, "#" + [ScrubbedApp1]2, "")

ScrubbedApp2 column formula:
=IF(NOT(ISBLANK([iterate2]1)), 
    MID([iterate2]1, 2, 

dansayo

Installing pyenv - on MX Linux 19

1. Basic installation

Note: update the bashrc not bash_profile

2. Other packages needed

sudo apt-get install -y make build-essential libssl-dev zlib1g-dev libbz2-dev \

dansayo

# python 3.7.4

import os
import json
import datetime  # for the expiration property: a date string to epoch millisec
import uuid  # for the id property

from apiclient import discovery
from google.oauth2 import service_account

dansayo

# python 3.7.4

import json
import datetime  # for the expiration property: a date string to epoch millisec
import uuid  # for the id property

from apiclient import discovery
from google.oauth2 import service_account

try:

dansayo

Update:

overriding pyenv python versions, if you want to use a python version located on a different folder, i.e. /usr/local/bin/python3

on a new project, then:

mkdir <new_project>
cd <new_project>
<on new_project> mkdir venv
<on new_project> /usr/local/bin/python3 -m venv venv

dansayo

// prints out a right triangle made out of hash tags
let output = "";
for (x = 1; x < 8; x = x + 1) {
    output += "#";
    console.log(output);
}

dansayo

import smartsheet
import os
import logging
import sys
import datetime

# Smartsheet API 2.0 reference (Python)
# https://smartsheet-platform.github.io/api-docs/index.html?python#api-reference

def get_cell_by_column_name(row, column_ame):