Script 'Get a form submission from Nextcloud Forms' for nextcloud

Get a form submission from Nextcloud Forms

Verified

Created by marcel klehr12 486 days ago Picked 11 times

Submitted by nextcloud Bun

Verified 352 days ago

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,
  formId: string,
  submissionId: number,
  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("/ocs/v2.php/apps/forms/api/v3/forms/{formId}/submissions", {
      params: {
        header: {
          "OCS-APIRequest": true,
        },
        query: {
          format: "json",
        },
        path: {
          formId: formId,
        },

      },
    });

    const submission = resp.data.ocs.data.submissions.find(s => s.id === submissionId)
    //console.debug('SUBMISSION', submission)
    return {
      submission,
    }
  } catch(e) {
    console.debug('error', e)
  }

}

Other submissions

Submitted by marcel klehr12 Deno

Created 435 days ago

All edits

Permalink

import * as wmill from "npm:windmill-client@1"
import axios from "npm:axios"

export async function main(
  nextcloudResource: string,
  userId: string|null = null,
  formHash: string, 
  submissionId: number,
  useAppApiAuth: boolean = false,
) {
  const ncResource = await wmill.getResource(
    nextcloudResource,
  );

  const url = ncResource.baseUrl + '/ocs/v2.php/apps/forms/api/v2/submissions/' + formHash
  console.debug('url', url)
  const config = {
    ...(!useAppApiAuth && ({
      auth: {
        username: ncResource.username,
        password: ncResource.password,
      },
    })),
    headers: {
      //'authorization' : 'basic ' + btoa(ncResource.username + ':' + ncResource.password),
      'content-type': 'application/json',
      'ocs-apirequest': true,
      ...(useAppApiAuth && ({
        "AA-VERSION": "2.3.0",
        "EX-APP-ID": "flow",
        "EX-APP-VERSION": "1.0.0",
        "AUTHORIZATION-APP-API": btoa(
          `${userId || ncResource.username}:${ncResource.password}`,
        ),
      })),
    },
  }
  console.debug('config', config)
  try {
    const resp = await axios.get(url, config)
    console.debug('RESPONSE', resp.data)
    const submission = resp.data.ocs.data.submissions.find(s => s.id === submissionId)
    //console.debug('SUBMISSION', submission)
    return {
      submission,
    }
  } catch(e) {
    console.debug('error', e)
  }
}

Submitted by nextcloud Bun

Created 342 days ago

This script is a newer edit of the script that had been approved, but it needs to be re-approved

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,
  formId: string,
  submissionId: number,
  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((ncResource.username) + ':' + ncResource.password)}`);
      if (useAppApiAuth) {
        request.headers.set("AA-VERSION", ncResource.aa_version,);
        request.headers.set("EX-APP-ID", ncResource.app_id,);
        request.headers.set("EX-APP-VERSION", ncResource.app_version,);
        request.headers.set("AUTHORIZATION-APP-API", btoa(
          `${userId || ncResource.username}:${ncResource.password}`,
        ));
      }
      return request;
    },
  };
  client.use(authMiddleware);

  try {
    const resp = await client.GET("/ocs/v2.php/apps/forms/api/v3/forms/{formId}/submissions", {
      params: {
        header: {
          "OCS-APIRequest": true,
        },
        query: {
          format: "json",
        },
        path: {
          formId: formId,
        },

      },
    });
    
    const submission = resp.data.ocs.data.submissions.find(s => s.id === submissionId)
    
    return {
      submission,
    }
  } catch(e) {
    console.debug('error', e)
  }

}

`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`	`userId: string \| null = null,`
`13`	`formId: string,`
`14`	`submissionId: number,`
`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`	`const resp = await client.GET("/ocs/v2.php/apps/forms/api/v3/forms/{formId}/submissions", {`
`39`	`params: {`
`40`	`header: {`
`41`	`"OCS-APIRequest": true,`
`42`	`},`
`43`	`query: {`
`44`	`format: "json",`
`45`	`},`
`46`	`path: {`
`47`	`formId: formId,`
`48`	`},`
`49`
`50`	`},`
`51`	`});`
`52`
`53`	`const submission = resp.data.ocs.data.submissions.find(s => s.id === submissionId)`
`54`	`//console.debug('SUBMISSION', submission)`
`55`	`return {`
`56`	`submission,`
`57`	`}`
`58`	`} catch(e) {`
`59`	`console.debug('error', e)`
`60`	`}`
`61`
`62`	`}`

