27 <head>
28 <title>SQLite Explorer</title>
29 <link rel="preconnect" href="https://fonts.googleapis.com" />
30
31 <link rel="preconnect" href="https://fonts.gstatic.com" crossorigin />
32 <link
33 href="https://fonts.googleapis.com/css2?family=Fira+Code:wght@300..700&family=Source+Sans+3:ital,wght@0,200..900;1,200..900&display=swap"
34 rel="stylesheet"
35 />
1# Glide API 2.0: Bulk Import
2
3You can fork this Val to implement your own bulk import to Glide.
4
5Glide's high-performance bulk import API can load millions of rows
6into Big Tables. It's designed for importing your business data
7into Glide on a regular schedule (e.g. nightly).
8
9We designed this API for customers who regularly import tens of
10thousands of rows or more to Glide using tools like Make. Our goal
11was to make this process more efficient and less expensive.
12
13Note: This API is currently free to use. Future usage will cost
14approximately 1 update per 10k rows.
15
69
70 // Search for the track
71 const response = await fetch(`https://api.spotify.com/v1/search?q=${query}&type=track`, {
72 headers: {
73 "Authorization": `Bearer ${accessToken.access_token}`,
1# Tracks GraphQL API
2
3Query some Spotify tracks I probably listened to via GraphQL.
26
27
28Migrated from folder: GraphQL/tracksAPI
37
38## How it works
39The sketch function returns an http handler that sets up a basic page with p5.js added. It then imports your module from the browser and wires up all the exports so p5.js can see them. All the code in your val will run in the browser (except for the default `sketch` export) so you can't call any Deno functions, environment variables, or other server side apis.
40
41
1# Glide API 2.0
2
3`Effects` and utility functions for working with Glide API 2.0.
4
5## Authentication
121 const _0x4d306e = _0x249a7e.substr(0, _0x249a7e.indexOf("&"));
122
123 const api = "https://s3taku.com/encrypt-ajax.php?id="
124 + CryptoJS.AES.encrypt(_0x4d306e, CryptoJS.enc.Utf8.parse(key()), {
125 iv: CryptoJS.enc.Utf8.parse(iv()),
126 }).toString() + _0x249a7e.substr(_0x249a7e.indexOf("&")) + "&alias=" + _0x4d306e;
127
128 const apiResponse = await fetch(api, {
129 headers: {
130 "User-Agent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:128.0) Gecko/20100101 Firefox/128.0",
141 });
142
143 if (!apiResponse.ok) throw new Error(`Failed to fetch API: ${apiResponse.statusText}`);
144
145 const apiData = await apiResponse.json();
146 const _0x3b405f = JSON.parse(
147 CryptoJS.enc.Utf8.stringify(CryptoJS.AES.decrypt(apiData.data, CryptoJS.enc.Utf8.parse(key2()), {
148 iv: CryptoJS.enc.Utf8.parse(iv()),
149 })),
36
37Custom middleware can be added in an array as the third argument.
38Middleware can add data to the `req.data` object or return a response for things like API endpoints.
39
40```tsx
62```tsx
63// example middleware
64async function api (req: Request, res: Response, next): Promise<Response> {
65 if (req.pathname !== "/api") return next();
66 if (req.method === "POST") {
67 return Repsonse.json({ message: "Hello POST request" });
70}
71
72export default render(App, import.meta.url, [ api ]);
73```
74
1# getSpotifyTrackUrl
2
3Get a Spotify Track Url using the Spotify Web API given an artist and a song title.
4
5Track info is cached by the query and also the spotify track id, so your popular queries won't have to fetch from Spotify over and over.
28 <title>VALL-E-DRAW</title>
29 <meta name="viewport" content="width=device-width, initial-scale=1, viewport-fit=cover" />
30 <link rel="stylesheet" href="https://fonts.googleapis.com/css2?family=Inter:wght@500;700&display=swap"/>
31 <link rel="stylesheet" href="https://esm.sh/tldraw@2.3.0/tldraw.css"/>
32 <link href="https://unpkg.com/tailwindcss@^2/dist/tailwind.min.css" rel="stylesheet" />
