KO | EN

GitLite

Minimalist Open Source Repository Search Engine

gitlite — search

#dsh #dsh-plugin #developer-tools #ai-agent #codex #typescript #cli #deepseek-harness #claude-code #ai-agents #mcp #rust

sharepointr

★ 39 Open GitHub ↗

A R package for reading from and writing to SharePoint lists.

// repository documentation

Was this content helpful?

★ 0 (0 ratings)

# Help Wanted
Unfortunately I have no more access to a SharePoint license and am therefore unable to implement new features or fix bugs. I am thankful for pull requests of any kind.

# sharepointr
A R package for reading from and writing to SharePoint lists.

## Installation
`devtools::install_github("lukask13/sharepointr")`

## Connect to a SharePoint server
Connect to a local SharePoint server:

`sp_con = sp_connection("https://your.sharepoint.server/subpage1/", "YourUsername", "YourPassword", Office365 = F)`

Connect to a Office365 SharePoint server:

`sp_con = sp_connection("https://yourdomain.sharepoint.com", "YourUsername", "YourPassword", Office365 = T)`

## Read from Sharepoint
### List all available lists
The results can be returned either as raw list or as character vector.
```
sp_con = sp_connection("https://your.sharepoint.server/subpage1/", "YourUsername", "YourPassword", Office365 = F)
lists = sp_getLists(sp_con)
```

### Get list metainfo
A list can be either adressed by name or by the list ID. The result can be obtained as raw list or as parsed list.
```
sp_con = sp_connection("https://your.sharepoint.server/subpage1/", "YourUsername", "YourPassword", Office365 = F)
lists = sp_getListMetadata(sp_con, "yourList")
```

### Get list columns
A list can be either adressed by name or by the list ID. It is possible to obtain only names of visible columns.
```
sp_con = sp_connection("https://your.sharepoint.server/subpage1/", "YourUsername", "YourPassword", Office365 = F)
columns = sp_getListColumns(sp_con, "yourList")
```

### Read data from list
A list can be either adressed by name or by the list ID. It is possible to allow expanding of deferred tags.
```
sp_con = sp_connection("https://your.sharepoint.server/subpage1/", "YourUsername", "YourPassword", Office365 = F)
data = sp_readListData(sp_con, "yourList")
```

### Pipeline tools for reading
The pipeline toos for reading from a SharePoint list are inspired by the amazing work of Hadley Wickham and his package dplyr.
Therefore, the syntax is similar to the syntax of dplyr.
```
sp_con = sp_connection("https://your.sharepoint.server/subpage1/", "YourUsername", "YourPassword", Office365 = F)
sp_list = sp_list(sp_con, "yourList") %>% sp_filter(yourColumn1 == "yourValue") %>% sp_select(yourColumn2) %>% sp_arrange(yourColumn2) %>% sp_collect()
```

### Read user information
Obtaining and filtering user information is possible by:
```
sp_con = sp_connection("https://yourdomain.sharepoint.com", "YourUsername", "YourPassword", Office365 = T)
user = sp_users(sp_con, LoginName = "Username1")
```

## Write to a SharePoint list
New data can be written to a SharePoint list by:
```
sp_con = sp_connection("https://yourdomain.sharepoint.com", "YourUsername", "YourPassword", Office365 = T)
sp_writeListData(sp_con, "yourList", list(column1 = "content1", column2 = 2, column3 = 1.23, user = "Username"))

sharepointr

Explore Similar Repositories

Was this content helpful?

Recent Feedback

Download README