Hey Greg,
I tried writing the code per your suggestion however it is returning only first row, here is the code, can you please help ?
XDocument.GetDOM("Tran Type Generated").setProperty("SelectionNamespaces", 'xmlns:dfs="http://schemas.microsoft.com/office/infopath/2003/dataFormSolution" ...