1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
const user = "pomdtr";
const workspace = "scratch";
type Result = {
ok: true;
data: {
items: any[];
};
} | {
ok: false;
error: Error;
};
export async function pipes(sql: string): Promise<Result> {
const origin = "https://pipes.turbot.com";
const pathname = `/api/latest/user/${user}/workspace/${workspace}/query`;
const resp = await fetch(`${origin}${pathname}?sql=${encodeURIComponent(sql)}`, {
headers: {
Authorization: `Bearer ${Deno.env.get("PIPES_TOKEN")}`,
},
});
if (!resp.ok) {
return { ok: false, error: new Error(await resp.text()) };
}
return { ok: true, data: await resp.json() };
}
Val Town is a social website to write and deploy JavaScript.
Build APIs and schedule functions from your browser.
Comments
Nobody has commented on this val yet: be the first!
May 8, 2024