`1`	`import * as wmill from "npm:windmill-client@1"`
`2`	`import axios from "npm:axios"`
`3`
`4`	`export async function main(`
`5`	`nextcloudResource: string,`
`6`	`userId: string\|null = null,`
`7`	`formHash: string,`
`8`	`submissionId: number,`
`9`	`useAppApiAuth: boolean = false,`
`10`	`) {`
`11`	`const ncResource = await wmill.getResource(`
`12`	`nextcloudResource,`
`13`	`);`
`14`
`15`	`const url = ncResource.baseUrl + '/ocs/v2.php/apps/forms/api/v2/submissions/' + formHash`
`16`	`console.debug('url', url)`
`17`	`const config = {`
`18`	`...(!useAppApiAuth && ({`
`19`	`auth: {`
`20`	`username: ncResource.username,`
`21`	`password: ncResource.password,`
`22`	`},`
`23`	`})),`
`24`	`headers: {`
`25`	`//'authorization' : 'basic ' + btoa(ncResource.username + ':' + ncResource.password),`
`26`	`'content-type': 'application/json',`
`27`	`'ocs-apirequest': true,`
`28`	`...(useAppApiAuth && ({`
`29`	`"AA-VERSION": "2.3.0",`
`30`	`"EX-APP-ID": "flow",`
`31`	`"EX-APP-VERSION": "1.0.0",`
`32`	`"AUTHORIZATION-APP-API": btoa(`
`33`	`${userId \|\| ncResource.username}:${ncResource.password}`,
`34`	`),`
`35`	`})),`
`36`	`},`
`37`	`}`
`38`	`console.debug('config', config)`
`39`	`try {`
`40`	`const resp = await axios.get(url, config)`
`41`	`console.debug('RESPONSE', resp.data)`
`42`	`const submission = resp.data.ocs.data.submissions.find(s => s.id === submissionId)`
`43`	`//console.debug('SUBMISSION', submission)`
`44`	`return {`
`45`	`submission,`
`46`	`}`
`47`	`} catch(e) {`
`48`	`console.debug('error', e)`
`49`	`}`
`50`	`}`

`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`	`userId: string \| null = null,`
`13`	`formId: string,`
`14`	`submissionId: number,`
`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((ncResource.username) + ':' + ncResource.password)}`);
`24`	`if (useAppApiAuth) {`
`25`	`request.headers.set("AA-VERSION", ncResource.aa_version,);`
`26`	`request.headers.set("EX-APP-ID", ncResource.app_id,);`
`27`	`request.headers.set("EX-APP-VERSION", ncResource.app_version,);`
`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`	`const resp = await client.GET("/ocs/v2.php/apps/forms/api/v3/forms/{formId}/submissions", {`
`39`	`params: {`
`40`	`header: {`
`41`	`"OCS-APIRequest": true,`
`42`	`},`
`43`	`query: {`
`44`	`format: "json",`
`45`	`},`
`46`	`path: {`
`47`	`formId: formId,`
`48`	`},`
`49`
`50`	`},`
`51`	`});`
`52`
`53`	`const submission = resp.data.ocs.data.submissions.find(s => s.id === submissionId)`
`54`
`55`	`return {`
`56`	`submission,`
`57`	`}`
`58`	`} catch(e) {`
`59`	`console.debug('error', e)`
`60`	`}`
`61`
`62`	`}`