I am trying to see if it is possible to redirect traffic based on if you have a VPN connection yes or no.
What I want to achieve is that if you have VPN Connection, the URL redirect will go to site A, if you don't have a VPN connection you will be redirected to site B.
Is such scenario possible?
You want to set a Request Forwarding Load Balancer Rule.
That being said, you probably want to go with a more advanced platform like Avi if your requirements are that complex. In my experience, once people figure out you have load balancing super powers the requests come out of the woodwork and you want that feature palette.