JDBC Driver for Instagram

Build 22.0.8462

Pages

Get details of Pages. Requires 'pages_read_engagement' permission or the 'Page Public Content Access' feature or the 'Page Public Metadata Access' feature.

Table Specific Information

Select

The driver 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 driver.

  • 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

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 The term that is to be searched.

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