XML Import refresh

[Aang6678]

In my google sheet, I have The following statements:

=ImportXML("http://api.eve-central.com/api/marketstat?typeid="&JOIN("&typeid=",$B2:$B144)&"&usesystem="&JOIN(",",$G2), "//marketstat/type/buy/max")

=ImportXML("http://api.eve-central.com/api/marketstat?typeid="&JOIN("&typeid=",$B2:$B144)&"&usesystem="&JOIN(",",$F2), "//marketstat/type/buy/max")

=ImportXML("http://api.eve-central.com/api/marketstat?typeid="&JOIN("&typeid=",$J2:$J30)&"&usesystem="&JOIN(",",$G2), "//marketstat/type/buy/max")

=ImportXML("http://api.eve-central.com/api/marketstat?typeid="&JOIN("&typeid=",$J2:$J30)&"&usesystem="&JOIN(",",$F2), "//marketstat/type/buy/max") 

The issue that I have is that every few minutes I have to go back and switch http to https and vice versa because I will get an error that google can't fetch the URL.

Any solutions?

[W Stacy Lockwood]

On Friday, March 17, 2017 at 9:08:34 PM UTC-5, Aang6678 wrote:

In my google sheet, I have The following statements:

The issue that I have is that every few minutes I have to go back and switch http to https and vice versa because I will get an error that google can't fetch the URL.

Any solutions?

Thank you! This IS a solution for me! :-D I get what you're saying though, and I have the same basic issue. I really want to be able to limit WHEN Google goes to fetch the data, but it's not something I've been able to figure out how to control.