hi, i new on erpnext but need a easy form to return a doctype list in json, i read documentation but need some step can’t manage from web explorer. Need help to make some like:
but now the result is like
of course i try with token but need a clear url get/post to obtain data, this is because need obtaind data from a thirt party (excel like) data.
how to manage or create this request idealy without programing?
If you need the JSON,
You should be trying the following url in your browser:
yourerpsite/api/resource/Customer
Would suggest going through the right resources:
https://frappeframework.com/docs/user/en/guides/integration/rest_api#rest
https://frappeframework.com/docs/user/en/guides/integration/rest_api/listing_documents
https://frappeframework.com/docs/user/en/guides/integration/rest_api/manipulating_documents
i try exactly as described but every request return
Server Error
Traceback (most recent call last):
File “/home/erp/frappegt/apps/frappe/frappe/app.py”, line 68, in application
response = frappe.api.handle()
File “/home/erp/frappegt/apps/frappe/frappe/api.py”, line 129, in handle
data = frappe.call(frappe.client.get_list, doctype, **frappe.local.form_dict)
File “/home/erp/frappegt/apps/frappe/frappe/init.py”, line 1172, in call
return fn(*args, **newargs)
File “/home/erp/frappegt/apps/frappe/frappe/client.py”, line 48, in get_list
return frappe.get_list(**args)
File “/home/erp/frappegt/apps/frappe/frappe/init.py”, line 1406, in get_list
return frappe.model.db_query.DatabaseQuery(doctype).execute(*args, **kwargs)
File “/home/erp/frappegt/apps/frappe/frappe/model/db_query.py”, line 101, in execute
self.columns = self.get_table_columns()
File “/home/erp/frappegt/apps/frappe/frappe/model/db_query.py”, line 338, in get_table_columns
return get_table_columns(self.doctype)
File “/home/erp/frappegt/apps/frappe/frappe/model/meta.py”, line 49, in get_table_columns
return frappe.db.get_table_columns(doctype)
File “/home/erp/frappegt/apps/frappe/frappe/database/database.py”, line 894, in get_table_columns
raise self.TableMissingError(‘DocType’, doctype)
pymysql.err.ProgrammingError: (‘DocType’, ‘employee’)
unknow if is my install, i try with 2 more servers.
ok i think the problem is because api is Case Sensitive, if use name exactly title work fine in mayor times.
tanks.
