R-api client

Search…
R-api client
The MOLGENIS R API client allows you to retrieve, create, update and delete entities from within the R environment.
Just add
1
source("http://molgenis.mydomain.example/molgenis.R")
Copied!
at the top of your script and you can connect to a MOLGENIS server. Typically the first thing you do is login and the last thing is logout.
NOTE: For https connections use
1
eval(expr = parse(text = getURL("https://molgenis.mydomain.example/molgenis.R?molgenis-token=${molgenisToken}")))
Copied!
NOTE: The MOLGENIS R-api client supports up to R-version 3.2.x
Overview example
1
source("http://molgenis.mydomain.example/molgenis.R")
2
​
3
​
4
molgenis.login("admin", "admin")
5
​
6
df <- molgenis.get("celiacsprue",
7
                   q = "celiac_weight>80 and celiac_height>180",
8
                   num = 1000,
9
                   attributes = c("celiac_weight", "celiac_height", "celiac_gender"))
10
​
11
plot(df$Celiac_Height ~ df$Celiac_Weight, col=df$Celiac_Gender)
12
​
13
molgenis.logout()
Copied!
login
1
molgenis.login(username,password)
Copied!
Login to the MOLGENIS REST API
logout
1
molgenis.logout()
Copied!
Logout from the MOLGENIS REST API and destroy the session.
get
1
molgenis.get (entity, q = NULL, start = 0, num = 1000, attributes = NULL)
Copied!
Retrieves entities and returns the result in a dataframe.
Parameter
Description
Required
Default
entity
The entity name
yes
​
q
Query string in rsql/fiql format (see below)
No
NULL
start
The index of the thirst row to return
No
0
num
The maximum number of rows to return (max 10000)
No
1000
attributes
Vector of attributenames(columns) to return
No
All attributes
sortColumn
attributeName of the column to sort on
No
NULL
sortOrder
sort order, 'ASC' of 'DESC'
No
NULL
Supported RSQL/FIQL query operators (see https://github.com/jirutka/rsql-parser)
Operator
Symbol
Logical AND
; or and
Logical OR
, or or
Group
( and )
Equal to
==
Less then
=lt= or <
Less then or equal to
=le= or <=
Greater than
=gt= or >
Greater tha or equal to
=ge= or >=
Argument can be a single value, or multiple values in parenthesis separated by comma. Value that doesn’t contain any reserved character or a white space can be unquoted, other arguments must be enclosed in single or double quotes.
Examples
1
molgenis.get("celiacsprue")
2
molgenis.get("celiacsprue", num = 100000, start = 1000)
3
molgenis.get("celiacsprue", attributes = c("Individual", "celiac_gender"))
4
molgenis.get("celiacsprue", q = "(celiac_weight>=80 and celiac_height<180) or (celiac_gender==Female)")
5
molgenis.get("celiacsprue", q = "(celiac_weight>=80;celiac_height<180),(celiac_gender==Female)")
Copied!
add
1
molgenis.add(entity, ...)
Copied!
Creates a new instance of an entity (i.e. a new row of the entity data table) and returns the id.
Parameter
Description
Required
entity
The entity name of the entity to create
yes
...
Var arg list of attribute names and values
yes
Example
1
id <- molgenis.add(entity = "Person", firstName = "Piet", lastName = "Paulusma")
Copied!
addAll
1
molgenis.addAll(entity, rows)
Copied!
Creates new instances of an entity (i.e. adds new rows to the entity data table) and returns the ids.
Parameter
Description
Required
entity
The entity name of the entity to create
yes
rows
data frame where each row represents an entity instance
yes
Example
1
firstName <- c("Piet", "Paulusma")
2
lastName <- c("Klaas", "de Vries")
3
df <- data.frame(firstName, lastName)
4
​
5
molgenis.addAll("Person", df)
Copied!
update
1
molgenis.update(entity, id, ...)
Copied!
Updates un existing entity
Parameter
Description
Required
entity
The entity name
yes
id
The id of the entity
Yes
...
Var arg list of attribute names and values
yes
Example
1
molgenis.update(entity = "Person", id = 8, firstName = "Pietje", lastName = "Paulusma")
Copied!
delete
1
molgenis.delete(entity, id)
Copied!
Deletes an entity.
Parameter
Description
Required
entity
The entity name
yes
id
The id of the entity
Yes
Example
1
molgenis.delete(entity = "Person", id = 8)
Copied!
deleteList
1
molgenis.deleteList(entity, c("id1", "id2"))
Copied!
Deletes a list of entities in an entityType.
Parameter
Description
Required
entity
The entityType name
yes
rows
List with ids of the rows
yes
Example
1
molgenis.deleteList(entity = "Person", rows = c("1", "2", "3"))
Copied!
getEntityMetaData
1
molgenis.getEntityMetaData(entity)
Copied!
Gets the entity metadata as list.
Example
1
meta <- molgenis.getEntityMetaData("celiacsprue")
2
meta$label
Copied!
getAttributeMetaData
1
molgenis.getAttributeMetaData(entity, attribute)
Copied!
Gets attribute metadata as list.
Parameter
Description
Required
entity
The entity name
yes
attribute
The name of the attribute
Yes
Example
1
attr <- molgenis.getAttributeMetaData(entity = "celiacsprue", attribute = "celiac_gender")
2
attr$fieldType
Copied!
Python-api client
Beacon api
Last modified 1yr ago
Copy link
Contents