ERPNext Permission Denied

[razyesh]

Hey, I am just trying to fetch the child table data. I got the Permission Denied message even I have access of full permission.

What i am trying to do is, “fetch Payment Entry Reference which is child table of Payment Entry”.
I have even pass the parent in url to fetch.

http://0.0.0.0:8001/api/resource/Payment Entry Reference?filters=[[“Payment Entry Reference”,“parent”,“=”,“ACC-PAY-2020-00004”]]&fields=[“*”]

[walstanb]

You cannot fetch child table data this way,
Refer,

HOW TO: Fetch Child Tables

Everyone: I’ve updated this tutorial on my website, which is much better than what is below. I’m leaving the old one as is here, as it is referenced in subsequent posts. You can click this sentence to go to the article. Expand for original post:

Fetching Child Tables DocTypeA = Source DocType (The document that holds the child table you are getting values from DocTypeB = Target DocType (The document that the values are going into ChildTableA= Source Child Table ChildTableB=Target Child …

nevertheless, there is a way to view child table data.

You need to have developer_mode: on
First of all, you need to convert the DocType to not be a child table by unchecking the Is Child Table checkbox.

Then you need to add the required permissions below.

You would now be able to view the child table list.