Add or update columns of a table

//native

type Grist = {

  apiKey: string;

  host: string;

};

/**

 * Add or update columns of a table

 *

 */

export async function main(

  auth: Grist,

  docId: string,

  tableId: string,

  noadd: string | undefined,

  noupdate: string | undefined,

  replaceall: string | undefined,

  body: {

    columns: {

      id: string;

      fields: {

        type?:

          | "Any"

          | "Text"

          | "Numeric"

          | "Int"

          | "Bool"

          | "Date"

          | "DateTime:<timezone>"

          | "Choice"

          | "ChoiceList"

          | "Ref:<tableId>"

          | "RefList:<tableId>"

          | "Attachments";

        label?: string;

        formula?: string;

        isFormula?: false | true;

        widgetOptions?: string;

        untieColIdFromLabel?: false | true;

        recalcWhen?: number;

        visibleCol?: number;

      } & { recalcDeps?: string } & { colId?: string };

    }[];

  },

) {

  const url = new URL(

    `https://${auth.host}/api/docs/${docId}/tables/${tableId}/columns`,

  );

  for (const [k, v] of [

    ["noadd", noadd],

    ["noupdate", noupdate],

    ["replaceall", replaceall],

  ]) {

    if (v !== undefined && v !== "" && k !== undefined) {

      url.searchParams.append(k, v);

    }

  }

  const response = await fetch(url, {

    method: "PUT",

    headers: {

      "Content-Type": "application/json",

      Authorization: "Bearer " + auth.apiKey,

    },

    body: JSON.stringify(body),

  });

  if (!response.ok) {

    const text = await response.text();

    throw new Error(`${response.status} ${text}`);

  }

  return await response.text();

}