What is Sales Order api endpoint

ERPNext
1

Hi friends
what is the end point for sales order, when I send aither get or post request using postman to the bellow url it return an error.

http://192.168.1.63/api/resource/Sale

i get this error

Traceback (most recent call last):
  File "/opt/bench/erpnext/apps/frappe/frappe/app.py", line 66, in application
    response = frappe.api.handle()
  File "/opt/bench/erpnext/apps/frappe/frappe/api.py", line 114, in handle
    doctype, **frappe.local.form_dict)})
  File "/opt/bench/erpnext/apps/frappe/frappe/__init__.py", line 1007, in call
    return fn(*args, **newargs)
  File "/opt/bench/erpnext/apps/frappe/frappe/client.py", line 35, in get_list
    limit_start=limit_start, limit_page_length=limit_page_length, ignore_permissions=False)
  File "/opt/bench/erpnext/apps/frappe/frappe/__init__.py", line 1235, in get_list
    return frappe.model.db_query.DatabaseQuery(doctype).execute(None, *args, **kwargs)
  File "/opt/bench/erpnext/apps/frappe/frappe/model/db_query.py", line 87, in execute
    result = self.build_and_run()
  File "/opt/bench/erpnext/apps/frappe/frappe/model/db_query.py", line 99, in build_and_run
    args = self.prepare_args()
  File "/opt/bench/erpnext/apps/frappe/frappe/model/db_query.py", line 117, in prepare_args
    self.set_optional_columns()
  File "/opt/bench/erpnext/apps/frappe/frappe/model/db_query.py", line 256, in set_optional_columns
    columns = frappe.db.get_table_columns(self.doctype)
  File "/opt/bench/erpnext/apps/frappe/frappe/database.py", line 903, in get_table_columns
    return self.get_db_table_columns('tab' + doctype)
  File "/opt/bench/erpnext/apps/frappe/frappe/database.py", line 899, in get_db_table_columns
    return [r[0] for r in self.sql("DESC `%s`" % table)]
  File "/opt/bench/erpnext/apps/frappe/frappe/database.py", line 210, in sql
    self._cursor.execute(query)
  File "/opt/bench/erpnext/env/local/lib/python2.7/site-packages/pymysql/cursors.py", line 170, in execute
    result = self._query(query)
  File "/opt/bench/erpnext/env/local/lib/python2.7/site-packages/pymysql/cursors.py", line 328, in _query
    conn.query(q)
  File "/opt/bench/erpnext/env/local/lib/python2.7/site-packages/pymysql/connections.py", line 516, in query
    self._affected_rows = self._read_query_result(unbuffered=unbuffered)
  File "/opt/bench/erpnext/env/local/lib/python2.7/site-packages/pymysql/connections.py", line 727, in _read_query_result
    result.read()
  File "/opt/bench/erpnext/env/local/lib/python2.7/site-packages/pymysql/connections.py", line 1066, in read
    first_packet = self.connection._read_packet()
  File "/opt/bench/erpnext/env/local/lib/python2.7/site-packages/pymysql/connections.py", line 683, in _read_packet
    packet.check_error()
  File "/opt/bench/erpnext/env/local/lib/python2.7/site-packages/pymysql/protocol.py", line 220, in check_error
    err.raise_mysql_exception(self._data)
  File "/opt/bench/erpnext/env/local/lib/python2.7/site-packages/pymysql/err.py", line 109, in raise_mysql_exception
    raise errorclass(errno, errval)
ProgrammingError: (1146, u"Table '_1bd3e0294da19198.tabSale' doesn't exist")
2

Frappe Cloud Order

You must need to encode first if you want to develop mobile application.
https://bhavikpatel7023.erpnext.com/api/resource/Sales%20Order

1 Like
3

dear @bhavikpatel7023
if I need to encode, how it works for Customer and Item? or only Sales Order should be encoded.
after or before encoding of sales order to which endpoint should I send?

/Sales_Order and /Sales-Order

404 NOT FOUND

4

Sales Order → Sales%20Order

2 Likes
5

Thanks a lot
it was days I was looking

1 Like