REST API for Report

ERPNext
,
1

I’m trying to get report through REST API. I found one way from older post in this forum, but it return me an error like this:

image
image1491×836 79.7 KB

Anybody knows how to do query report through API or why i get this kind of errror

2

Hi,

Balance sheet report is based on two types, “Fiscal Year” and “Date Range”.

Please pass the filter parameters for report based on, either fiscal year or date range and accordingly either pass fiscal year range or date range.

3

Thanks @mangroliya
I’m accessing balance sheet on my demo instance and my url looks like this:

app/query-report/Balance%20Sheet?company=Kidsland%20International%20School&filter_based_on=Fiscal%20Year&period_start_date=2023-01-01&period_end_date=2023-12-31&from_fiscal_year=2023&to_fiscal_year=2023&periodicity=Yearly

and it showing

image
image1247×789 40 KB

But when i try to pass these parameters to my postman, i get nothing:

image
image1485×886 52.8 KB

4

is someone can help me for this issue? why my query return nothing?

5

Please help on this issue.
How to at least get my report from ERPNext API?

6

Hi @oscarutomo,

We make a api response link for data show:

http://ncp-erpnext.com:8000/api/method/frappe.desk.query_report.run?report_name=Balance%20Sheet&filters={%22company%22:%22Solufy%22,%22filter_based_on%22:%22Date%20Range%22,%22period_start_date%22:%222022-04-01%22,%22period_end_date%22:%222023-03-31%22,%22periodicity%22:%22Yearly%22}

In postman does not work because login is mandatory for it but you use in browser URL and past it then shows properly.

image
image960×433 218 KB

Thank You!

7

Thanks @NCP … found why mine cannot works.
“filter_based_on” should be “Date Range”. meanwhile, i’m using “Fiscal Year”

but either postman or browser, it works well

1 Like
8

Correction, it’s not the matter of “filter_based_on” but the matter of “Company”. on my filters parameter, i don’t pass “company” name.