Pages
Retrieves detailed metadata about Facebook Pages that are linked to an Instagram Business account. The information includes the page name, category, verification status, and any connected Instagram profiles. To access this data, you need permissions from a custom OAuth app, including either pages_read_engagement or approval for Page Public Content Access or Page Public Metadata Access.
Table Specific Information
Select
For information on how to create a custom OAuth app, please see Creating a Custom OAuth App. Please refer to Instagram's latest documentation for information on how to get this view's requisite permissions for a custom OAuth app.
The connector will use the Instagram API to process WHERE clause conditions built with the following column and operator. The SearchTerms is required to make a request and the rest of the filter is executed client side within the connector.
- SearchTerms supports the '=' comparison.
For example:
SELECT * FROM Pages WHERE SearchTerms = 'facebook'
Columns
| Name | Type | Description |
| Id [KEY] | String | A unique identifier assigned to the Facebook Page, used to distinguish it from other pages within the platform. |
| EligibleForBrandedContent | Boolean | Indicates whether the Facebook Page has been approved and meets all criteria to publish branded content, such as sponsored posts or paid partnerships. |
| IsUnclaimed | Boolean | Specifies whether the Facebook Page was automatically generated by Facebook and has not yet been officially claimed or managed by the associated business entity. |
| Link | String | The full Uniform Resource Locator (URL) hyperlink that directs users to the Facebook Page's public profile. |
| City | String | The city name extracted from the location information provided for the business associated with the Facebook Page. |
| Country | String | The country in which the business linked to the Facebook Page is physically located, based on its registered address. |
| Latitude | Double | The geographical latitude coordinate that pinpoints the exact location of the business represented by the Facebook Page. |
| Longitude | Double | The geographical longitude coordinate that defines the east-west position of the business associated with the Facebook Page. |
| State | String | The state, province, or administrative region listed as part of the physical address of the business linked to the Facebook Page. |
| Street | String | The street address component of the physical location of the business represented on the Facebook Page, typically including building number and street name. |
| Zip | Integer | The ZIP code used for mail delivery to the listed business location on the Facebook Page. |
| Name | String | The official or display name of the Facebook Page, which typically reflects the name of the associated business, organization, or entity. |
| VerificationStatus | String | Describes the current verification status of the Facebook Page, indicating whether the page has been authenticated by Facebook as a legitimate representation of a business. |
Pseudo-Columns
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.
| Name | Type | Description |
| SearchTerms | String | A non-stored, computed value representing one or more keywords used to facilitate text-based searches on the Facebook Page dataset. |