Dear Team
i have request like xml format like from another site
my respons should be xml format like
note: BillingNo 23456-2023-11-0023BillingNo
BillNo 23456-2023-11-0023 in my request == te.name in my response
@frappe.whitelist()
def get_bill_amount(name=None):
result = frappe.db.sql(“”"
SELECT te.name, te.total_amount, te.foundation_name, te.fawateer_amount, te.service_amount, te.posting_date
FROM tabE-Fawateercom te
WHERE te.name = %s AND te.status = ‘Unpaid’ AND te.docstatus = 1
ORDER BY te.creation DESC;
“”", (name,), as_dict=True)