Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-3216

Implement INSERT, UPDATE and DELETE support for google-spreadsheet connector

    Details

    • Type: Enhancement
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: 8.10
    • Component/s: Misc. Connectors
    • Labels:
      None

      Description

      Current plan is to use list-based feed of the Google Data API[1].
      There are three known issues:
      performance - to delete/update 100 rows Teiid must generate 100 http requests
      consistency - user wants to update 50 rows. After the 10th row is updated the connection could fail which would cause that 10 rows would be updated and 40 wouldn't.
      headers - update, delete and and insert statements will be supported only for the spreadsheets that have a header for each column (headers are in the first row of a spreadsheet)

      Select statement is implemented using Google Visualisation API, but this API doesn't support updates and doesn't return row numbers.

      [1] https://developers.google.com/google-apps/spreadsheets/

        Gliffy Diagrams

          Attachments

            Issue Links

              Activity

                People

                • Assignee:
                  felias Filip Elias
                  Reporter:
                  felias Filip Elias
                • Votes:
                  1 Vote for this issue
                  Watchers:
                  3 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved: