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
[
"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
{
"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"
}
]
}Last updated