I am trying to remove the double quotation marks from the front and back of the result of this API call:
=IF(A1="","",IFERROR(WEBSERVICE("https://api.iextrading.com/1.0/stock/"&A1&"/quote/companyName"),""))
Where the contents of A1 are any stock symbol, like AMZN
The API call works perfectly...