Tuesday, 27 March 2018

Get list api in frappe


http://0.0.0.0:8000/api/method/bnd.api.mahesh.get_leave_application?employee=EMP/0003&&from_date=2018-03-29
here bnd is application name , api is directory, mahesh is python file under api directory, get_leave_application is method 

@frappe.whitelist(allow_guest=True)
def get_leave_application(employee='',from_date=''):
leave_list = ''

if employee and from_date:
leave_list = frappe.db.sql("""select employee,status, leave_type,leave_balance, from_date, to_date, total_leave_days ,description, leave_approver, posting_date, company, half_day_date
from `tabLeave Application` WHERE employee='{0}' and from_date='{1}' """.format(employee,from_date),as_dict=1)
elif employee :
leave_list = frappe.db.sql("""select employee, status,leave_type, leave_balance, from_date, to_date, total_leave_days ,description, leave_approver, posting_date, company, half_day_date
from `tabLeave Application` WHERE employee='{0}'""".format(employee),as_dict=1)

return leave_list

No comments:

Post a Comment

Django rest api - filter

views.py from django_filters.rest_framework import DjangoFilterBackend class PollList(viewsets.ModelViewSet):     queryset = X.objects...