sp_filter: Apply filter operations on a SharePoint list

In LukasK13/sharepointr: Connect to a SharePoint list

Apply filter operations on a SharePoint list

Description

This method allows to apply filter operations on a SharePoint list connection. The syntax is inspired by dplyr

Usage

sp_filter(table, ..., .filter = NULL)

Arguments

table	A SharePoint list connection as returned by sp_list()
...	Comma separated filter commands white spaces in filters can be escaped using “. For quoting, !! is used.

Value

Modfied SharePoint list connection

Examples

sp_con = sp_connection("https://yourdomain.sharepoint.com", "YourUsername", "YourPassword", Office365 = T)
sp_list = sp_list(sp_con, "yourList") %>% sp_filter(Title == "yourTitle")
sp_con = sp_connection("https://yourdomain.sharepoint.com", "YourUsername", "YourPassword", Office365 = T)
sp_list = sp_list(sp_con, "yourList") %>% sp_filter(`Your column` == "yourTitle")
sp_con = sp_connection("https://yourdomain.sharepoint.com", "YourUsername", "YourPassword", Office365 = T)
sp_list = sp_list(sp_con, "yourList") %>% sp_filter(Title == !!yourVariable)

LukasK13/sharepointr documentation built on Jan. 9, 2023, 12:22 p.m.