Home REST query via QueryTables renders incomplete result
 I implemented in Visual Basic for Excel 2010 a retrieval of data from a MySQL database via REST using QueryTables as follows: Sub RESTRequest() With ActiveSheet.QueryTables.Add(Connection:= _ "URL;https://xxxx.xxxx.xxxx.xx/rest/projects/all", _ Destination:=Range("A10")) .BackgroundQuery = False .TablesOnlyFromHTML = True .Refresh BackgroundQuery:=False .SaveData = True End With End Sub  The database log file shows that 132 datasets are send out with items ordered numerically from 0 to 131. The Excel worksheet shows the following exemplary output: /xml /item0/@f_1 /item0/@f_2 /item0/@f_3 ... and so on R4010MP014 n. z. 4016  However, it contains only 101 datasets alphabetically reordered. The remaining datasets 69 to 99 are missing. I thoroughly searched for the reason for the missing data, how to solve the problem, tried different ideas, but could neither find any report on such a problem nor come up with a solution. One possibility I found is that the problem might lie with Excel's XML flattener adding #agg columns (?). However, another REST query with the same code to the same database, fewer but larger datasets (so more columns are filled) works properly. I would greatly appreciate if you could provide me with any clues what the problem might be, how I could check or solve it. With kind regards Lars