ODBC Driver for Instagram

Build 20.0.7654

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 本製品 will execute other filters client-side within itself. 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

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name Type Description
SearchTerms String Name of the place.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7654