search

airbytehq / airbyte

The leading data integration platform for ETL / ELT data pipelines from APIs, databases & files to data warehouses, data lakes & data lakehouses. Both self-hosted and Cloud-hosted.
https://airbyte.com
Other
14.82k stars 3.81k forks source link

New source: Microsoft excel online (sharepoint) #5475

Open sherifnada opened 2 years ago

sherifnada commented 2 years ago

Tell us about the new connector you’d like to have

As an Airbyte user, I'd like to be able to pull spreadsheets from Microsoft sharepoint.

Describe the context around this new connector

Airbyte supports Google sheets, but excel/Sharepoint has a large userbase as well

Describe the alternative you are considering or using

spreadsheets anywhere singer tap

igrankova commented 2 years ago

Can't create Sandbox subscription. Error: "This service is temporarily unavailable due to a high volume of requests. Please try again later". Made several tries during a week, it doesn't allow to subscribe and I can't continue Vetting process.

sherifnada commented 2 years ago

Let's set a reminder to try again in one week if possible

igrankova commented 2 years ago

Let's set a reminder to try again in one week if possible

I'm trying to manage this issue with the Microsoft support (created the support ticket)

igrankova commented 2 years ago

Webhook-based? (no/partially/yes) partially: https://docs.microsoft.com/en-us/sharepoint/dev/apis/webhooks/overview-sharepoint-webhooks

Available authentication modes (API key/Oauth/other) Excel Services REST API https://docs.microsoft.com/en-us/sharepoint/dev/general-development/excel-services-rest-api Excel JavaScript API https://docs.microsoft.com/en-us/office/dev/add-ins/reference/overview/excel-add-ins-reference-overview?view=excel-js-preview

Has Sandbox environment? Yes: https://docs.microsoft.com/en-us/office/dev/add-ins/testing/sideload-office-add-ins-for-testing

How to populate the account with data UI, OData: https://docs.microsoft.com/en-us/sharepoint/dev/general-development/using-odata-with-excel-services-rest-in-sharepoint

Available streams for sync Charts Comments Conditional formatting Custom functions Data validation Events PivotTables Ranges and Cells RangeAreas (Multiple ranges) Shapes Tables Workbooks and Application-level APIs Worksheets

Integration supports incremental sync? No

Other information/blockers

igrankova commented 2 years ago

@sherifnada Vetting is completed, ready for implementation

alexsubota commented 1 year ago

Hi, any news about this connector?

misteryeo commented 1 year ago

Issue was linked to Harvestr Discovery: New Source: Microsoft SharePoint

akshaysinghas commented 11 months ago

Hello guys, I am very new to open source. I have created a sharepoint excel online connector which is a custom implementation. It was done using microsoft graph API. I can contribute to this connector. @igrankova / @sherifnada can you guide me into how to start? Anyone else already working on it? I have gone through contribution guidelines.