any one has used sharepoint tap ? how to create s...
# getting-started
g
any one has used sharepoint tap ? how to create stream
c
Hi, yes I've used it in a few scenarios, I've got a custom fork however so it may have some subtle differences to the meltano hub version (https://github.com/chadcampling-opteon/tap-sharepointsites) The below example config will produce a c_regions stream. The MS Graph explorer can be helpful for understanding the correct URL to use (https://developer.microsoft.com/en-us/graph/graph-explorer) as it differs if you're using a site, private group and subfolders
Copy code
- name: tap-sharepointsites-lookups
    inherit_from: tap-sharepointsites
    config:
      api_url: <https://graph.microsoft.com/v1.0/sites/mycompany.sharepoint.com:/sites/DataHub:/>
      files:
      - name: c_regions
        file_pattern: C Regions.xlsx
        file_type: excel
        folder: Assets/Power BI
        sheet_name: Postcode to region
        clean_colnames: true