Data sources¶
Add Database¶
Description¶
Add Database Icon connects a database to Forloop. Either a new database can be entered via the New Database button or an already existing database can be selected from a combobox.
Add SQL Server DB¶
Description¶
Add SQL Server DB Icon connects a SQL Server database to Forloop. Either a new database can be entered via the New Database button or an already existing database can be selected from a combobox.
Add MySQL DB¶
Description¶
Add Database Icon connects a MySQL database to Forloop. Either a new database can be entered via the New Database button or an already existing database can be selected from a combobox.
Add Mongo DB¶
Description¶
Add Database Icon connects a Mongo database to Forloop. Either a new database can be entered via the New Database button or an already existing database can be selected from a combobox.
Add Snowflake Warehouse¶
Description¶
Add Database Icon connects a Snowflake warehouse to Forloop. Either a new database can be entered via the New Database button or an already existing database can be selected from a combobox.
Load Excel/CSV¶
Description¶
Load Excel/CSV Node serves to loading a .xlsx or .csv file for further cleaning and analysis.
Hint
For a detailed walkthrough see the step-by-step guide.
Parameters¶
Load Excel/CSV Node requires 1 parameter to succesfully load data from .xlsx or .csv file.
Parameter |
Type |
Description |
|---|---|---|
Filename |
string |
A path to the data file must be filled in into the Filename entry either manually or via file explorer by clicking the Look up file button below the entry line. |
Step-by-step guide¶
Save Excel/CSV¶
Get API (REST)¶
Description¶
Get API icon makes a get request from a website defined by its URL and (optionally) the API’s header. The response of the get request in form of a json (dictionary) is saved as a new variable in the variable explorer for further usage.
Parameters¶
Get API node requires at least 2 parameters. The header parameter is optional.
Parameter |
Type |
Description |
|---|---|---|
URL |
string |
A URL of the desired websites API. |
Header (optional) |
string |
A dictionary of HTTP headers to send into the request, e.g. {“content-type”:”text”}. |
Save as |
string |
A name of the new variable containing the response dictionary. |
Post API (REST)¶
Description¶
Post API icon makes a post request to a website defined by its URL. The response of the post request in form of a json (dictionary) is saved as a new variable in the variable explorer for further usage.
Parameters¶
Post API node requires 3 parameters:
Parameter |
Type |
Description |
|---|---|---|
URL |
string |
A URL of the desired websites API. |
Data |
string |
A path to the .txt or .csv file containing the data for post request. |
Save as |
string |
A name of the new variable containing the response dictionary. |
Delete API (REST)¶
Description¶
Delete API icon posts a delete request to a website defined by its URL.
Parameters¶
Post API node requires at least 1 parameter. The header parameter is optional.
Parameter |
Type |
Description |
|---|---|---|
URL |
string |
A URL of the desired websites API. |
Header (optional) |
string |
A dictionary of HTTP headers to send into the request, e.g. {“content-type”:”text”}. |
Put API (REST)¶
Description¶
Put API icon makes a put request to a website defined by its URL.
Parameters¶
Put API node requires 2 parameters:
Parameter |
Type |
Description |
|---|---|---|
URL |
string |
A URL of the desired websites API. |
Data |
string |
A path to the .txt or .csv file containing the data for put request. |
Dataframe to List¶
Description¶
Takes a column from a dataframe and transforms it into a list which is then stored as a new variable in the variable explorer.
Parameters¶
Datafram to List node requires 2 parameters:
Parameter |
Type |
Description |
|---|---|---|
Column name |
string |
A name of the column to be transformed into a list. |
New variable name |
string |
A name of the new variable containing the list (column in the dataframe). |
List to Dataframe¶
|cleaning_icon| Load Txt File¶
|cleaning_icon| Save Txt File¶
|cleaning_icon| Load Json File¶
|cleaning_icon| Save Json File¶
|json_to_df| Normalize Dict to Dataframe¶
|cleaning_icon| Database Select¶
Description¶
Execute database select on various databases. Supports one condition. For more advanced queries use DB Query.
Parameters¶
Parameter |
Type |
Description |
|---|---|---|
From |
Comboentry |
Database table on which the query is executed. |
Select |
Comboentry |
Columns which should be returned by the query. Default to all columns as *. |
Column |
Comboentry |
The column on which the condition is evaluated. |
Operator |
Combobox option |
Condition operator. One of: =, <, <=, >, >=, <>, IN |
Value |
String entry |
A value against which the condition is evaluated. |
Limit |
String entry |
Number of records to return |
New variable |
String entry |
A name for the new Dataframe variable |
|cleaning_icon| Database Insert¶
Description¶
Execute database insert on various databases.
|cleaning_icon| Database Delete¶
Description¶
Execute database delete on various databases. Supports one condition. For more advanced queries use DB Query.
Parameters¶
Parameter |
Type |
Description |
|---|---|---|
From |
Comboentry |
Database table on which the query is executed. |
Column |
Comboentry |
The column on which the condition is evaluated. |
Operator |
Combobox option |
Condition operator. One of: =, <, <=, >, >=, <>, IN |
Value |
String entry |
A value against which the condition is evaluated. |
|cleaning_icon| Database Update¶
Description¶
Execute database update on various databases. Supports one condition. For more advanced queries use DB Query.
Parameters¶
Parameter |
Type |
Description |
|---|---|---|
Table name |
Comboentry |
Database table on which the query is executed. |
Column |
Comboentry |
The column in which the value is updated. |
Value |
String entry |
A value inserted to a given column in rows comforting a given condition |
Column |
Comboentry |
The column on which the condition is evaluated. |
Operator |
Combobox option |
Condition operator. One of: =, <, <=, >, >=, <>, IN |
Value |
String entry |
A value against which the condition is evaluated. |
|cleaning_icon| Database Query¶
Description¶
Execute a given database query on various databases.