JDBC Driver for Instagram

Build 24.0.9062

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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062