My URL contains a quote character, and Google Spreadsheets see this as the end of the URL whereas it is not.https://api.archives-ouvertes.fr/search/?fq=producedDateY_i:[2013 TO 2015]&fq=docType_s:ART&rows=0How can I use an URL with ImportXML() that has a quote character in it?
How to insert quote character () as an element of URL in importXML function?
google spreadsheets
Double the quote character, instead of  use .Another alternative is to put the URL alone on cell, lets say A1, then put the cell reference in your formula:   =IMPORTXML(A1,//div)