Source Facebook Marketing: find_account method does not work on privacy filtered accounts

[mdibaiee]

Hello!

The current implementation of _find_account of facebook-marketing source fetches a list of adaccounts and iterates over them, trying to match the account ID:

airbyte/airbyte-integrations/connectors/source-facebook-marketing/source_facebook_marketing/api.py

Lines 174 to 184 in 09d1c06

	def _find_account(account_id: str) -> AdAccount:
	"""Actual implementation of find account"""
	try:
	accounts = fb_user.User(fbid="me").get_ad_accounts()
	for account in accounts:
	if account["account_id"] == account_id:
	return account
	except FacebookRequestError as exc:
	raise FacebookAPIException(f"Error: {exc.api_error_code()}, {exc.api_error_message()}") from exc
	raise FacebookAPIException("Couldn't find account with id {}".format(account_id))

However, in some cases the AdAccount is not "listable" due to privacy filters, but it can still be accessed directly using a request like this:

curl -i -X GET \
 "https://graph.facebook.com/act_<AD_ACCOUNT_ID>"

From Facebook SDK's documentation and code samples, I can see they initialise new AdAccounts this way:

my_account = AdAccount('act_<your-adaccount-id>')

Sources:

• https://github.com/facebook/facebook-python-business-sdk/blob/fbc3b6a5c2d54bd4184163b290dd614b668e4ee0/README.md#create-testpy
• https://github.com/facebook/facebook-python-business-sdk/blob/fbc3b6a5c2d54bd4184163b290dd614b668e4ee0/examples/AdAccountAdVideosPost.py#L36-L39
• https://github.com/facebook/facebook-python-business-sdk/blob/fbc3b6a5c2d54bd4184163b290dd614b668e4ee0/examples/AdAccountAdsPost.py#L39-L42
• https://github.com/facebook/facebook-python-business-sdk/blob/fbc3b6a5c2d54bd4184163b290dd614b668e4ee0/examples/AdAccountCampaignsPostOfferClaims.py