title: Google sheets IMPORTXML Return no Data N/A
body: <p>I want to parse such <a href="https://ted.europa.eu/udl?uri=TED:NOTICE:641339-2021:XML:DE:HTML" rel="nofollow noreferrer">XML</a> File using Google sheets Importxml function</p>
  <pre><code>=IMPORTXML(&quot;https://ted.europa.eu/udl?uri=TED:NOTICE:641339-2021:XML:DE:HTML&quot;; &quot;/TED_EXPORT/TECHNICAL_SECTION/RECEPTION_ID&quot;)
  </code></pre>
  <p><strong>Returns Error: No Data - N/A</strong></p>
  <p>According to this <a href="https://www.easycodeforall.com/generate-xpath.html" rel="nofollow noreferrer">tool</a> its a valid XPATH and contains data</p>