Edits history of script submission #20446 for ' Create Cross-sheet References (smartsheet)'

• bun

  Ap­pro­ved version

  Edit in Windmill

  Embed

  //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();
  }
  

  Submitted by hugo697 235 days ago