JDBC Driver for Facebook Ads

Build 22.0.8462


Ad Accounts authorized to run ads for your business on a specified app. This view requires that you have at least one business configured for your user id.

Table Specific Information

AuthorizedAdAccounts in Facebook represent the ad accounts that have been authorized for advertising on the specified application for your Facebook business. You must have a business set up in Facebook for this view to work correctly.


When querying AuthorizedAdAccounts, a Target must be specified and a business may optionally be specified. For instance:

SELECT * FROM AdAccounts WHERE Target = 'ApplicationId' AND Business = 'BusinessId'

If no business is specified, results for all of your available businesses will come back.


Name Type Description
ID [KEY] String The Id of the Ad Account.
Target String The app id to request authorized ad accounts from.
AccountId String The Id of the Ad Account when viewed directly in Facebook.


Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source. For more information, see the WHERE clause section.

Name Type Description
Business String The id of the business to retrieve authorized ad accounts for.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462