JDBC Driver for Instagram

Build 22.0.8462

Places

Query location data about a media object.

Select

To query the Places view, the SearchTerms column is required.

SELECT * FROM Places WHERE SearchTerms='museum'
The driver will execute other filters client-side within itself. Note: This view is deprecated. It will be discontinued in the 2023 Q2. Please use the Pages view as a replacement. You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false, in which case any search criteria that refers to other columns will cause an error.

Columns

Name Type Description
Id [KEY] String The unique identifier for the place.
Name String Name of the place.
City String City of the place.
Country String Country of the place.
Latitude String Latitude of the place.
Longitude String Longitude of the place.
Street String Street of the place.

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 Name of the place.

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