senser_data: Retrieves a dataframe containing data from a Qlik Sense...
In ralfbecher/senser: R Package to retrieve data from Qlik Sense

Description Usage Arguments Details Value Examples

View source: R/senser_data.R

This function makes a REST POST call to q-risotto (the Qlik Sense REST API wrapper service) to retrieve data out of a Qlik Sense application. You will find more details about q-risotto here: https://github.com/ralfbecher/q-risotto

1	senser_data(host, port, app, hyperCubeDef, fields)

`host`	a URL where the q-risotto service runs, usually the Qlik Sense Desktop (localhost) or Server IP address
`port`	a port number where to connect q-risotto,
`app`	a Qlik Sense application name to connect, usually a GUID for applications on a Qlik Sense Server
`hyperCubeDef`	a list of dimensions (field names) and measure expressions (starting with '='), see q-risotto README for more details
`fields`	a list of field names which will be assigned to the resulting vectors

In the parameters, you define the Qlik Sense HyperCube by giving a set of dimensions and measure expressions (Qlik syntax). The HyperCube will then be created in the specified Qlik Sense application and the resulting data are retrieved completely by paging calls.

a dataframe containing the resulting HyperCube data

## Not run: 
host <- "http://localhost"
port <- 3000
app <- "Helpdesk Management.qvf"
hyperCubeDef <- c("Date.autoCalendar.Date", "=Count( {$<[Case Is Closed] ={'True'} >} Distinct %CaseId )", "=Count( {$<[Status]={'New'} >} Distinct %CaseId )")
fields <- c("Date", "Closed Cases", "New Cases")
senser_data(host=host,port=port,app=app,hyperCubeDef=hyperCubeDef,fields=fields)
## End(Not run)