Hi, Please find the documentation in [1]. [1] - https://docs.wso2.com/display/ESBCONNECTORS/Sample+Business+Scenario+for+Google+Spreadsheet
Thanks, Biruntha Associate Software Engineer WSO2 Email : [email protected] Linkedin : https://lk.linkedin.com/in/biruntha Mobile : +94773718986 On Wed, Nov 9, 2016 at 7:01 PM, Malaka Silva <[email protected]> wrote: > Hi Biruntha, > > Shall we document it please? > > On Wed, Nov 9, 2016 at 12:59 PM, Biruntha Gnaneswaran <[email protected]> > wrote: > >> Hi All, >> >> I have done the spreadsheet connector use case by integrating the >> spreadsheet connector with the Salesforce REST Connector. For that I used >> query operation from the Salesforce REST Connector to get the records and >> add that records into Spreadsheet using addRowsColumnsData operation from >> the spreadsheet connector. >> >> Please find the use case for the spreadsheet connector here [1] . >> >> >> >> [1] - >> >> >> Thanks, >> >> Biruntha >> >> Associate Software Engineer >> WSO2 >> Email : [email protected] >> Linkedin : https://lk.linkedin.com/in/biruntha >> Mobile : +94773718986 >> >> On Mon, Oct 17, 2016 at 1:21 PM, Biruntha Gnaneswaran <[email protected]> >> wrote: >> >>> Hi All, >>> >>> I have planned to develop $subject as described below. The Google Sheets >>> API lets you read and modify any aspect of a spreadsheet. An existing >>> connector was developed to support Google Sheets API version 3 [1], now >>> version 4 [2] is available with new changes such as the version 4 is >>> JSON-based, has an easier-to-use interface, and adds a substantial amount >>> of functionality that is not possible in the version 3. >>> >>> I have selected following Methods for the implementation, >>> Working with Spreadsheet >>> >>> - >>> >>> Creating spreadsheet >>> - >>> >>> list spreadsheets (version 4 does not provide this operation. >>> However, it can be replicated via the Drive API Files.list >>> <https://developers.google.com/drive/v3/reference/files/list> method) >>> >>> *Working with Sheets* >>> >>> - >>> >>> Retrieve sheet metadata :- which includes information such as sheet >>> titles and size information. >>> - >>> >>> Add a sheet/ multiple sheets to a spreadsheet >>> - >>> >>> updateSheetProperties using batch request :– Version 4 can be used to >>> update other sheet properties in addition to the title and size. >>> >>> - >>> >>> Delete a sheet / multiple sheets using batch request. >>> - >>> >>> copyTo :- Copies a single sheet from a spreadsheet to another >>> spreadsheet. >>> - >>> >>> updateCells using batch request :- removes all values from a sheet or >>> clears the sheet of all formatting >>> >>> - >>> >>> appendDimension using batch request :- appends empty rows and columns to >>> the end of the sheet. >>> >>> - >>> >>> updateBorders using batch request :- Edit cell borders >>> >>> - >>> >>> repeatCell using batch request :- formats a header row in a sheet, Set a >>> custom date time or decimal format for a range >>> >>> - >>> >>> mergeCells using batch request :- Merge cells >>> >>> - >>> >>> setDataValidation using batch request :- request applies a data >>> validation rule >>> >>> - >>> >>> copyPaste using batch request :- request copies the formatting in one >>> range and pastes it to another range on the same sheet >>> >>> - >>> >>> cutPaste using batch request :- request cuts the one range and pastes >>> its data, formats, formulas, and merges to the another range on the same >>> sheet >>> >>> - >>> >>> repeatCell using batch request :- Repeating a formula over a range >>> >>> - >>> >>> updateConditionalFormatRule using batch request :- Update a conditional >>> formatting rule >>> >>> - >>> >>> addConditionalFormatRule using batch request :- Add a conditional color >>> gradient across a row, Add a conditional formatting rule to a set of >>> ranges, Add date and text conditional formatting rules to a range and >>> establishes a new conditional formatting rule to a the range >>> >>> - >>> >>> deleteConditionalFormatRule using batch request - Delete a conditional >>> formatting rule >>> >>> >>> *Working with Row/Column based feeds* >>> >>> - >>> >>> Retrieve row/ rows of data :– version 4 does not use access methods >>> that are row-specific. Instead, sheet cell data is accessed by >>> referencing >>> the specific ranges required using A1 notation >>> <https://developers.google.com/sheets/guides/concepts#a1_notation>. >>> - >>> >>> Add a new row/rows of data >>> - >>> >>> Updating a list row >>> - >>> >>> removing rows and can also be used to remove columns, and remove >>> part of a row or column >>> - >>> >>> updateDimensionProperties using batch request :- Adjust column width or >>> row height >>> >>> - >>> >>> autoResizeDimensions using batch request :– Request turns on automatic >>> resizing of columns >>> >>> - >>> >>> insertDimension using batch request :- Insert an empty row or column >>> >>> - >>> >>> moveDimension using batch request :- Move a row or column >>> >>> - >>> >>> sortRange using batch request :- Sort a range with multiple sorting >>> specifications >>> >>> >>> *Working with Cell-based feeds* >>> >>> - >>> >>> Retrieve cell data or multiple ranges of cell data :– version 3 can >>> only return cell contents as input values (as would be entered by a user >>> at >>> a keyboard) and/or the outputs of formula (if numeric). But version 4 >>> grants full access to values, formulas, formatting, hyperlinks, data >>> validation, and other properties. >>> - >>> >>> Edit content of a cell >>> - >>> >>> Edit content of multiple cell using batch request >>> >>> I have attached [3] my milestone plan for the Google Spreadsheet >>> Connector. >>> >>> [1] https://developers.google.com/google-apps/spreadsheets/?hl=en[2] >>> https://developers.google.com/sheets/guides/concepts >>> [3] >>> https://docs.google.com/spreadsheets/d/1DvemfUFwBo4JHrbWyNpcpqMQQ1SoVo3ag3Q9tl9Pmuw/edit#gid=0 >>> >>> Thanks, >>> >>> Biruntha >>> >>> Associate Software Engineer >>> WSO2 >>> Email : [email protected] >>> Linkedin : https://lk.linkedin.com/in/biruntha >>> Mobile : +94773718986 >>> >> >> > > > -- > > Best Regards, > > Malaka Silva > Senior Technical Lead > M: +94 777 219 791 > Tel : 94 11 214 5345 > Fax :94 11 2145300 > Skype : malaka.sampath.silva > LinkedIn : http://www.linkedin.com/pub/malaka-silva/6/33/77 > Blog : http://mrmalakasilva.blogspot.com/ > > WSO2, Inc. > lean . enterprise . middleware > https://wso2.com/signature > http://www.wso2.com/about/team/malaka-silva/ > <http://wso2.com/about/team/malaka-silva/> > https://store.wso2.com/store/ > > Don't make Trees rare, we should keep them with care >
_______________________________________________ Architecture mailing list [email protected] https://mail.wso2.org/cgi-bin/mailman/listinfo/architecture
