Hi everyone! Can someone help me? I'm using tap-spreadsheets-anywhere to get a .xlsx file from s3 b...
f
Hi everyone! Can someone help me? I'm using tap-spreadsheets-anywhere to get a .xlsx file from s3 but i'm getting this error:
Copy code
Run invocation could not be completed as block failed: Cannot start plugin tap-spreadsheets-anywhere--facebook: Catalog discovery failed: command ['/home/fcampelo/Documents/Repositories/-----/------/.meltano/extractors/tap-spreadsheets-anywhere/venv/bin/tap-spreadsheets-anywhere', '--config', '/home/fcampelo/Documents/Repositories/-----/-----_aws_meltano/.meltano/run/tap-spreadsheets-anywhere--facebook/tap.299f5811-7850-4a3b-bc4e-930e71288f1a.config.json', '--state', '/home/fcampelo/Documents/Repositories/-----/-----_aws_meltano/.meltano/run/tap-spreadsheets-anywhere--facebook/state.json', '--discover'] returned 1 with stderr:
 INFO Found credentials in environment variables.
INFO Found 26 files.
INFO Checking 26 resolved objects for any that match regular expression "social_media/facebook/overview_social_data/facebook_overview.*.xlsx" and were modified since 2000-01-01 00:00:00+00:00
INFO Processing 1 resolved objects that met our criteria. Enable debug verbosity logging for more details.
INFO Sampling social_media/facebook/overview_social_data/facebook_overview_2021-01-01_to_2023-11-30.xlsx (2000 records, every 10th record).
ERROR Unable to write Catalog entry for 'facebook_overview' - it will be skipped due to error [Errno 2] No such file or directory: 'social_media/facebook/overview_social_data/facebook_overview_2021-01-01_to_2023-11-30.xlsx'
CRITICAL [Errno 2] No such file or directory: 'social_media/facebook/overview_social_data/facebook_overview_2021-01-01_to_2023-11-30.xlsx'
My tap configuration:
Copy code
extractors:
  - name: tap-spreadsheets-anywhere--facebook
    inherit_from: tap-spreadsheets-anywhere
    config:
      tables:
      - path: s3://<my-bucket>
        name: facebook_overview
        pattern: social_media/facebook/overview_social_data/facebook_overview.*.xlsx
        start_date: '2000-01-01T00:00:00+00'
        key_properties: [Post ID]
        format: excel
        worksheet_name: "FB - Posts Table"
        sample_rate: 10
        max_sampling_read: 2000
        max_sampled_files: 3
        prefer_number_vs_integer: true
a
f
Thanks, @Andy Carter!