CData Python Connector for Instagram

Build 23.0.8868


It returns the metric endtime and the value. For this view, the Metric type is time_series and breakdown is media_product_type. Requires the instagram_basic and instagram_manage_insights scopes.


The connector will use the Instagram APIs to process filters that refer to a date range or InstagramBusinessAccountId and will process other filters client-side within itself.

  • Metric supports the '=' operator.

The default query returns results for the 'reach' metric.

SELECT * FROM AccountTimeSeriesMediaProductType
SELECT * FROM AccountTimeSeriesMediaProductType WHERE FromDateTime='2023-06-20T00:00:00Z' AND ToDateTime='2023-07-12T00:00:00Z'


Name Type Description
InstagramBusinessAccountId String The unique identifier for the Instagram business account Id.
Metric String Metric Type. The supported Metric types are reach, impressions website_clicks, profile_views. The default metric type is reach.
EndTime Datetime End time.
Value Integer Total values of the metrics.


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