Using XPATH for "XML Data Manager"
Hi,
I'm using XML Data Manager to create a table from one of my REST Services.
Everything seems to work ok but I have some doubts of which XPATH commands Insight supports.
The XMLRetrieved by the service looks something like:
<values>
<name>Object01</name>
<referenceAttribute>
<name>Instance011</name>
<dataInstance>
<property>
<name>id</name>
<value>1234</value>
</property>
<property>
<name>Name</name>
<value>ABCDE</value>
</property>
</dataInstance>
</referenceAttribute>
</values>
In my XML DataMapping I want to extract one row with two columns: ID (containing 1234) and Name (containing ABCDE).
Now, if I use
/property/value I get (as expected) two rows
while, If I use something like
/property/value
or
/property/value
I get (in Framework Manager) 0 Rows.
What am I missing here? What type of Xpath syntax should I use (or which type of syntax Insight does support today)?
Thanks for the answer
Pietro
Thanks for the answer.
I'm using XML Data Manager to create a table from one of my REST Services.
Everything seems to work ok but I have some doubts of which XPATH commands Insight supports.
The XMLRetrieved by the service looks something like:
<values>
<name>Object01</name>
<referenceAttribute>
<name>Instance011</name>
<dataInstance>
<property>
<name>id</name>
<value>1234</value>
</property>
<property>
<name>Name</name>
<value>ABCDE</value>
</property>
</dataInstance>
</referenceAttribute>
</values>
In my XML DataMapping I want to extract one row with two columns: ID (containing 1234) and Name (containing ABCDE).
Now, if I use
/property/value I get (as expected) two rows
while, If I use something like
/property/value
or
/property/value
I get (in Framework Manager) 0 Rows.
What am I missing here? What type of Xpath syntax should I use (or which type of syntax Insight does support today)?
Thanks for the answer
Pietro
Thanks for the answer.