How to retrieve all sheets data from google sheets api using apache camel

Question

I want to be able to retrieve all the sheets' (sheet1,sheet2,...etc) data from Google Sheets, not just one sheet (sheet1, in this example):

   from("timer:run?repeatCount=1")
      .to("google-sheets://data/get?spreadsheetId=1i8jAVG3r6BINzdU0NzgAIuDUuz3FiVRyFF1Wm6WQq_0&range='Camel Sheet1'")
      .log("${body}")
      .convertBodyTo(String.class)
      .process(new TransformerGoogleSheets())
      .to("file:file/Input?fileName=employee.csv")
      .log("Sucess");

I searched on Apache Camel's website but I couldn't get relevant solution.

Raphi1 · Accepted Answer · 2024-06-24 17:55:42Z

1

Looks like you want to use the getBatch method instead of get:

from("timer:run?repeatCount=1")
      .to("google-sheets://data/getBatch?spreadsheetId=1i8jAVG3r6BINzdU0NzgAIuDUuz3FiVRyFF1Wm6WQq_0")
      .log("${body}")
      .convertBodyTo(String.class)
      .process(new TransformerGoogleSheets())
      .to("file:file/Input?fileName=employee.csv")
      .log("Sucess");

I didn't use the google-sheets api yet, but probably you will get a list of ranges as a response. You can then split the body with .split(body()) and then process every range like you are doing now. You should get the structure of the response by analyzing your logged ${body}.

With the batchGet method you only have to specify the spreadsheetId and you can omit the range.

https://camel.apache.org/components/4.4.x/google-sheets-component.html#_api_data_method_batchGet

answered Jun 24, 2024 at 17:55

Raphi1

5731 gold badge4 silver badges16 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to retrieve all sheets data from google sheets api using apache camel

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related