[REST API] Fetch parent data by filtering child

[hikmahaz]

I have custom parent docType Individual that has Category (also custom) as its child (category_name goes here) and want to get all Individual data that has certain category_name using rest api. Is this possible? and if it is, how?
This is one of many combination I’ve tried. Most of them resulted in similar response.

[NCP]

Hi @hikmahaz,

Please set API like:
{erpnext.url}/api/resource/Individual?filters=[[“Category”,“category_name”,“=”,“Influencer”]]

More Details for:
https://frappeframework.com/docs/v13/user/en/guides/integration/rest_api/listing_documents

Thank You!

[NCP]

And also check-in erpnext like:

Thanks.

[Domino]

Hi @NCP ,
i have to access child table it is in Project doctype itself.
i tried these /api/resource/<child doctype>
but it does not working.

is any other way to access child doctype ?

[FHenry]

Hi,

There is no acces to Child DocType by API
Workaround can be something like create you own API end point

Access/GET Dynamic Links/Child Table in REST API

You can try this Server Script: docType = frappe.form_dict.docType if not docType: frappe.throw("Parameter docType missing") frappe.response['data'] = frappe.db.get_list(docType, fields=["*"]) Usage: http://localhost:8000/api/method/get_list?docType=Employee%20Skill Set it up like this and make sure that Server is enabled (see Server Script): [image]