I have recently started using Meltano and my first attempt at sourcing Facebook Ads data has hit a dead end. I have setup the Facebook App to access the Marketing API. Also managed to setup the Meltano extractor tap but facing a weird issue. I am getting an error that couldn't find the Facebook Ads account ID.

Need help fixing this problem? Visit <http://melta.no/> for troubleshooting steps, or to
join our friendly Slack community.

Plugin configuration is invalid
Catalog discovery failed: command ['/Users/taimoor/Meltano/meltano-projects/bc-fad-dawlance/.meltano/extractors/tap-facebook/venv/bin/tap-facebook', '--config', '/Users/taimoor/Meltano/meltano-projects/bc-fad-dawlance/.meltano/run/tap-facebook/tap.952134ca-a1aa-4327-b580-1191dd7af285.config.json', '--discover'] returned 1 with stderr:
 ERROR SingerConfigurationError
Couldn't find account with id 608423897533672
Traceback (most recent call last):
  File "/Users/taimoor/Meltano/meltano-projects/bc-fad-dawlance/.meltano/extractors/tap-facebook/venv/lib/python3.8/site-packages/tap_facebook/__init__.py", line 926, in main
    main_impl()
  File "/Users/taimoor/Meltano/meltano-projects/bc-fad-dawlance/.meltano/extractors/tap-facebook/venv/lib/python3.8/site-packages/tap_facebook/__init__.py", line 905, in main_impl
    raise SingerConfigurationError("Couldn't find account with id {}".format(account_id))
singer.exceptions.SingerConfigurationError: SingerConfigurationError
Couldn't find account with id 608423897533672
CRITICAL SingerConfigurationError
CRITICAL Couldn't find account with id 608423897533672
Traceback (most recent call last):
  File "/Users/taimoor/Meltano/meltano-projects/bc-fad-dawlance/.meltano/extractors/tap-facebook/venv/bin/tap-facebook", line 8, in <module>
    sys.exit(main())
  File "/Users/taimoor/Meltano/meltano-projects/bc-fad-dawlance/.meltano/extractors/tap-facebook/venv/lib/python3.8/site-packages/tap_facebook/__init__.py", line 934, in main
    raise e
  File "/Users/taimoor/Meltano/meltano-projects/bc-fad-dawlance/.meltano/extractors/tap-facebook/venv/lib/python3.8/site-packages/tap_facebook/__init__.py", line 926, in main
    main_impl()
  File "/Users/taimoor/Meltano/meltano-projects/bc-fad-dawlance/.meltano/extractors/tap-facebook/venv/lib/python3.8/site-packages/tap_facebook/__init__.py", line 905, in main_impl
    raise SingerConfigurationError("Couldn't find account with id {}".format(account_id))
singer.exceptions.SingerConfigurationError: SingerConfigurationError
Couldn't find account with id 608423897533672

I have tried using the Facebook Ads SDK for Python and this ad account ID works fine through that. Please help

how does your meltano.yml look? are you using the singer-io variant of this tap? beyond that all I could immediately suggest is: • Pass the

account_id

as a string rather than int? • ensure

start_date

is

YYYY-MM-DD

format • try selecting a specific stream like

campaigns

just in case it's a perms thing? • assuming you're using the token in the SDK comparison? or does that handle the auth? in which case maybe generate a new one?

Hi @gary_james thanks for the reply and some good pointers. It seems I was not passing the

account_id

as a string. Changing that fixed the issue I was facing earlier. The date format was correct but I am looking into selecting a specific stream like

campaigns

as I have started running into too many API calls issue with Facebook. The did generate a new API token after testing through the Python SDK so that was not an issue.

excellent! glad it's working at least 👌 yay sheepy