Reports can be accessed in either CSV, XML or Excel formats using a simple URL:

[path to FIVE CRM installation]/api.php?mode=report&hash=<hash>&type=<report type>&name=<report name>&format=<format>

Parameters

<type> can either be SQL or RW dependant if the report is SQL report or a Report Writer report.

<name> is the name of the report.

<format> is either CSV, XML or ZIP. If omitted or an unknown format is used, the system will output a CSV file.

<v[number]> (optional) This is for reports which use variable selection criteria. *null can be used to omit the variable selection criteria. An example URL being (where v1 is the customerstatus, v2 is the project and v3 is the owner): https://demo.fivecrm.com/123456/api.php?mode=report&hash=e222e3075db2ad1c6cf151 b47d378f70&type=RW&name=Status+Report&format=xml&v1=customer&v2=project+b&v 3=*null