Description Usage Arguments Details See Also Examples
Execute a find query which has been saved and published in JSON Studio Finder, and get the result in a data frame.
1 2 |
connection |
a SonarConnection object created with
|
queryName |
the name of the saved query to execute |
queryCol |
a collection in the database to use with the query |
bind |
a list of bind variables and their values |
limit |
the maximum number of results to return |
idCol |
the name of a field which uniquely identifies each document.
This will be used for the row names in the returned data frame. The
default is X_id, which is the name of Mongo's _id field (adjusted by
|
publishedBy |
the name of the user who we expect published the API |
colClasses |
a list of column names and their respective classes, as
used in |
The parameters for this function are explained in greater detail in the JSON Studio help page Using the Gateway.
http://jsonstudio.com/wp-content/uploads/2014/04/manual141/_build/html/index.html
Other connection: new.SonarConnection
;
sonarAgg
; sonarCSV
;
sonarJSON
1 2 3 4 5 6 7 8 9 | connection <- new.SonarConnection('https://example.com', 'localhost', 'test')
delays <- sonarFind(connection, 'delayed_flights', 'WAFlights')
cor(delays$ACTUAL_ELAPSED_TIME, delays$WEATHER_DELAY)
tx_to_co <- sonarFind(connection, 'flights_to', 'TXFlights',
bind=list(state="CO"),
colClasses=c(DAY_OF_MONTH='factor', DEST_AIRPORT_ID='factor'))
hist(tx_to_co$ACTUAL_ELAPSED_TIME)
|
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.