ERPNext.com Frappe Cloud Support Partners Foundation Frappe School

REST API : How to access data in Item child table

Hi,

I tried to access supplier_part_no in Item document for specific supplier with this GET method
https://requay.erpnext.com/api/resource/Item/?filters=[[“Item”, “supplier”, “=”, “TEST”]]&fields=[“supplier_part_no”]
However I get error “Unknown column ‘tabItem.supplier_part_no’ in ‘field list’\”)\n"]"

Anyone can help me on this ?

Thanks.

Good day sir. Are you able to solve this problem? I’m having the same issue. Thank you in advance

1 Like

Example:

To access Sales Invoice data:

http://localhost:9010/api/resource/Sales Invoice/?filters=[["Sales Invoice", "name", "=", "SINV-1911-00052"]]&fields=["name", "grand_total"]

To access Sales Invoice Item data

http://localhost:9010/api/resource/Sales Invoice Item/?filters=[["Sales Invoice Item", "parent", "=", "SINV-1911-00052"]]&fields=["qty", "rate"]

This may helps you.

1 Like

It works with parent doctypes. But in child tables like this:

-> http://localhost:9010/api/resource/Item Supplier/?filters=[[“Item Supplier”, “parent”, “=”, “CBC”]]&fields=[“parent”]’

it returns an error
-> ‘resulted in a `403 FORBIDDEN’

Well it worked please check your syntax

i tried to fetch sales invoice item name

@khushal_t, thank you for your kind help. I was able to solve the problem. I created a whitelisted method in childtable (Item SUpplier) .py file. I was able to call it with:

http://localhost:9010/api/method/erpnext.stock.doctype.item_supplier.item_supplier.get_item_supplier

Yeah but that seems it is RPC you have implemented not the REST

Hi I am facing same issue. Is anyone know how to resolve ‘403 FORBIDDEN’? Thanks in advance

My colleague found the solution. It will fetch all data and child table.
Example:
http://localhost:9010/api/resource/Sales%20Invoice/SINV-1911-00052

1 Like