Create Cross-sheet References

//native

type Smartsheet = {

  token: string;

  baseUrl: string;

};

/**

 * Create Cross-sheet References

 * Adds a cross-sheet reference between two sheets and defines the data range for formulas. Each distinct data range requires a new cross-sheet reference.

 */

export async function main(

  auth: Smartsheet,

  sheetId: string,

  body:

    | {

        sourceSheetId?: number;

        name?: string;

        endColumnId?: number;

        startColumnId?: number;

      }

    | {

        sourceSheetId?: number;

        name?: string;

        endRowId?: number;

        startRowId?: number;

      }

    | {

        sourceSheetId?: number;

        name?: string;

        endColumnId?: number;

        endRowId?: number;

        startColumnId?: number;

        startRowId?: number;

      },

) {

  const url = new URL(

    `${auth.baseUrl}/sheets/${sheetId}/crosssheetreferences`,

  );

  const response = await fetch(url, {

    method: "POST",

    headers: {

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

      Authorization: "Bearer " + auth.token,

    },

    body: JSON.stringify(body),

  });

  if (!response.ok) {

    const text = await response.text();

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

  }

  return await response.json();

}