Stock Balance Query Report api filter format

[Navya_shree]

Hi ,

I have field ‘warehouse’ with multiple values a,b,c,d,e

I want to filter warehouse with ‘a’ and ‘b’ values in stock balance report api

http://domain.erpnext.com/api/method/frappe.desk.query_report.run?report_name=Stock%20Balance&fields[‘item_code’,‘item_name’,‘warehouse’,'bal_qty]
&filters={‘from_date’:‘2024-01-01’, ‘to_date’:’ 2024-01-01’}
&ignore_prepared_report=True"

Please provide solution

[NCP]

http://domain.erpnext.com/api/method/frappe.desk.query_report.run?report_name=Stock Balance&fields=["item_code","item_name","warehouse","bal_qty"]&filters={"from_date":"2024-01-01","to_date":"2024-01-01","warehouse":"Stores - FT"}&ignore_prepared_report=True

Reference:

REST API for Report

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] Thank You!

[Navya_shree]

@NCP

"warehouse":"Stores - FT"

Hi NCP,

For single value fetch it will work , but i want to filter warehouse for 2 values , like warehouse = a or warehouse = b ,

Also even though i mention specific fields in fields argument , it will fetch all feilds

[NCP]

@Navya_shree

like warehouse = a or warehouse = b ,

I believe it’s not possible because the warehouse filter allows for only a single selection, not multiple selections.

[Navya_shree]

Ok ,

Thank You