JDBC Driver for Instagram

Build 24.0.9062

OnlineFollowers

Query Online Followers insights as hourly totals. Requires the instagram_basic and instagram_manage_insights scopes.

Select

You can use the FromDateTime and ToDateTime columns to filter the results by a timeframe. The 本製品 uses the Instagram API to process filters that refer to a timeframe or Id and will process other filters client-side within itself.

  • The default query returns results as hourly totals during the last 7 days.

    SELECT * FROM OnlineFollowers

  • The maximum timeframe you can specify with the FromDateTime and ToDateTime columns is 30 days (2592000 s).

    SELECT * FROM OnlineFollowers WHERE FromDateTime = '2018/01/01' AND ToDateTime = '2018/01/30' 

Columns

Name Type Description
InstagramBusinessAccountId String The unique identifier for the business account.
StartTime Datetime The start datetime of the insight.
EndTime Datetime The end datetime of the insight.
Onlinefollowers Integer The number of the online followers at the specific time.

Pseudo-Columns

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

Name Type Description
FromDateTime Datetime The earliest time for insight data to have been collected.
ToDateTime Datetime The latest time for insight data to have been collected.

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