Home REST query via QueryTables renders incomplete result
Reply: 0

REST query via QueryTables renders incomplete result

user1477
1#
user1477 Published in May 26, 2018, 3:47 pm

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

You need to login account before you can post.

About| Privacy statement| Terms of Service| Advertising| Contact us| Help| Sitemap|
Processed in 0.332998 second(s) , Gzip On .

© 2016 Powered by mzan.com design MATCHINFO