Api endpoint for Power Bi

I want integrate erpnext sales data with Microsoft powerbi but not find a samples for rest services or web API.

Thanks

hi @enriweb77,

Please refer to https://frappe.github.io/frappe/user/en/guides/integration/rest_api.html

Thanks, Makarand

1 Like

Thanks
have you a sample url string to get sales order data ?

Hi @enriweb77,

GET http://sample.erpnext.com/api/resourse/Sales Order
This will give you the list of all the Sales Order but, first you will need use the login API.

POST http://sample.erpnext.com/api/method/login?usr=username&pwd=passwd

just replace the sample.erpnext.com with your ERPNext application’s URL

you can also apply the filters and choose which fields to fetch. Please check the Listing Documents section in REST API page.

Thanks, Makarand

1 Like