This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
#!/bin/bash | |
# This script resolves a DID, retrieves an API key, fetches a user's feed, | |
# and posts a "Hello, world" message to the user's feed. | |
# Resolve DID for handle | |
HANDLE='felicitas.pojtinger.com' | |
DID_URL="https://bsky.social/xrpc/com.atproto.identity.resolveHandle" | |
export DID=$(curl -G \ | |
--data-urlencode "handle=$HANDLE" \ |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
/** | |
* quickly test our function | |
*/ | |
function test(){ | |
var result = queryASpreadsheet('1sPevvtTMSd9LUptX8qdsw4VJf07nOal_1qn9JLwO4fQ', | |
'Example Data', | |
'A1:C', | |
'SELECT A,B,C WHERE B < 7'); | |
var rows = result.length;//7 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// #GoogleAppsScript #Gscript #GoogleSpreadsheet | |
function getPublicFiles(){ | |
var ss = SpreadsheetApp.getActiveSpreadsheet(); | |
var docs = DocsList.getFiles(); //Retrieve all the docs. | |
var listfile = ""; | |
var viewer = new Array; | |
var owner = ""; | |
var me = Session.getUser().getEmail(); //Get the email of the script owner. Need it to check if you are the owner of the file. | |
for(var i in docs){ |