Unable to access a http service from private IP address over VPC Connector in Google cloud function

Question

I have a service that runs in a compute instance and can access with private IP address like this(https://172.31.93.233/proxy.php). I want to make an https request from a cloud function to access this service so I created a connector(with IP range: 172.31.0.0/28) to VPC which has an IP range:172.30.0.0/16 and connector have Ingress settings( Allow all traffic) and Egress settings( Route all traffic through the VPC connector). BUT somehow my function failed to complete the request and stated this in a log: "Function execution took 60002 ms, finished with status: ‘timeout’ Both the VPC and function are in the same region(us-central1)

Extra additional information: Actually the main https service is deployed at the AWS side and I am using Site to Site VPN b/w AWS to GCP to accessing this service with GCP. I can confirm that this service is accessible at GCP compute instance under the same VPC which I connected to the VPN.

I have created a serverless connector through a web console while creating a function. In IAM I can see the following permission with service accounts:

1: Serverless VPC Access Service Agent(Serverless VPC Access Admin, Serverless VPC Access Service Agent)

2: Google Cloud Functions Service Agent( Cloud Functions Service Agent, Serverless VPC Access Admin)

3: My own account from where I a testing function from GCP(Editor, Owner, Serverless VPC Access Admin)

There are other service accounts as well but I don't think they are related or interesting to testing function etc.

Here is my sample function code:

var http = require('https');
exports.helloWorld = (req, res) => {
  http
        .get('https://172.31.93.233/proxy.php?api=catalogos_direcciones', resp => {
            let data = ''
            resp.on('data', chunk => {
                data += chunk
            })
            resp.on('end', () => {
                let peopleData = JSON.parse(data)
                console.log(peopleData);
                res.status(200).json(peopleData);
               
            })
        })
 
};