Get all item stock via REST API

1

Hello everyone,
I want to know if erpenext has a predefined function that allows to return the stock of all items
like erpnext.stock.utils.get_stock_balance returns the stock of a specific item and warehouse, but I want for all items.
I tried this in the server script but it doesn’t work
stock_balances = frappe.db.sql(“”"
SELECT
item_code,
warehouse,
actual_qty
FROM
tabBin
“”", as_dict=True)
i need a rep as soon as possible please

2

You could try this:

bins = frappe.get_all("Bin", fields=["item_code", "warehouse", "actual_qty"])

Note I haven’t tested this. You could refer to the db API docs for more info if you needed: docs

3

Just a note: you title your post with “via REST API”, but the code you show doesn’t look like an access attempt to a rest api.

See: REST API

4

thanks for your note
but i want to tell that via api (this code I write it in server script) and i the method in postman via /api/method/custom

1 Like
5

Thanks a lot, it works

2 Likes
8

Okay it turns out that Bin is a DocType not a report. So I used the normal format

api/resource/Bin