Methods
supabase(SUPABASE_URL, SUPABASE_KEY) → {Object|Object|Object|Object|Object}
- Source:
SupabaseをGASで操作するための関数
Examples
function getSupabaseData (){
const SUPABASE_URL = "{{URL}}";
const SUPABASE_KEY = "{{KEY}}";
const {readRecords} = gas_supabase_library.supabase(SUPABASE_URL,SUPABASE_KEY);
Logger.log(readRecords('/table_name?select=*',{
'Range': '0-9'
}))
}
function insertSupabase() {
const SUPABASE_URL = "{{URL}}";
const SUPABASE_KEY = "{{KEY}}";
const {insertRecords} = gas_supabase_library.supabase(SUPABASE_URL,SUPABASE_KEY);
Logger.log(insertRecords('/table_name',
{
'name':'test'
}))
}
function updateSupabase() {
const SUPABASE_URL = "{{URL}}";
const SUPABASE_KEY = "{{KEY}}";
const {updateRecords} = gas_supabase_library.supabase(SUPABASE_URL,SUPABASE_KEY);
Logger.log(updateRecords('/table_name?name=eq.test',
{
'desc':'ok'
}))
}
function deleteSupabase() {
const SUPABASE_URL = "{{URL}}";
const SUPABASE_KEY = "{{KEY}}";
const {deleteRecords} = gas_supabase_library.supabase(SUPABASE_URL,SUPABASE_KEY);
Logger.log(deleteRecords('/table_name?name=eq.test'))
}
Parameters:
Name | Type | Description |
---|---|---|
SUPABASE_URL |
string | Supabase API URL |
SUPABASE_KEY |
string | Supabase API Key |
Returns:
-
- 操作用関数
- Type
- Object
-
readRecords - レコード取得
- Type
- Object
-
insertRecords - レコード新規登録
- Type
- Object
-
updateRecords - レコード更新
- Type
- Object
-
deleteRecords - レコード削除
- Type
- Object