0

Download spend analysis report

by
Published Oct 17, 2025

Download spend analysis report that has already been successfully created. The report will be in Open XML spreadhseet format (.xlsx), which can be opened with Microsoft Excel.

Script codat Verified

The script

Submitted by hugo697 Bun
Verified 235 days ago
1
//native
2
type Codat = {
3
	encodedKey: string
4
}
5
/**
6
 * Download spend analysis report
7
 * Download spend analysis report that has already been successfully created.  The report will be in Open XML spreadhseet format (.xlsx), which can be opened with Microsoft Excel.
8
 */
9
export async function main(auth: Codat, companyId: string) {
10
	const url = new URL(
11
		`https://banking-api.codat.io/companies/${companyId}/reports/spendAnalysis/excel`
12
	)
13

14
	const response = await fetch(url, {
15
		method: 'GET',
16
		headers: {
17
			Authorization: `Basic ${auth.encodedKey}`
18
		},
19
		body: undefined
20
	})
21
	if (!response.ok) {
22
		const text = await response.text()
23
		throw new Error(`${response.status} ${text}`)
24
	}
25
	return await response.text()
26
}
27