Extracting value using XPath from a XML data file for Google docs

[krofox]

I have been trying since long to extract data using xpath in google sheets but everytime 'am getting message 'imported content is empty'. i need help . The url is http://reports.ieso.ca/public/IntertieScheduleFlow/PUB_IntertieScheduleFlow.xml

[krofox]

To add further to my earlie question ...the page source shows

<?xml version="1.0" encoding="UTF-8"?>
<?xml-stylesheet type="text/xsl" href="http://reports.ieso.ca/docrefs/stylesheet/IntertieScheduleFlow_HTML_t1-2.xsl" ?><IMODocument docID="IntertieScheduleFlow" xmlns="http://www.theIMO.com/schema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.theIMO.com/schema http://reports.ieso.ca/docrefs/schema/IntertieScheduleFlow_r2.xsd">
<IMODocHeader>
<DocTitle>Intertie Schedule and Flow Report</DocTitle>
<DocRevision>2</DocRevision>
<DocConfidentiality>
<DocConfClass>PUB</DocConfClass>
</DocConfidentiality>
<CreatedAt>2015-08-22T15:30:46</CreatedAt>
</IMODocHeader>
<IMODocBody>
<Date>2015-08-22</Date>
<IntertieZone>
<IntertieZoneName>MANITOBA</IntertieZoneName>
<Schedules>
<Schedule>
<Hour>1</Hour>
<Import>30</Import>
</Schedule>

And i tried the following xpath
/IMODocument/IMODocBody/IntertieZone[1]/Schedules/Schedule[1]

I would like to extract the value of Import 30 ;
I think i am clear in explaning my problem a bit in detail
Thanks

[xml_looser]

Hello unprecedented way

Your Probelm is handling namespace

to you shall define a namespace
and then start with XPath

example

from Google XML file

xmlns = "http://www.theIMO.com/schema"

So give to name as a parameter http://www.theIMO.com/schema

or as a variable

ns1 = "http://www.theIMO.com/schema"

I choose the second path

so should be used with

// ns1: Export

all exports are found

now work with square brackets

[krofox]

Hello Sir,

You mean to say
url would be "http://www.theIMO.com/schema"

and Query path would be "// ns1: Export" (right?)

if you don't mind my google sheet url is

https://docs.google.com/spreadsheets/d/14cGOXrXHqNwnSHEEqpyv6Rq13TSeKhDZggqI80OL4pQ/edit#gid=2010200390

Thanks

[xml_looser]

yes that's correctly define ns1
and then use
with // ns1: Export
38 entries found

I have the tool stylus used
and an XPath query started
and without namespace gets no result

to test create a local file on the hard disk
and the namespace xmlns = "http://www.theIMO.com/schema" remove
then test without namespace // Export

based on Example

// ns1: IMODocBody / ns1: IntertieZone [2] / ns1: schedules / ns1: Schedule / ns1: Export

0 results