you must now specify XML data
Posted: Mon Apr 21, 2025 8:38 am
The data from the API query is now loaded into the field as XML. This XML string now serves as your data source – you load it into a field once so you don't repeat the query at every intermediate step. This keeps your API credit usage to a minimum.
In the next step, you will process the XML data using the FILTERXML function. The syntax is as follows:
XMLFILTERN(XML, XPath)In this function, and the XPath for addressing belgium cell phone number list/ the element to be read. You load the XML data directly from the table field in which you previously loaded the API query using the WEBDIENST() function.
When it comes to XPath, however, you now have to go one level deeper. In Google Sheets, it was possible to read all the elements of the parent element—but Excel wants to know exactly which subelements the data should be extracted from.
In the next step, you will process the XML data using the FILTERXML function. The syntax is as follows:
XMLFILTERN(XML, XPath)In this function, and the XPath for addressing belgium cell phone number list/ the element to be read. You load the XML data directly from the table field in which you previously loaded the API query using the WEBDIENST() function.
When it comes to XPath, however, you now have to go one level deeper. In Google Sheets, it was possible to read all the elements of the parent element—but Excel wants to know exactly which subelements the data should be extracted from.