Data Destinations
whonet-file
Creates an Epicollect5 form from a WHONET lab configuration file.
whonet-epicollect-form
Creates an Epicollect5 form from a WHONET lab data.
upload-to-microreact
Creates Microreact projects.
update-google-spreadsheet
Saves data to a Google Spreadsheet. The Spreadsheet should be shared to with `service-account@data-flo.iam.gserviceaccount.com` and given `can edit` permission.
Data Sources
google-spreadsheet
Loads data from a Google Spreadsheet. Private sheets should be shared to with `service-account@data-flo.iam.gserviceaccount.com`.
whonet-lab-file
Loads data from a WHONET lab configuration file.
sql-server-database
Connect to and query a SQL Server database and convert the result to a datatable; SELECT statements only.
mysql-database
Connect to and query a MySQL database and convert the result to a datatable; SELECT statements only.
microreact-project
Extracts data from a Microreact project.
ariba-file
Imports a card summary file produced by ARIBA (https://github.com/sanger-pathogens/ariba).
google-drive-file
Imports a Google sheet and convert it to a datatable.
dbf-file
Reads data from a dBASE (`.dbf`) file.
ftp-file
Use the File Transfer Protocol to import a file.
dropbox-file
Imports a file from Dropbox.
epicollect-project
Extracts data from an Epicollect5 project.
figshare-file
Imports a file from Figshare.
Data Tables
datatable-columns
Converts a datatable to a list of said datatables columns.
extend-datatable
Add a column to a datatable.
fill-series
Fills empty values of a datatable column with series of values.
change-column-case
Converts the case of text values of a datatable column.
filter-rows
Finds rows in a datatable that match a search string or regular expression.
columns-concatenation
Concatenate a columns values into a new column.
csv-file-to-datatable
Imports a CSV file and converts to a datatable.
format-date-column
Splits date values into new columns.
forward-geocoding
Forward geocode a place into latitude & longitude.
csv-to-datatable
Converts a CSV string to a datatable.
spreadsheet-file
Imports a spreadsheet file and converts to a datatable. Supported file formats: `.xlsx`, `.xlsm`, `.xlsb`, `.xls`, `.xls`, `.xls`, `.xls`, `.ods`, `.fods`, `.csv`, `.txt`, `.sylk`, `.html`, `.dif`, `.dbf`, `.rtf`, `.prn`, and `.eth`.
split-date-column
Splits date values into new columns.
reverse-geocoding
Forward geocode a place into latitude & longitude.
join-datatables
Joins rows of two datatables that have the same value for a specified column.
replace-column-values
Replaces values in source column with some or all matches of a pattern replaced by a replacement. The pattern can be a test or a regular expression. If pattern is a text, only the first occurrence will be replaced. Replacement values are added to target column.
rename-columns
Renames an existing column in a datatable.
rename-column
Renames an existing column in a datatable.
merge-rows
Add a column to a datatable.
datatable-to-csv
Converts a datatable to a CSV string.
Graph Manipulation
datatable-to-graph
Converts a datatable to a graph.
graph-to-dot
Converts a graph to a DOT string.
dot-to-graph
Parses a DOT string as a graph.
force-directed-layout
Applies forces to a graph to produce a layout based on node and edge relationships.
List Manipulation
append-to-list
Adds one element to the end of a list.
slice-list
Returns a portion of a list into a new list selected from begin to end.
sort-list
Sorts elements in a list.
merge-lists
Merges two lists into one.
prepend-to-list
Adds one element to the beginning of a list.
datatable-to-list
Creates a list from values of a datatable column.
list-to-datatable
Converts a list to a datatable.
list-element
Returns an element of list at a specified index.
find-value
Finds a value in a list that match a search string or regular expression.
filter-list
Finds values in a list that match a search string or regular expression.
Text Manipulation
file-to-text
Converts a file to text.
concatenate-text
Concatenates text to the left and/or the right of the input, then returns the combined text as an output.
url-builder
Takes a protocol, a host and a URI, combining them to create a URL.
search-text
Searches for a pattern in a text using a regular expression.
text-to-file
Converts text a text to a file stream.
split-text
Splits a text into a list of texts using a specified separator text to determine where to make each split.