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
