X-Path Query won't work in Google-Sheets

Question

I've been trying to use the following X-Path within Google-Sheets with the =ImportXML function

=importXml("http://www.managetickets.com/morecApp/ticketSearchAndStatusTicketList.jsp?msgCount=23&outputEmail=&db=nd", "/table[2]/tbody/tr@[td]")

But no matter what minor adjustments I try I continually get "#N/A" with a hover-text box that says "imported content is empty".

I know it's a valid x-path, I've cross verified it with 'X-Path Helper Wizard' chrome-extension.

Any ideas what I'm doing wrong!?

Answer 1

No, actually it's not a valid XPath. Note that @ used to select an attributes e.g. @class, @id, etc. Also it's a bad idea to use tbody tag in your expressions as this tag is not always present in initial source code

So if you want to match table rows which contain cells from second table, you can use

/table[2]//tr[td]