Google-sheets – Unable to importxml from this URL

google sheetsimportxmlxmlxpath

I am trying to fetch url using =importxml in Google Sheets, but getting error message, could not connect to url.

He is the formula which I am using:

=IMPORTXML("https://api.exotel.com/v1/Accounts/adani1/Calls/204f65298ee96c915f57fc4c1df94a46","//*[@id='collapsible1']/div[1]/div[2]/div[9]/span[2]")

Ultimately I want to fetch "Status" from this URL.

Any idea how to correct this?

Best Answer

IMPORTXML only is able to access public web resources but he URL in the formula requires user and password so it couldn't be reached.