Intergration API

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 == in my response

def get_bill_amount(name=None):
result = frappe.db.sql(“”"
SELECT, te.total_amount, te.foundation_name, te.fawateer_amount, te.service_amount, te.posting_date
FROM tabE-Fawateercom te
WHERE = %s AND te.status = ‘Unpaid’ AND te.docstatus = 1
ORDER BY te.creation DESC;
“”", (name,), as_dict=True)