astro-sdk icon indicating copy to clipboard operation
astro-sdk copied to clipboard

Sharepoint integration

Open sridharpaladugu opened this issue 1 year ago • 2 comments

Please describe the feature you'd like to see Seeking an integration into sharepoint with astro SDK.

Describe the solution you'd like I have a request from a customer to have a native integration to transfer files from sharepoint to destinations such as SFTP, etc. Basically an ability to download/upload files with sharepoint from ASTRO SDK.

Are there any alternatives to this feature? There are commercially available driver from cdata as an external component and have to implement the code.

Additional context Add any other context about the feature request here.

Acceptance Criteria

  • [x] All checks and tests in the CI should pass
  • [ ] Unit tests (90% code coverage or more, once available)
  • [x] Integration tests (if the feature relates to a new database or external service)
  • [ ] Example DAG
  • [ ] Docstrings in reStructuredText for each of methods, classes, functions and module-level attributes (including Example DAG on how it should be used)
  • [ ] Exception handling in case of errors
  • [ ] Logging (are we exposing useful information to the user? e.g. source and destination)
  • [ ] Improve the documentation (README, Sphinx, and any other relevant)
  • [x] How to use Guide for the feature (example)

sridharpaladugu avatar Jan 09 '23 14:01 sridharpaladugu

Looked at the reference implementation using https://github.com/vgrem/Office365-REST-Python-Client.

Currently CDATA driver has a sample -> https://www.cdata.com/kb/tech/sharepoint-jdbc-apache-airflow.rst

sridharpaladugu avatar Jan 09 '23 16:01 sridharpaladugu

I'll work on this one

Lee-W avatar Feb 15 '23 06:02 Lee-W