This is an automated email from the ASF dual-hosted git repository. acosentino pushed a commit to branch sheets in repository https://gitbox.apache.org/repos/asf/camel-kamelets.git
commit bacad66ec9b8451154841159cb754aaf63cb1dae Author: Andrea Cosentino <anco...@gmail.com> AuthorDate: Thu Mar 11 16:23:33 2021 +0100 Added Google Sheets Stream Source Kamelet --- .../kamelets/google-sheets-stream-source.svg | 1 + docs/modules/ROOT/nav.adoc | 1 + .../ROOT/pages/google-mail-stream-source.adoc | 2 +- .../ROOT/pages/google-sheets-stream-source.adoc | 74 ++++++++++++++++++++++ 4 files changed, 77 insertions(+), 1 deletion(-) diff --git a/docs/modules/ROOT/assets/images/kamelets/google-sheets-stream-source.svg b/docs/modules/ROOT/assets/images/kamelets/google-sheets-stream-source.svg new file mode 100644 index 0000000..28f6a33 --- /dev/null +++ b/docs/modules/ROOT/assets/images/kamelets/google-sheets-stream-source.svg @@ -0,0 +1 @@ +<svg xmlns="http://www.w3.org/2000/svg" viewBox="186 38 76 76"><path fill="#fff" d="M244 56h-40v40h40V56z"/><path fill="#EA4335" d="M244 114l18-18h-18v18z"/><path fill="#FBBC04" d="M262 56h-18v40h18V56z"/><path fill="#34A853" d="M244 96h-40v18h40V96z"/><path fill="#188038" d="M186 96v12c0 3.315 2.685 6 6 6h12V96h-18z"/><path fill="#1967D2" d="M262 56V44c0-3.315-2.685-6-6-6h-12v18h18z"/><path fill="#4285F4" d="M244 38h-52c-3.315 0 -6 2.685-6 6v52h18V56h40V38z"/><path fill="#4285F4" d="M21 [...] \ No newline at end of file diff --git a/docs/modules/ROOT/nav.adoc b/docs/modules/ROOT/nav.adoc index 3f8b085..bec5223 100644 --- a/docs/modules/ROOT/nav.adoc +++ b/docs/modules/ROOT/nav.adoc @@ -7,6 +7,7 @@ * xref:ROOT:ftps-source.adoc[image:kamelets/ftps-source.svg[] FTPS Source] * xref:ROOT:google-calendar-stream-source.adoc[image:kamelets/google-calendar-stream-source.svg[] Google Calendar Stream Source] * xref:ROOT:google-mail-stream-source.adoc[image:kamelets/google-mail-stream-source.svg[] Google Mail Stream Source] +* xref:ROOT:google-sheets-stream-source.adoc[image:kamelets/google-sheets-stream-source.svg[] Google Sheets Stream Source] * xref:ROOT:http-source.adoc[image:kamelets/http-source.svg[] HTTP Source] * xref:ROOT:jira-source.adoc[image:kamelets/jira-source.svg[] Jira Source] * xref:ROOT:kafka-source.adoc[image:kamelets/kafka-source.svg[] Kafka Source] diff --git a/docs/modules/ROOT/pages/google-mail-stream-source.adoc b/docs/modules/ROOT/pages/google-mail-stream-source.adoc index 5d9a372..f214fd3 100644 --- a/docs/modules/ROOT/pages/google-mail-stream-source.adoc +++ b/docs/modules/ROOT/pages/google-mail-stream-source.adoc @@ -18,7 +18,7 @@ The following table summarizes the configuration options available for the `goog | *index {empty}* *| Index| An index for the google mail endpoint| string| | | *refreshToken {empty}* *| Refresh Token| OAuth 2 refresh token for google mail application. Using this, the Google Calendar component can obtain a new accessToken whenever the current one expires - a necessity if the application is long-lived.| string| | | labels| Gmail labels| Comma separated list of labels to take into account| string| | `"inbox"` -| markAsRead| Mark as read| Mark the message as read once it has been consumed| boolean| `false`| +| markAsRead| Mark as read| Mark the message as read once it has been consumed| boolean| `true`| | query| Gmail query| The query to execute on gmail box| string| `"is:unread"`| `"is:unread -category:(promotions OR social)"` |=== diff --git a/docs/modules/ROOT/pages/google-sheets-stream-source.adoc b/docs/modules/ROOT/pages/google-sheets-stream-source.adoc new file mode 100644 index 0000000..337d0c9 --- /dev/null +++ b/docs/modules/ROOT/pages/google-sheets-stream-source.adoc @@ -0,0 +1,74 @@ +// THIS FILE IS AUTOMATICALLY GENERATED: DO NOT EDIT += image:kamelets/google-sheets-stream-source.svg[] Google Sheets Stream Source + +*Provided by: "Apache Software Foundation"* + +Receive data from Google Sheets. + +== Configuration Options + +The following table summarizes the configuration options available for the `google-sheets-stream-source` Kamelet: +[width="100%",cols="2,^2,3,^2,^2,^3",options="header"] +|=== +| Property| Name| Description| Type| Default| Example +| *accessToken {empty}* *| Access Token| OAuth 2 access token for google sheets application. This typically expires after an hour so refreshToken is recommended for long term usage.| string| | +| *applicationName {empty}* *| Application name| Google Sheets application name| string| | +| *clientId {empty}* *| Client Id| Client ID of the sheets application| string| | +| *clientSecret {empty}* *| Client Secret| Client Secret of the sheets application| string| | +| *index {empty}* *| Index| An index for the google sheets endpoint| string| | +| *refreshToken {empty}* *| Refresh Token| OAuth 2 refresh token for google sheets application. Using this, the Google Calendar component can obtain a new accessToken whenever the current one expires - a necessity if the application is long-lived.| string| | +| *spreadsheetId {empty}* *| Spreadsheet ID| The Spreadsheet ID to be used as events source| string| | +| range| Consume from now| the range of rows and columns in a sheet to get data from.| boolean| | `"A1:B3"` +| splitResults| Split Results| True if value range result should be split into rows or columns to process each of them individually.| boolean| `true`| +|=== + +NOTE: Fields marked with ({empty}*) are mandatory. + +== Usage + +This section summarizes how the `google-sheets-stream-source` can be used in various contexts. + +=== Knative Source + +The `google-sheets-stream-source` Kamelet can be used as Knative source by binding it to a Knative object. + +.google-sheets-stream-source-binding.yaml +[source,yaml] +---- +apiVersion: camel.apache.org/v1alpha1 +kind: KameletBinding +metadata: + name: google-sheets-stream-source-binding +spec: + source: + ref: + kind: Kamelet + apiVersion: camel.apache.org/v1alpha1 + name: google-sheets-stream-source + properties: + accessToken: "The Access Token" + applicationName: "The Application name" + clientId: "The Client Id" + clientSecret: "The Client Secret" + index: "The Index" + refreshToken: "The Refresh Token" + spreadsheetId: "The Spreadsheet ID" + sink: + ref: + kind: InMemoryChannel + apiVersion: messaging.knative.dev/v1 + name: mychannel + +---- + +Make sure you have xref:latest@camel-k::installation/installation.adoc[Camel K installed] into the Kubernetes cluster you're connected to. + +Save the `google-sheets-stream-source-binding.yaml` file into your hard drive, then configure it according to your needs. + +You can run the source using the following command: + +[source,shell] +---- +kubectl apply -f google-sheets-stream-source-binding.yaml +---- +// THIS FILE IS AUTOMATICALLY GENERATED: DO NOT EDIT