Query Data

Show all collection by project ID and source type

POST https://new-apiv2.importir.com/api/general/get-all-where

Request Body

Name	Type	Description
projectId*	String	Your project ID in firebase database
sourceType*	String	facebook-marketing / google-analytic-data-api / google-analytic-v4

200: OK

[
    "airbyte_raw_303N0DI0t1WLUnWgSiqb_activities",
    "airbyte_raw_303N0DI0t1WLUnWgSiqb_ad_account",
    "airbyte_raw_303N0DI0t1WLUnWgSiqb_ad_creatives",
    "airbyte_raw_303N0DI0t1WLUnWgSiqb_ad_sets",
    "airbyte_raw_303N0DI0t1WLUnWgSiqb_ads",
    "airbyte_raw_303N0DI0t1WLUnWgSiqb_ads_insights",
    "airbyte_raw_303N0DI0t1WLUnWgSiqb_ads_insights_action_carousel_card",
    "airbyte_raw_303N0DI0t1WLUnWgSiqb_ads_insights_action_conversion_device",
    "airbyte_raw_303N0DI0t1WLUnWgSiqb_ads_insights_action_product_id",
    "airbyte_raw_303N0DI0t1WLUnWgSiqb_ads_insights_action_reaction",
    "airbyte_raw_303N0DI0t1WLUnWgSiqb_ads_insights_action_type",
    "airbyte_raw_303N0DI0t1WLUnWgSiqb_ads_insights_action_video_sound",
    "airbyte_raw_303N0DI0t1WLUnWgSiqb_ads_insights_action_video_type",
    "airbyte_raw_303N0DI0t1WLUnWgSiqb_ads_insights_age_and_gender",
    "airbyte_raw_303N0DI0t1WLUnWgSiqb_ads_insights_country",
    "airbyte_raw_303N0DI0t1WLUnWgSiqb_ads_insights_delivery_device",
    "airbyte_raw_303N0DI0t1WLUnWgSiqb_ads_insights_delivery_platform",
    "airbyte_raw_303N0DI0t1WLUnWgSiqb_ads_insights_delivery_platform_and_device_platform",
    "airbyte_raw_303N0DI0t1WLUnWgSiqb_ads_insights_demographics_age",
    "airbyte_raw_303N0DI0t1WLUnWgSiqb_ads_insights_demographics_country",
    "airbyte_raw_303N0DI0t1WLUnWgSiqb_ads_insights_demographics_dma_region",
    "airbyte_raw_303N0DI0t1WLUnWgSiqb_ads_insights_demographics_gender",
    "airbyte_raw_303N0DI0t1WLUnWgSiqb_ads_insights_dma",
    "airbyte_raw_303N0DI0t1WLUnWgSiqb_ads_insights_platform_and_device",
    "airbyte_raw_303N0DI0t1WLUnWgSiqb_ads_insights_region",
    "airbyte_raw_303N0DI0t1WLUnWgSiqb_campaigns",
    "airbyte_raw_303N0DI0t1WLUnWgSiqb_custom_conversions",
    "airbyte_raw_303N0DI0t1WLUnWgSiqb_images",
    "airbyte_raw_303N0DI0t1WLUnWgSiqb_videos"
]

Example Request:

{
    "collectionName": "airbyte_raw_303N0DI0t1WLUnWgSiqb_ads",
    "query": [
        {
            "column": "_airbyte_data.campaign_id",
            "value": "23856447666420184",
            "operator": "="
        }
    ]
}

POST https://new-apiv2.importir.com/api/general/get-all-where

Example:

Request Body

Name	Type	Description
collectionName*	String
query*	Array

200: OK

{
    "count": 1,
    "data": [
        {
            "_id": "64d351fcca3cef5f0c66213e",
            "_airbyte_data": {
                "bid_type": "ABSOLUTE_OCPM",
                "account_id": "251454876440945",
                "campaign_id": "23856447666420184",
                "adset_id": "23856447666410184",
                "status": "ACTIVE",
                "creative": {
                    "id": "23856447688550184"
                },
                "id": "23856447666430184",
                "updated_time": "2023-08-09T15:35:59+0700",
                "created_time": "2023-08-02T17:40:26+0700",
                "name": "Vid-BingungCariSupplierdanProduk",
                "targeting": {
                    "age_max": 45,
                    "age_min": 21,
                    "geo_locations": {
                        "countries": [
                            "ID"
                        ],
                        "location_types": [
                            "home",
                            "recent"
                        ]
                    },
                    "brand_safety_content_filter_levels": [
                        "FACEBOOK_STANDARD"
                    ],
                    "publisher_platforms": [
                        "facebook",
                        "instagram"
                    ],
                    "facebook_positions": [
                        "feed",
                        "facebook_reels",
                        "facebook_reels_overlay",
                        "right_hand_column",
                        "video_feeds",
                        "instream_video",
                        "marketplace",
                        "story",
                        "search"
                    ],
                    "instagram_positions": [
                        "stream",
                        "ig_search",
                        "story",
                        "explore",
                        "reels",
                        "reels_overlay",
                        "explore_home",
                        "profile_feed"
                    ],
                    "device_platforms": [
                        "mobile",
                        "desktop"
                    ]
                },
                "effective_status": "ACTIVE",
                "last_updated_by_app_id": "119211728144504",
                "source_ad_id": "23856443604240184",
                "tracking_specs": [
                    {
                        "action.type": [
                            "offsite_conversion"
                        ],
                        "fb_pixel": [
                            "3918751638161726"
                        ]
                    },
                    {
                        "action.type": [
                            "onsite_conversion"
                        ],
                        "conversion_id": [
                            "5552927338136958",
                            "5733335830114065",
                            "5789470711095995",
                            "5856749287754960",
                            "8539294222778503"
                        ]
                    },
                    {
                        "action.type": [
                            "post_engagement"
                        ],
                        "page": [
                            "101902135820572"
                        ],
                        "post": [
                            "270942032364889"
                        ]
                    },
                    {
                        "action.type": [
                            "link_click"
                        ],
                        "post": [
                            "270942032364889"
                        ],
                        "post.wall": [
                            "101902135820572"
                        ]
                    }
                ],
                "conversion_specs": [
                    {
                        "action.type": [
                            "offsite_conversion"
                        ],
                        "conversion_id": [
                            "6415744138477011"
                        ]
                    }
                ]
            },
            "_airbyte_data_hash": "22637e52-5390-31f8-8a36-64d98440e2fa",
            "_airbyte_emitted_at": "2023-08-09T08:41:16.917"
        }
    ]
}