Script 'Nextcloud Tables: List all tables' for nextcloud

Nextcloud Tables: List all tables

Verified

List all tables of the given user in the tables app

Created by marcel klehr12 179 days ago Viewed 355 times

Submitted by nextcloud Bun

Verified 9 days ago

All edits

Permalink

import * as wmill from "windmill-client";
import createClient, { type Middleware } from "openapi-fetch";

type Nextcloud = {
  baseUrl: string,
  password: string,
  username: string
};

export async function main(
  ncResource: Nextcloud,

  userId: string | null = null,

  useAppApiAuth: boolean = false,
) {

  const client = createClient<paths>({ baseUrl: ncResource.baseUrl });
  const authMiddleware: Middleware = {
    async onRequest({ request, options }) {
      // fetch token, if it doesn’t exist
      // add Authorization header to every request
      request.headers.set("Authorization", `Basic ${btoa((userId || ncResource.username) + ':' + ncResource.password)}`);
      if (useAppApiAuth) {
        request.headers.set("AA-VERSION", "2.3.0",);
        request.headers.set("EX-APP-ID", "flow",);
        request.headers.set("EX-APP-VERSION", "1.0.1",);
        request.headers.set("AUTHORIZATION-APP-API", btoa(
          `${userId || ncResource.username}:${ncResource.password}`,
        ));
      }
      return request;
    },
  };
  client.use(authMiddleware);

  try {

    const resp = await client.GET("/index.php/apps/tables/api/1/tables", {
      params: {
        header: {
          "OCS-APIRequest": true,
        },
        query: {
          format: "json",
        },

      },
    });

    console.debug('RESPONSE', resp.data)

    return resp.data

  } catch (e) {

    console.debug('error', e)

  }

  return {}

}

Other submissions

Submitted by marcel klehr12 Deno

Created 179 days ago

All edits

Permalink

import * as wmill from "npm:windmill-client@1";
import * as tb from "https://raw.githubusercontent.com/marcelklehr/nextcloud-client-deno/1629b11dc919b99d8dfadf2870a02128a24333fa/tables/index.ts";

// fill the type, or use the +Resource type to get a type-safe reference to a resource
// type Postgresql = object

export async function main(
  nextcloudResource: string,
  userId: string | null = null,
  useAppApiAuth: boolean = false,
) {
  const ncResource = await wmill.getResource(
    nextcloudResource,
  );
  const config = new tb.Configuration({
    username: userId || ncResource.username,
    password: ncResource.password,
    basePath: ncResource.baseUrl,
    middleware: [{
      async pre(context) {
        if (!context.url.includes("?")) {
          context.url += "?";
        } else {
          context.url += "&";
        }
        context.url += "format=json";
        return context;
      },
    }],
    ...(useAppApiAuth && ({
      headers: {
        "AA-VERSION": "2.3.0",
        "EX-APP-ID": "flow",
        "EX-APP-VERSION": "1.0.0",
        "AUTHORIZATION-APP-API": btoa(
          `${userId || ncResource.username}:${ncResource.password}`,
        ),
      },
    })),
  });
  const api = new tb.Api1Api(config);

  return await api.api1List();
}


`1`	`import * as wmill from "windmill-client";`
`2`	`import createClient, { type Middleware } from "openapi-fetch";`
`3`
`4`	`type Nextcloud = {`
`5`	`baseUrl: string,`
`6`	`password: string,`
`7`	`username: string`
`8`	`};`
`9`
`10`	`export async function main(`
`11`	`ncResource: Nextcloud,`
`12`
`13`	`userId: string \| null = null,`
`14`
`15`	`useAppApiAuth: boolean = false,`
`16`	`) {`
`17`
`18`	`const client = createClient<paths>({ baseUrl: ncResource.baseUrl });`
`19`	`const authMiddleware: Middleware = {`
`20`	`async onRequest({ request, options }) {`
`21`	`// fetch token, if it doesn’t exist`
`22`	`// add Authorization header to every request`
`23`	request.headers.set("Authorization", `Basic ${btoa((userId \|\| ncResource.username) + ':' + ncResource.password)}`);
`24`	`if (useAppApiAuth) {`
`25`	`request.headers.set("AA-VERSION", "2.3.0",);`
`26`	`request.headers.set("EX-APP-ID", "flow",);`
`27`	`request.headers.set("EX-APP-VERSION", "1.0.1",);`
`28`	`request.headers.set("AUTHORIZATION-APP-API", btoa(`
`29`	`${userId \|\| ncResource.username}:${ncResource.password}`,
`30`	`));`
`31`	`}`
`32`	`return request;`
`33`	`},`
`34`	`};`
`35`	`client.use(authMiddleware);`
`36`
`37`	`try {`
`38`
`39`	`const resp = await client.GET("/index.php/apps/tables/api/1/tables", {`
`40`	`params: {`
`41`	`header: {`
`42`	`"OCS-APIRequest": true,`
`43`	`},`
`44`	`query: {`
`45`	`format: "json",`
`46`	`},`
`47`
`48`	`},`
`49`	`});`
`50`
`51`	`console.debug('RESPONSE', resp.data)`
`52`
`53`	`return resp.data`
`54`
`55`	`} catch (e) {`
`56`
`57`	`console.debug('error', e)`
`58`
`59`	`}`
`60`
`61`	`return {}`
`62`
`63`	`}`

`1`	`import * as wmill from "npm:windmill-client@1";`
`2`	`import * as tb from "https://raw.githubusercontent.com/marcelklehr/nextcloud-client-deno/1629b11dc919b99d8dfadf2870a02128a24333fa/tables/index.ts";`
`3`
`4`	`// fill the type, or use the +Resource type to get a type-safe reference to a resource`
`5`	`// type Postgresql = object`
`6`
`7`	`export async function main(`
`8`	`nextcloudResource: string,`
`9`	`userId: string \| null = null,`
`10`	`useAppApiAuth: boolean = false,`
`11`	`) {`
`12`	`const ncResource = await wmill.getResource(`
`13`	`nextcloudResource,`
`14`	`);`
`15`	`const config = new tb.Configuration({`
`16`	`username: userId \|\| ncResource.username,`
`17`	`password: ncResource.password,`
`18`	`basePath: ncResource.baseUrl,`
`19`	`middleware: [{`
`20`	`async pre(context) {`
`21`	`if (!context.url.includes("?")) {`
`22`	`context.url += "?";`
`23`	`} else {`
`24`	`context.url += "&";`
`25`	`}`
`26`	`context.url += "format=json";`
`27`	`return context;`
`28`	`},`
`29`	`}],`
`30`	`...(useAppApiAuth && ({`
`31`	`headers: {`
`32`	`"AA-VERSION": "2.3.0",`
`33`	`"EX-APP-ID": "flow",`
`34`	`"EX-APP-VERSION": "1.0.0",`
`35`	`"AUTHORIZATION-APP-API": btoa(`
`36`	`${userId \|\| ncResource.username}:${ncResource.password}`,
`37`	`),`
`38`	`},`
`39`	`})),`
`40`	`});`
`41`	`const api = new tb.Api1Api(config);`
`42`
`43`	`return await api.api1List();`
`44`	`}`
`45`