sonarAgg: Run a saved aggregation pipeline

Description

Execute an aggregation pipeline which has been saved and published in JSON Studio Analytics, and get the result in a data frame.

Usage

sonarAgg(connection, queryName, queryCol, bind = list(), limit = NULL,
  idCol = "_id", publishedBy = NULL, colClasses = NA)

Arguments

connection

a SonarConnection object created with new.SonarConnection

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 make.names

publishedBy

the name of the user which published the API

colClasses

a list of column names and their respective classes, as
  used in read.csv. This may be necessary if some columns'
  types are not being detected automatically.

`Details`

The parameters for this function are explained in greater detail in the
JSON Studio help page Using the Gateway.

`See Also`

http://jsonstudio.com/wp-content/uploads/2014/04/manual141/_build/html/index.html

`Examples`

Run this codeconnection <- new.SonarConnection('https://example.com', 'localhost', 'test')

ny_by_day <- sonarAgg(connection, 'delays_by_day', 'NYCFlights')
cor(ny_by_day$X_avg_ArrDelay, ny_by_day$X_avg_AirTime)
Run the code above in your browser using DataLab