@Banuka Thanks for reaching out.
It is not possible to achieve load balancing between two backends using a custom connector. Custom connectors are designed to connect to a single backend service, and each connection instance in a custom connector can only point to a single endpoint.
To achieve load balancing between two backends, you can use Azure Traffic Manager. Traffic Manager is a DNS-based traffic load balancer that can distribute traffic between multiple endpoints, including Azure Web Apps, Azure Cloud Services, and external endpoints.
In your custom connector you will use the Azure traffic manager endpoint and at traffic manager end you can configure your two backend endpoint and select the routing method as per your business need.
Feel free to get back to me if you have any queries or concerns.
Please accept as "Yes" if the answer is helpful so that it can help others in the community.