openbankeR

An R package for querying the UK Open Banking (Open Data) API

Features

• Create an R client for the OpenBanking (OpenData) API

• Extract raw data from the API using convenient functions

Installation

From CRAN:

install.packages("openbankeR")

From GitHub:

library(devtools)
install_github("nik01010/openbankeR")

Functions / Queries

R package functions:

Function	Description	Input	Output
CreateOpenBankingClient	Creates a client for calling the API	Optional user-defined settings	OpenBankingClient object with queries

Once the client has been set-up, the following queries can be used:

Query	Description	Input	Output
GetAvailableBanks	Get a list of banks that report the API	n/a	List of available banks
GetAvailableInstruments	Get a list of instruments reported via the API	n/a	List of available instruments
GetRawData	Get raw data using the API for a given bank and instrument	Bank name and instrument	Requested raw data

Create an API client

Create a new client for querying the API

library(openbankeR)

openBankingClient <- openbankeR::CreateOpenBankingClient()

Bank Details

bankDetails <- openBankingClient$BankDetails

View(bankDetails)

Available banks

Get a list of banks that report the API

availableBanks <- openBankingClient$GetAvailableBanks()

availableBanks

# [1] "Adam & Company"              "Allied Irish Bank (GB)"    "Bank of Ireland (UK)"      "Bank of Scotland"           
# [5] "Barclays Bank"               "Coutts"                    "Danske Bank"               "Esme"                       
# [9] "First Trust Bank"            "Halifax"                   "HSBC Group"                "Lloyds Bank"                
# [13] "Nationwide Building Society" "NatWest"                  "Royal Bank of Scotland"    "Santander UK"               
# [17] "Ulster Bank"                 "Clydesdale Bank PLC"      "Yorkshire Bank"            "VM"

Available instruments

Get a list of instruments reported via the API

availableInstruments <- openBankingClient$GetAvailableInstruments()

availableInstruments

# [1] "business-current-accounts" "personal-current-accounts" "unsecured-sme-loans"  "atms"  "branches"                 
# [6] "commercial-credit-cards"

Extract raw data

Get raw data using the API for a given bank and instrument

bankName <- "HSBC Group"
instrument <- "branches"

rawData <- openBankingClient$GetRawData(
  bankName = bankName,
  instrument = instrument
)

View(rawData)

Additional help

Use the below commands to find additional documentation about the package

??openbankeR

??openbankeR::CreateOpenBankingClient

Note

Raw data provided by the API can be a nested structure and may need to be unnested for some types of analysis.