Global

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