Does "frappe.desk.query_report.run" have a format (xlsx, csv, tsv) option?

MartinHBramwell · March 14, 2020, 2:43pm

Calling …

{{Site}}/api/method/frappe.desk.query_report.run? \
report_name=Stock+Ledger& \
filters={
  "company":"Galactic Widgets LLP",
  "from_date":"2020-01-01",
  "to_date":"2020-12-31"
}

… gets me the data I need but in JSON format.

I want CSV, so is it possible to do something like the following?

{{Site}}/api/method/frappe.desk.query_report.run? \
report_name=Stock+Ledger& \
filters={
  "company":"Galactic Widgets LLP",
  "from_date":"2020-01-01",
  "to_date":"2020-12-31"
}& \
format=csv

Am I right that this is the code for that RPC call?

github.com

frappe/frappe/blob/develop/frappe/desk/query_report.py#L164


      
          	if os.path.exists(script_path):
          		with open(script_path) as f:
          			script = f.read()
          			script += f"\n\n//# sourceURL={scrub(report.name)}.js"
          
          
	html_format = get_html_format(print_path)
          
          
	if not script and report.javascript:
          		script = report.javascript
          		script += f"\n\n//# sourceURL={scrub(report.name)}__custom"
          
          
	if not script:
          		script = "frappe.query_reports['%s']={}" % report_name
          
          
	return {
          		"script": render_include(script),
          		"html_format": html_format,
          		"execution_time": frappe.cache().hget("report_execution_time", report_name) or 0,
          	}

If so It doesn’t look like alternate formatting is an option.

For what it’s worth, here’s what I am trying to do:

I need to explain/justify/document accounting and stock movements to a company accountant for the entire process from BoM, purchasing, manufacturing, sales, billing, delivery.

To do it I hoped to semi-automate the tedious job of highlighting the differences between reports taken before and after each transaction.

Manually generating the reports is time consuming, so I am trying to get csv formatted reports from the RPC API.