Edits history of script submission #20541 for ' Search Sheet (smartsheet)'

• bun

  Ap­pro­ved version

  Edit in Windmill

  Embed

  //native
  type Smartsheet = {
    token: string;
    baseUrl: string;
  };
  /**
   * Search Sheet
   * Gets a list of the user's search results in a sheet based on query. The list contains an abbreviated row object for each search result in a sheet. If you have not used the public API in a while, we will need to provision your data. This could take up to 24 hours so please check back later! *Note* Newly created or recently updated data may not be immediately discoverable via search.
   */
  export async function main(
    auth: Smartsheet,
    sheetId: string,
    query: string | undefined,
  ) {
    const url = new URL(`${auth.baseUrl}/search/sheets/${sheetId}`);
    for (const [k, v] of [["query", query]]) {
      if (v !== undefined && v !== "" && k !== undefined) {
        url.searchParams.append(k, v);
      }
    }
    const response = await fetch(url, {
      method: "GET",
      headers: {
        Authorization: "Bearer " + auth.token,
      },
      body: undefined,
    });
    if (!response.ok) {
      const text = await response.text();
      throw new Error(`${response.status} ${text}`);
    }
    return await response.json();
  }
  

  Submitted by hugo697 235 days ago