Script 'Nextcloud Tables: Create a row in a table' for nextcloud

Nextcloud Tables: Create a row in a table

Verified

Create a row in a table in Nextcloud Tables

Created by marcel klehr12 595 days ago Picked 16 times

Submitted by nextcloud Bun

Verified 21 days ago

All edits

Permalink

import createClient, { type Middleware } from "openapi-fetch";

interface Data {
  [p: number]: any
}

export async function main(
  nextcloud: RT.Nextcloud,
  tableId: number,
  data: Data,
) {

  const client = createClient<paths>({ baseUrl: nextcloud.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((nextcloud.userId) + ':' + nextcloud.password)}`);
      return request;
    },
  };
  client.use(authMiddleware);

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

    },
    body: {
      data: data
    },
  });

  return resp.data;

}

Other submissions

Submitted by marcel klehr12 Deno

Created 503 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

interface Data {
  [p: number]: any
}

export async function main(
  nextcloudResource: string,
  userId: string|null = null,
  tableId: number,
  data: Data,
  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.api1CreateRowInTable({
    tableId,
    data: JSON.stringify(data)
  });
}


`1`	`import createClient, { type Middleware } from "openapi-fetch";`
`2`
`3`	`interface Data {`
`4`	`[p: number]: any`
`5`	`}`
`6`
`7`	`export async function main(`
`8`	`nextcloud: RT.Nextcloud,`
`9`	`tableId: number,`
`10`	`data: Data,`
`11`	`) {`
`12`
`13`	`const client = createClient<paths>({ baseUrl: nextcloud.baseUrl });`
`14`	`const authMiddleware: Middleware = {`
`15`	`async onRequest({ request, options }) {`
`16`	`// fetch token, if it doesn’t exist`
`17`	`// add Authorization header to every request`
`18`	request.headers.set("Authorization", `Basic ${btoa((nextcloud.userId) + ':' + nextcloud.password)}`);
`19`	`return request;`
`20`	`},`
`21`	`};`
`22`	`client.use(authMiddleware);`
`23`
`24`	`const resp = await client.POST("/index.php/apps/tables/api/1/tables/{tableId}/rows", {`
`25`	`params: {`
`26`	`header: {`
`27`	`"OCS-APIRequest": true,`
`28`	`},`
`29`	`query: {`
`30`	`format: "json",`
`31`	`},`
`32`	`path: {`
`33`	`tableId: tableId,`
`34`	`},`
`35`
`36`	`},`
`37`	`body: {`
`38`	`data: data`
`39`	`},`
`40`	`});`
`41`
`42`	`return resp.data;`
`43`
`44`	`}`

`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`	`interface Data {`
`8`	`[p: number]: any`
`9`	`}`
`10`
`11`	`export async function main(`
`12`	`nextcloudResource: string,`
`13`	`userId: string\|null = null,`
`14`	`tableId: number,`
`15`	`data: Data,`
`16`	`useAppApiAuth: boolean = false`
`17`	`) {`
`18`	`const ncResource = await wmill.getResource(`
`19`	`nextcloudResource,`
`20`	`);`
`21`	`const config = new tb.Configuration({`
`22`	`username: userId \|\| ncResource.username,`
`23`	`password: ncResource.password,`
`24`	`basePath: ncResource.baseUrl,`
`25`	`middleware: [{`
`26`	`async pre(context) {`
`27`	`if (!context.url.includes("?")) {`
`28`	`context.url += "?";`
`29`	`} else {`
`30`	`context.url += "&";`
`31`	`}`
`32`	`context.url += "format=json";`
`33`	`return context;`
`34`	`},`
`35`	`}],`
`36`	`...(useAppApiAuth && ({`
`37`	`headers: {`
`38`	`"AA-VERSION": "2.3.0",`
`39`	`"EX-APP-ID": "flow",`
`40`	`"EX-APP-VERSION": "1.0.0",`
`41`	"AUTHORIZATION-APP-API": btoa(`${userId \|\| ncResource.username}:${ncResource.password}`),
`42`	`},`
`43`	`})),`
`44`	`});`
`45`	`const api = new tb.Api1Api(config);`
`46`
`47`	`return await api.api1CreateRowInTable({`
`48`	`tableId,`
`49`	`data: JSON.stringify(data)`
`50`	`});`
`51`	`}`
`52`