Skip to main content
Question

Updating the excel spreadsheet directly from streamsets

  • May 4, 2023
  • 1 reply
  • 42 views

I generally run the streamsets pipeline after which the couchbase gets updated and I export the JSON file, convert it and update my google spreadsheet which I will be using further for visualizations. 

My question here is, Is there any chances I can update the spreadsheet directly through Streamsets, so as to avoid the export of JSON and convert it to excel and update the sheet. 

 

1 reply

Bikram
Headliner
Forum|alt.badge.img+1
  • Headliner
  • 486 replies
  • May 5, 2023

@Madhumitha 

Can you please try to make it in jython or groovy script.


Reply