Pages
Get details of Pages. Requires a custom OAuth app with 'pages_read_engagement' permission or the 'Page Public Content Access' feature or the 'Page Public Metadata Access' feature.
Table Specific Information
Select
For information on how to create a custom OAuth app, please see カスタムOAuth アプリの作成. Please refer to Instagram's latest documentation for information on how to get this view's requisite permissions for a custom OAuth app.
The 本製品 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 本製品.
- SearchTerms supports the '=' comparison.
For example:
SELECT * FROM Pages WHERE SearchTerms = 'facebook'
Columns
Name | Type | Description |
Id [KEY] | String | The ID of the Facebook Page. |
EligibleForBrandedContent | Boolean | Display whether the Facebook Page is eligible to post branded content. |
IsUnclaimed | Boolean | Display whether a Facebook Page that was automatically generated has been claimed by the business it represents. |
Link | String | The link to the Facebook Page. |
City | String | The city where the business represented by the Facebook Page is located. |
Country | String | The country where the business represented by the Facebook Page is located. |
Latitude | Double | The latitude of the business represented by the Facebook Page. |
Longitude | Double | The longitude of the business represented by the Facebook Page. |
State | String | The state where the business represented by the Facebook Page is located. |
Street | String | The street on which the business represented by the Facebook Page is located. |
Zip | Integer | The postal code of the business represented by the Facebook Page. |
Name | String | The name of the Facebook Page. |
VerificationStatus | String | The verification status of the Facebook Page that represents a business. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
Name | Type | Description |
SearchTerms | String | The term that is to be searched. |