TDV Adapter for Instagram

Build 21.0.8137

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 adapter 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

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
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) 2022 CData Software, Inc. - All rights reserved.
Build 21.0.8137