LOAD CSV from URL gives an error for a https url but is ok for http url

[ravi]

I created a neo4j causal cluster 4.0.4 on GCP.
While I am trying to load the csv with

<LOAD CSV WITH HEADERS FROM 'https://neo4j.com/docs/cypher-manual/4.0/csv/artists-with-headers.csv' AS line
CREATE (:Artist { name: line.Name, year: toInteger(line.Year)})>

I get a Neo.ClientError.Statement.ExternalResourceFailed error

However, I am able to load the following csv
<LOAD CSV FROM "http://data.neo4j.com/examples/person.csv" AS line
MERGE (n:Person {id: toInteger(line[0])})
SET n.name = line[1]
RETURN n>

I dont encounter any such issues in loading csv on a 3.5 causal cluster. I am sure its a config setting but am unable to figure out as I seem to have looked at the areas that are generally mentioned in stackoverflow

[webtic]

Is there any detail logged in the query.log file?
Just tried it on a fresh 4.0.3 and it returns data:

LOAD CSV WITH HEADERS FROM "https://neo4j.com/docs/cypher-manual/4.0/csv/artists-with-headers.csv" as line return line

[ravi]

I don't see anything relevant to this query in the query.log . Most of whats in the query.log reads like
CALL dbms.routing.getRoutingTable()
CALL dbms.showCurrentUser()
CALL dbms.listConfig()