Querying on 'OData'

Make querying on 'OData' easier. It exposes an 'ODataQuery' object that can be manipulated and provides features such as selection, filtering and ordering.

ODataQuery

Query on R OData

This package aims to make OData services more accessible to R users.

Installation

install.packages("devtools")
devtools::install_github("https://github.com/lverweijen/ODataQuery")

Example usage

# Initialisation
url <- "https://services.odata.org/V4/TripPinServiceRW"
trip_service <- ODataQuery$new(url)
people_entity <- trip_service$path("People")

# Find all people whose name starts with an R
people_entity$
  select("UserName", "FirstName", "LastName")$
  filter(to_odata(startsWith(FirstName, "R")))$
  all()

# Find a person named Scott
people_entity$
  filter(to_odata(FirstName == "Scott"))$
  one()

# Find Scott's friends
people_entity$
  get("scottketchum")$
  path("Friends")$
  all()

See vignettes demo and querying for more examples.

Other R packages dealing with OData

• OData - very basic
• cbsodataR - for data from Statistics, the Netherlands in particular
• odataR