Edits history of script submission #14993 for ' Generate Excel report (codat)'

• bun

  Ap­pro­ved version

  Edit in Windmill

  Embed

  //native
  type Codat = {
  	encodedKey: string
  }
  /**
   * Generate Excel report
   * The *Generate Excel report* endpoint requests the production of a downloadable Excel file for a report type specified in the `reportType` query parameter.
   */
  export async function main(
  	auth: Codat,
  	companyId: string,
  	reportType: 'audit' | 'enhancedFinancials' | 'enhancedInvoices' | 'enhancedCashFlow' | undefined
  ) {
  	const url = new URL(`https://api.codat.io/data/companies/${companyId}/assess/excel`)
  	for (const [k, v] of [['reportType', reportType]]) {
  		if (v !== undefined && v !== '' && k !== undefined) {
  			url.searchParams.append(k, v)
  		}
  	}
  
  	const response = await fetch(url, {
  		method: 'POST',
  		headers: {
  			Authorization: `Basic ${auth.encodedKey}`
  		},
  		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