{"app":{"id":11,"summary":"Supabase Authentication Example - backend scripts version","versions":[30,32,34,35,41,42],"created_by":"adam186","created_at":"2023-03-17T10:52:20.905Z","votes":0,"approved":true,"apps":["supabase"],"app_type":"openapp","external_embed_url":null,"value":{"css":{"app":{"grid":{"class":"","style":""},"viewer":{"class":"","style":""},"component":{"class":"","style":""}},"mapcomponent":{"map":{"class":"","style":""}},"pdfcomponent":{"container":{"class":"","style":""}},"formcomponent":{"button":{"class":"","style":""},"container":{"class":"","style":""}},"htmlcomponent":{"container":{"class":"","style":""}},"iconcomponent":{"icon":{"class":"","style":""},"container":{"class":"","style":""}},"tabscomponent":{"tabRow":{"class":"","style":""},"allTabs":{"class":"","style":""},"container":{"class":"","style":""},"selectedTab":{"class":"","style":""}},"textcomponent":{"text":{"class":"","style":""}},"imagecomponent":{"image":{"class":"","style":""}},"rangecomponent":{"bar":{"style":""},"limits":{"class":"","style":""},"values":{"class":"","style":""},"handles":{"style":""}},"tablecomponent":{"container":{"class":"","style":""},"tableBody":{"class":"","style":""},"tableFooter":{"class":"","style":""},"tableHeader":{"class":"","style":""}},"aggridcomponent":{},"buttoncomponent":{"button":{"class":"","style":""}},"drawercomponent":{},"plotlycomponent":{},"selectcomponent":{"input":{"style":""}},"slidercomponent":{"bar":{"style":""},"value":{"class":"","style":""},"handle":{"style":""},"limits":{"class":"","style":""}},"displaycomponent":{"header":{"class":"","style":""},"container":{"class":"","style":""}},"barchartcomponent":{"container":{"class":"","style":""}},"checkboxcomponent":{"text":{"class":"","style":""}},"currencycomponent":{"input":{"class":"","style":""}},"piechartcomponent":{"container":{"class":"","style":""}},"vegalitecomponent":{},"containercomponent":{"container":{"class":"","style":""}},"dateinputcomponent":{"input":{"class":"","style":""}},"fileinputcomponent":{"container":{"class":"","style":""}},"textinputcomponent":{"input":{"class":"","style":""}},"emailinputcomponent":{"input":{"class":"","style":""}},"formbuttoncomponent":{"popup":{"class":"","style":""},"button":{"class":"","style":""}},"timeseriescomponent":{"container":{"class":"","style":""}},"multiselectcomponent":{"input":{"style":""}},"numberinputcomponent":{"input":{"class":"","style":""}},"scatterchartcomponent":{"container":{"class":"","style":""}},"passwordinputcomponent":{"input":{"class":"","style":""}},"resourceselectcomponent":{"input":{"style":""}},"verticaldividercomponent":{"divider":{"class":"","style":""},"container":{"class":"","style":""}},"horizontaldividercomponent":{"divider":{"class":"","style":""},"container":{"class":"","style":""}},"verticalsplitpanescomponent":{"container":{"class":"","style":""}},"horizontalsplitpanescomponent":{"container":{"class":"","style":""}}},"grid":[{"3":{"h":9,"w":3,"x":0,"y":0,"id":"a","max":{"h":100,"w":3},"min":{"h":1,"w":1},"fixed":false,"draggable":true,"resizable":true,"customDragger":false,"customResizer":false},"12":{"h":16,"w":12,"x":0,"y":0,"id":"a","max":{"h":100,"w":12},"min":{"h":1,"w":1},"fixed":false,"draggable":true,"resizable":true,"customDragger":false,"customResizer":false},"id":"a","data":{"id":"a","card":false,"tabs":["Login","Data"],"type":"tabscomponent","softWrap":true,"customCss":{"tabRow":{"class":"","style":""},"allTabs":{"class":"","style":""},"container":{"class":"","style":""},"selectedTab":{"class":"","style":""}},"configuration":{"tabsKind":{"type":"static","value":"invisibleOnView"},"noPadding":{"type":"static","value":false,"fieldType":"boolean","onlyStatic":true}},"numberOfSubgrids":2}}],"subgrids":{"a-0":[{"3":{"h":8,"w":2,"x":0,"y":9,"max":{"h":100,"w":3},"min":{"h":1,"w":1},"fixed":true,"draggable":true,"resizable":true,"customDragger":false,"customResizer":false},"12":{"h":14,"w":6,"x":3,"y":0,"id":"h","max":{"h":100,"w":12},"min":{"h":1,"w":1},"fixed":true,"draggable":true,"resizable":true,"customDragger":false,"customResizer":false},"id":"h","data":{"id":"h","type":"containercomponent","softWrap":true,"customCss":{"container":{"class":"","style":""}},"configuration":{},"numberOfSubgrids":1}}],"a-1":[{"3":{"h":10,"w":3,"x":0,"y":1,"max":{"h":100,"w":3},"min":{"h":1,"w":1},"fixed":false,"draggable":true,"resizable":true,"customDragger":false,"customResizer":false},"12":{"h":14,"w":12,"x":0,"y":0,"id":"d","max":{"h":100,"w":12},"min":{"h":1,"w":1},"fixed":false,"draggable":true,"resizable":true,"customDragger":false,"customResizer":false},"id":"d","data":{"id":"d","card":true,"type":"tablecomponent","customCss":{"container":{"class":"","style":""},"tableBody":{"class":"","style":""},"tableFooter":{"class":"","style":""},"tableHeader":{"class":"","style":""}},"actionButtons":[],"configuration":{"search":{"type":"static","value":"Disabled","fieldType":"select","onlyStatic":true,"optionValuesKey":"tableSearchOptions"},"pagination":{"selected":"","configuration":{"":{}}}},"componentInput":{"type":"connected","value":[{"id":1,"age":42,"name":"A cell with a long name"},{"id":2,"age":84,"name":"A briefer cell"}],"fields":{},"fieldType":"array","connection":{"path":"result","componentId":"bg_0"},"subFieldType":"object"}}}],"h-0":[{"3":{"h":1,"w":1,"x":1,"y":2,"max":{"h":100,"w":3},"min":{"h":1,"w":1},"fixed":false,"draggable":true,"resizable":true,"customDragger":false,"customResizer":false},"12":{"h":1,"w":12,"x":0,"y":0,"id":"l","max":{"h":100,"w":12},"min":{"h":1,"w":1},"fixed":false,"draggable":true,"resizable":true,"customDragger":false,"customResizer":false},"id":"l","data":{"id":"l","type":"textcomponent","softWrap":true,"customCss":{"text":{"class":"","style":""}},"configuration":{"style":{"type":"static","value":"Label","fieldType":"select","onlyStatic":true,"optionValuesKey":"textStyleOptions"},"tooltip":{"type":"static","value":"","tooltip":"Tooltip text if not empty","fieldType":"text","onlyStatic":true},"copyButton":{"type":"static","value":false,"fieldType":"boolean","onlyStatic":true}},"componentInput":{"eval":"Email","type":"template","value":"Hello ${ctx.username}","fieldType":"template"},"verticalAlignment":"bottom","horizontalAlignment":"left"}},{"3":{"h":1,"w":2,"x":0,"y":0,"max":{"h":100,"w":3},"min":{"h":1,"w":1},"fixed":false,"draggable":true,"resizable":true,"customDragger":false,"customResizer":false},"12":{"h":1,"w":12,"x":0,"y":1,"id":"i","max":{"h":100,"w":12},"min":{"h":1,"w":1},"fixed":false,"draggable":true,"resizable":true,"customDragger":false,"customResizer":false},"id":"i","data":{"id":"i","type":"emailinputcomponent","softWrap":true,"customCss":{"input":{"class":"","style":""}},"configuration":{"placeholder":{"type":"static","value":"Email","fieldType":"text","onlyStatic":true},"defaultValue":{"type":"static","fieldType":"text"}},"verticalAlignment":"center"}},{"3":{"h":1,"w":1,"x":0,"y":3,"max":{"h":100,"w":3},"min":{"h":1,"w":1},"fixed":false,"draggable":true,"resizable":true,"customDragger":false,"customResizer":false},"12":{"h":1,"w":12,"x":0,"y":2,"id":"m","max":{"h":100,"w":12},"min":{"h":1,"w":1},"fixed":false,"draggable":true,"resizable":true,"customDragger":false,"customResizer":false},"id":"m","data":{"id":"m","type":"textcomponent","softWrap":true,"customCss":{"text":{"class":"","style":""}},"configuration":{"style":{"type":"static","value":"Label","fieldType":"select","onlyStatic":true,"optionValuesKey":"textStyleOptions"},"tooltip":{"type":"static","value":"","tooltip":"Tooltip text if not empty","fieldType":"text","onlyStatic":true},"copyButton":{"type":"static","value":false,"fieldType":"boolean","onlyStatic":true}},"componentInput":{"eval":"Password","type":"template","value":"Hello ${ctx.username}","fieldType":"template"},"verticalAlignment":"bottom","horizontalAlignment":"left"}},{"3":{"h":1,"w":2,"x":0,"y":1,"max":{"h":100,"w":3},"min":{"h":1,"w":1},"fixed":false,"draggable":true,"resizable":true,"customDragger":false,"customResizer":false},"12":{"h":1,"w":12,"x":0,"y":3,"id":"j","max":{"h":100,"w":12},"min":{"h":1,"w":1},"fixed":false,"draggable":true,"resizable":true,"customDragger":false,"customResizer":false},"id":"j","data":{"id":"j","type":"passwordinputcomponent","softWrap":true,"customCss":{"input":{"class":"","style":""}},"configuration":{"placeholder":{"type":"static","value":"Password","fieldType":"text","onlyStatic":true}},"verticalAlignment":"center"}},{"3":{"h":1,"w":1,"x":0,"y":2,"max":{"h":100,"w":3},"min":{"h":1,"w":1},"fixed":false,"draggable":true,"resizable":true,"customDragger":false,"customResizer":false},"12":{"h":2,"w":12,"x":0,"y":4,"id":"k","max":{"h":100,"w":12},"min":{"h":1,"w":1},"fixed":false,"draggable":true,"resizable":true,"customDragger":false,"customResizer":false},"id":"k","data":{"id":"k","type":"buttoncomponent","softWrap":true,"customCss":{"button":{"class":"","style":""}},"recomputeIds":["bg_1","bg_2","bg_3","bg_0"],"configuration":{"goto":{"type":"static","value":"","tooltip":"Go to an url on success if not empty","fieldType":"text"},"size":{"type":"static","value":"sm","fieldType":"select","onlyStatic":true,"optionValuesKey":"buttonSizeOptions"},"color":{"type":"static","value":"dark","fieldType":"select","onlyStatic":true,"optionValuesKey":"buttonColorOptions"},"label":{"type":"static","value":"Login","fieldType":"text"},"disabled":{"expr":"false","type":"eval","fieldType":"boolean"},"afterIcon":{"type":"static","fieldType":"icon-select","onlyStatic":true},"onSuccess":{"type":"static","value":"","selected":"","configuration":{"":{}}},"beforeIcon":{"type":"static","fieldType":"icon-select","onlyStatic":true},"gotoNewTab":{"type":"static","value":true,"tooltip":"Go to an url on a new tab","fieldType":"boolean"},"fillContainer":{"type":"static","value":false,"fieldType":"boolean","onlyStatic":true},"triggerOnAppLoad":{"type":"static","value":false,"fieldType":"boolean","onlyStatic":true}},"componentInput":{"type":"runnable","fields":{"auth":{"type":"static","format":"resource-supabase","fieldType":"object"},"email":{"type":"connected","value":null,"fieldType":"string","connection":{"path":"result","componentId":"i"}},"password":{"type":"connected","value":null,"fieldType":"string","connection":{"path":"result","componentId":"j"}}},"runnable":{"path":"hub/741/supabase/authenticate_with_email_and_password","type":"runnableByPath","schema":{"type":"object","$schema":"https://json-schema.org/draft/2020-12/schema","required":["auth","email","password"],"properties":{"auth":{"type":"object","format":"resource-supabase","default":null,"description":""},"email":{"type":"string","default":null,"description":""},"password":{"type":"string","default":null,"description":""}}},"runType":"hubscript"},"fieldType":"any","recomputeOnInputChanged":true,"doNotRecomputeOnInputChanged":false},"verticalAlignment":"center","horizontalAlignment":"right"}},{"3":{"h":1,"w":1,"x":1,"y":3,"max":{"h":100,"w":3},"min":{"h":1,"w":1},"fixed":false,"draggable":true,"resizable":true,"customDragger":false,"customResizer":false},"12":{"h":7,"w":12,"x":0,"y":6,"id":"n","max":{"h":100,"w":12},"min":{"h":1,"w":1},"fixed":false,"draggable":true,"resizable":true,"customDragger":false,"customResizer":false},"id":"n","data":{"id":"n","type":"textcomponent","softWrap":true,"customCss":{"text":{"class":"text-red-500","style":""}},"configuration":{"style":{"type":"static","value":"Body","fieldType":"select","onlyStatic":true,"optionValuesKey":"textStyleOptions"},"tooltip":{"type":"static","value":"","tooltip":"Tooltip text if not empty","fieldType":"text","onlyStatic":true},"copyButton":{"type":"static","value":false,"fieldType":"boolean","onlyStatic":true}},"componentInput":{"eval":"${k?.result?.error ?? ' '}","type":"template","value":"Hello ${ctx.username}","fieldType":"template"},"verticalAlignment":"top","horizontalAlignment":"center"}}]},"fullscreen":false,"hiddenInlineScripts":[{"name":"Load data","fields":{"auth":{"type":"static","format":"resource-supabase","fieldType":"object"},"access_token":{"type":"connected","value":null,"fieldType":"string","connection":{"path":"result.access_token","componentId":"k"}}},"autoRefresh":false,"inlineScript":{"path":"/Load data","schema":{"type":"object","$schema":"https://json-schema.org/draft/2020-12/schema","required":["auth","access_token"],"properties":{"auth":{"type":"object","format":"resource-supabase","default":null},"access_token":{"type":"string","default":null}}},"content":"import { Resource } from \"https://deno.land/x/windmill@v1.76.0/mod.ts\";\nimport { createClient } from \"https://esm.sh/@supabase/supabase-js@2.10.0\";\n\nexport async function main(\n  auth: Resource<\"supabase\">,\n  access_token: string,\n) {\n  if(!access_token) {\n    return []\n  }\n  const client = createClient(auth.url, auth.key, {\n    global: { headers: { Authorization: `bearer ${access_token}` } },\n  });\n  const { data } = await client.from('my_table').select();\n  return data;\n}\n","language":"deno"},"recomputeOnInputChanged":false,"doNotRecomputeOnInputChanged":false},{"name":"Open Data tab","fields":{},"autoRefresh":false,"inlineScript":{"path":"/Open Data tab","content":"if(!k?.result?.error) {\n  setTab('a', 1)\n}","language":"frontend"},"recomputeOnInputChanged":true,"doNotRecomputeOnInputChanged":false}],"unusedInlineScripts":[]},"description":"Example app (with backend scripts) of how to use Supabase Authentication to query RLS enabled data.\n\nYou can read more about this example [**here**](https://docs.windmill.dev/blog/supabase-authentication-and-rls-protected-tables-on-windmill).\n\n**Usage:**\n\nCreate a `supabase` resource with your Supabase instance **URL** and **public anon API key** and pass it in the `Login` and `Load data` scripts.","vcreated_at":"2023-04-10T10:57:53.016Z","vcreated_by":"adam186","comments":[]}}