| Active with remarks |
|---|
| This application needs additional settings. Please follow the documentation below to create your own connectionUnique, active service acces point to a network. There are different types of connections (API key, Oauth…). More. |
With the Keboola modulesThe module is an application or tool within the Boost.space system. The entire system is built on this concept of modularity. (module - Contacts) More in Boost.spaceCentralization and synchronization platform, where you can organize and manage your data. More IntegratorPart of the Boost.space system, where you can create your connections and automate your processes. More you can:
-
Upload data into a table, preview data, export a table, and retrieve file URL’s from a run.
-
Run and retrieve a queue job, unload data asynchronously, and start an orchestration.
-
Call APIs
To get started with Keboola, create an account at keboola.com
![[Note]](https://docs.boost.space/wp-content/themes/bsdocs/docs-parser/HTML/css/image/note.png) |
Note |
|---|---|
|
The moduleThe module is an application or tool within the Boost.space system. The entire system is built on this concept of modularity. (module - Contacts) More dialog fields that are displayed in bold (in the Boost.space Integrator scenarioA specific connection between applications in which data can be transferred. Two types of scenarios: active/inactive. More, not in this documentation article) are mandatory! |
-
Log in to your Keboola account.
-
Click Profile picture on the top right and click Settings.
-
In the Settings tab, click API TokensThe API token is a multi-digit code that allows a user to authenticate with cloud applications. More.
-
In the API TokenThe API token is a multi-digit code that allows a user to authenticate with cloud applications. More tab, click NEW TOKENThe API token is a multi-digit code that allows a user to authenticate with cloud applications. More, enter a description for the token, and click CREATE.
Note Ensure your token has the correct scopes assigned. Boost.space Integrator recommends to generate a Full Access token but consider the possible risks resulting from the ability to call any endpoint in the Keboola with this token.
-
Copy the API Token to your clipboard.
-
Log in to your Boost.space Integrator and add a module from the Keboola app into a Boost.space Integrator scenario.
-
Click Add next to the Connection field.
-
In the Connection name field, enter a name for the connection.
-
In the API Token field, enter the token copied in step 5.
-
In the Stack field, enter your Keboola dashboard URL and click Save. For example, If your Keboola dashboard URL is
https://connection.north-europe.azure.keboola.com/admin/projects/5505/dashboard, then your stack isnorth-europe.azure.Note If your Keboola dashboard URL is
https://connection.keboola.com/admin/projects/5505/dashboardthen leave the Stack field blank.
You can upload and preview the data, export the table, and retrieve the file details using the following modules.
Uploads data into a table.
|
Connection |
||||
|
Upload Mode |
Select or map the mode through which you want to upload the data:
|
|||
|
Table ID |
Select or map the Table ID to which you want to upload the data. |
|||
|
File |
Add the file whose data you want to upload: |
|||
|
Delimiter |
Enter (map) the delimiter value to apply to the sequence. The field is used in a CSV file. The default value is a comma. |
|||
|
Enclosure |
Enter (map) field enclosure used in a CSV file. The default value is “. |
|||
|
Escaped by |
Enter (map) a CSV escape character. For example, |
Previews data in an existing table.
|
Connection |
|
|
Table ID |
Select or map the Table ID whose data you want to preview. |
|
Limit |
Set the maximum number of results Boost.space Integrator should return during one scenario execution cycleA cycle is the operation and commit/rollback phases of scenario execution. A scenario may have one or more cycles (one is the default).. |
|
Changed Since |
Enter (map) the date to filter the data that was modified on or after the specified date. See the list of supported date and time formats. |
|
Changed Until |
Enter (map) the date to filter the data modified on or before the specified date. See the list of supported date and time formats. |
|
Columns |
Enter (map) the columns separated by a comma to export. By default, all columns are exported. |
|
Where Operator |
Select or map the operator:
|
|
Format |
Select or map the data format type:
|
|
Where Filters |
Select or map the details to filter the data for preview. You can add multiple filters. For filter examples, refer to the Keboola’s documentation. |
|
Order by |
Select or map the options to sort the data for preview. You can add multiple options. |
|
Full Text Search |
Enter (map) the data to make a full-text search of all data in the table. You cannot combine this option with whereFilters. Allowed only Snowflake/Synapse. |
Exports an existing table.
|
Connection |
||||
|
Source Table |
Enter (map) the table name whose data you want to export. For example,
|
|||
|
Name of the Exported File |
Enter (map) the exported file name including the extension, .csv. |
You can run a queue job, retrieve the job details, start an orchestration, and unload the data asynchronously using the following details.
Runs a new queue job.
|
Connection |
||||
|
Component |
Enter (map) a component name to run a queue job. |
|||
|
Mode |
Select or map the mode:
|
|||
|
Config |
Enter (map) the configuration name.
|
|||
|
Config Row IDs |
Enter (map) the configuration row IDs. |
|||
|
Config Data |
Enter the configuration details. |
|||
|
Tag |
Enter (map) a tag, if you want to run the component with a specific version of code. |
|||
|
Branch ID |
Enter (map) a branch ID to run a job of a configuration in a branch. |
|||
|
Variable Values ID |
Enter (map) the ID of the variable value to run a job with inline values. |
|||
|
Variable Values Data |
Add the variable values data: |
Retrieves an existing queue job.
Retrieves an existing job.
Unloads data asynchronously.
|
Connection |
|
|
Table ID |
Select or map the Table ID whose data you want to unload asynchronously. |
|
Limit |
Set the maximum number of rows Boost.space Integrator will return during one execution cycle. |
|
Format |
Select or map the data format to unload:
|
|
Changed Since |
Enter (map) the date to filter the data that was modified on or from the specified date. See the list of supported date and time formats. |
|
Changed Until |
Enter (map) the date to filter the data that was modified on or before the specified date. See the list of supported date and time formats. |
|
Columns |
Enter (map) the columns separated by a comma whose data you want to unload. By default, all columns are exported. |
|
Where Operator |
Select or map the operator to filter the data that matches the specified columns: |
|
GZIP |
Select whether to ZIP the response. |
|
Where Filters |
Add the filter to sort the data that matches the specified value for unloading: |
|
Order by |
Select or map the option to sort the data |
You call APIs using the following module.
Performs an arbitrary authorized API call.
|
Connection |
||||
|
URL |
Enter a path relative to
|
|||
|
Method |
Select the HTTP method you want to use: GET to retrieve information for an entry. POST to create a new entry. PUT to update/replace an existing entry. PATCH to make a partial entry update. DELETE to delete an entry. |
|||
|
Headers |
Enter the desired request headers. You don’t have to add authorization headers; we already did that for you. |
|||
|
Query String |
Enter the request query string. |
|||
|
Body |
Enter the body content for your API call. |
The following API call returns all the tables from your Keboola account:
URL:
/v2/storage/tables
Method:
GET
Matches of the search can be found in the module’s Output under BundleA bundle is a chunk of data and the basic unit for use with modules. A bundle consists of items, similar to how a bag may contain separate, individual items. More > Body.
In our example, 3 tables were returned.
