When I add any field that is a child table, there is an error. When I change the field to list into a Data or any other datatype which is not a child table, it works as expected.
It works to get the actual document and returns child tables as expected: https://my.erpnext/api/resource/Item/NAME
Example working: https://my.erpnext/api/resource/Item?fields=[“description”]
Example failing: https://my.erpnext/api/resource/Item?fields=[“barcodes”]
["Syntax error in query:\nselect \n\t\t\tfrom tabItem\n\t\t\t\n\t\t\t\n\t\t\t\n\t\t\tlimit 9999 offset 0 ", "Traceback (most recent call last):\n File \"apps/frappe/frappe/app.py\", line 82, in application\n response = frappe.api.handle()\n File \"apps/frappe/frappe/api.py\", line 53, in handle\n return _RESTAPIHandler(call, doctype, name).get_response()\n File \"apps/frappe/frappe/api.py\", line 71, in get_response\n self.handle_resource()\n File \"apps/frappe/frappe/api.py\", line 85, in handle_resource\n self.handle_doctype_resource()\n File \"apps/frappe/frappe/api.py\", line 107, in handle_doctype_resource\n self.get_doc_list()\n File \"apps/frappe/frappe/api.py\", line 179, in get_doc_list\n data = frappe.call(frappe.client.get_list, self.doctype, **frappe.local.form_dict)\n File \"apps/frappe/frappe/__init__.py\", line 1620, in call\n return fn(*args, **newargs)\n File \"apps/frappe/frappe/utils/typing_validations.py\", line 29, in wrapper\n return func(*args, **kwargs)\n File \"apps/frappe/frappe/client.py\", line 63, in get_list\n return frappe.get_list(**args)\n File \"apps/frappe/frappe/__init__.py\", line 1885, in get_list\n return frappe.model.db_query.DatabaseQuery(doctype).execute(*args, **kwargs)\n File \"apps/frappe/frappe/model/db_query.py\", line 196, in execute\n result = self.build_and_run()\n File \"apps/frappe/frappe/model/db_query.py\", line 236, in build_and_run\n return frappe.db.sql(\n File \"apps/frappe/frappe/database/database.py\", line 228, in sql\n self._cursor.execute(query, values)\n File \"env/lib/python3.10/site-packages/pymysql/cursors.py\", line 158, in execute\n result = self._query(query)\n File \"env/lib/python3.10/site-packages/pymysql/cursors.py\", line 325, in _query\n conn.query(q)\n File \"env/lib/python3.10/site-packages/pymysql/connections.py\", line 549, in query\n self._affected_rows = self._read_query_result(unbuffered=unbuffered)\n File \"env/lib/python3.10/site-packages/pymysql/connections.py\", line 779, in _read_query_result\n result.read()\n File \"env/lib/python3.10/site-packages/pymysql/connections.py\", line 1157, in read\n first_packet = self.connection._read_packet()\n File \"env/lib/python3.10/site-packages/pymysql/connections.py\", line 729, in _read_packet\n packet.raise_for_error()\n File \"env/lib/python3.10/site-packages/pymysql/protocol.py\", line 221, in raise_for_error\n err.raise_mysql_exception(self._data)\n File \"env/lib/python3.10/site-packages/pymysql/err.py\", line 143, in raise_mysql_exception\n raise errorclass(errno, errval)\npymysql.err.ProgrammingError: (1064, \"You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'from tabItem\\n\\t\\t\\t\\n\\t\\t\\t\\n\\t\\t\\t\\n\\t\\t\\tlimit 9999 offset 0' at line 2\")\n"]