Running one off queries using the cRest class get it now
Now that we have a generalized mechanism to easily populate Excel tables from Rest queries in Rest to Excel library, let's take a look at making one off rest calls.
Try it out first ?
These are enhancements to Data Manipulation Classes so they have been included in cDataSet.xlsm, which is downloadable from Download Complete Projects.
I think it is better to add all calls to the rest library- for one thing it is a simple way to record the research you would have down for how a query works. However you may not want to mess with the supplied procedures, or you may want to create a form to use the cRest class so that non VBA programmers can use it, but allow them to enter adhoc queries too.
The library allows you to provide a URL and a response format argument rather than relying on them to be supplied inside the library.
- sRestURL - the URL of the one off query
- sResponseResults - the description of where to find the reponse data
- bTreeSearch - as described in Adding to the rest library this will modify the behavior when searching for a column match between the worksheet column names and the response.
Here are the arguments for each of the functions in restLibrary
This means we can call it with appropriate arguments, in this example to do a patent search on the term "excel"
Public Sub testOneOff()
Dim cr As cRest
Set cr = restQuery("patent", , "excel", , _
WIth patents as a preset in the library, This would be equivalent to
Public Sub testLibrary()
Dim cr As cRest
Set cr = restQuery("patent","google patents" , "excel")