The goal of openappr
is to import app data from OpenAppBuilder.
You can install the development version of openappr from GitHub with:
# install.packages("devtools")
devtools::install_github("IDEMSInternational/openappr")
The use of openappr
begins by establishing a connection to
‘OpenAppBuilder’. This can be achieved using the get_app_connection()
function, which is simply a wrapper to the dbconnect
function from the
DBI
package. By using the get_app_connection()
function, the
connection is stored in the package environment, ensuring that
subsequent calls to retrieve the app data uses this connection.
The primary functionality of openappr
revolves around two main types
of data retrieval:
-
Notification Data: Users can retrieve notification-related data using the function
get_nf_data()
. This function is optimised for quick access to notifications generated by the system, structured to provide immediate insights into user engagement and system performance. -
User Data: The function
get_user_data()
is designed to access detailed information about users. This is particularly useful for analysis that requires a deep dive into user behaviour and demographics.
Both functions utilise the underlying capabilities of the RPostgres
package but are tailored to provide a more user-friendly interface that
requires minimal SQL knowledge.
This is a basic example which shows you how can import notification and user data from open-app builder into R:
# Before retrieving data, you must establish a connection to your OpenAppBuilder (PostgreSQL) database using the `set_app_connection()` function:
openappr::set_app_connection(
dbname = "vmc",
host = "apps-server.idems.international",
port = 5432,
user = "vmc",
password = "LSQkyYg5KzL747"
)
# Once the connection is established, you can retrieve it at any time using the get_app_connection() function:
con <- get_app_connection()
# For specific user data, use the `get_user_data()` function:
valid_ids <- c("3e68fcda-d4cd-400e-8b12-6ddfabced348", "223925c7-443a-411c-aa2a-a394f991dd52")
data_filtered_notifications <- get_openapp_data(
name = "app_users",
filter = TRUE,
filter_variable = "app_user_id",
filter_variable_value = valid_ids
)
# Similarly, the `get_nf_data()` function allows you to retrieve and process notification interaction data:
filtered_notification_data <- get_nf_data(
filter = TRUE,
filter_variable = "Country",
filter_variable_value = "USA"
)
The openappr
package provides a convenient way to connect to
OpenAppBuilder and retrieve data, customise your queries, and filter to
suit your data needs.