Downloads a file from the Xero Files service

Procedure-Specific Information

There are two different ways to download a file. If you provide a DownloadPath, then the file is downloaded and its contents are stored at that location:

EXECUTE DownloadFile @FileID = '...', @DownloadPath = 'c:/my/xero/files/form.docx'

If you do not provide a DownloadPath, then the contents of the file are base64 encoded and returned in the FileData output:

EXECUTE DownloadFile @FileID = '...'

Input

Name	Type	Required	Description
FileId	String	True	The ID of the file to download
DownloadPath	String	False	Where to write the downloaded file.
TenantId	String	False	The ID of the tenant to query instead of the connection tenant

Result Set Columns

Name	Type	Description
FileData	String	If the DownloadPath and FileStream are not provided, this contains the base64 encoded content of the file.
Success	String	This parameter sets whether the operation was successful or not.