title: GoogleSheet: IMPORTXML error, resource at url not found?
body: <p>What you will see from images below is that A1 is filled with random number which generated from the script. The number will change randomly every-time cursor is moved, it's used in method for "forcing update the XML data" in Google Sheets.</p>
  
  <p><a href="https://i.stack.imgur.com/FTbUG.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/FTbUG.png" alt="Picture 1"></a></p>
  
  <p>as we can see from the 1st picture, the IMPORTXML worked like charm, using <code>=IMPORTXML("Link" &amp;A1(which is the random number, that is needed to update the data), "//target content")</code> recipe</p>
  
  <p>Well, it worked out for the 1st link, but not really for the second one, in the 1st image, B2 is using the last link, and it shows <code>1736.5</code> as the value, that is showing fine without using <code>&amp;A1</code> code</p>
  
  <p><a href="https://i.stack.imgur.com/CiAFX.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/CiAFX.png" alt="Picture 2"></a></p>
  
  <p>After adding &amp;A1 to the formula, it gives error <code>#N/A</code> and <code>Resource at url not found</code> as the error detail.</p>
  
  <p>I already tried to use another cell with calculated numbers(more than A1 or less than), still gives me that error.</p>