The Content API lets you access and retrieve data from the platform for integration and content extraction. It supports both raw and transformed data, allowing real-time retrieval for your systems. Rate limits help maintain performance and should be followed when making API calls.
Included headers in every authenticated response (success or failure):
If the rate limit is exceeded, the API will return an HTTP 429 status code and a message with how many seconds to wait until the limit resets.
{"status":"fail","message":"Rate Limit Exceeded. Please wait -timeUntilReset- seconds before trying again."}
db_id required | integer ID of the database to get transformed data from |
direction | string Order direction, can be > or < |
limit | number How many results should be returned |
offset | number Offset used for paging |
selector | string The query selector to filter data by |
x-api-key required | string |
{- "status": "success",
- "total_run_time": 0.054791927337646,
- "total_data_iterate_run_time": 0.000046014785766602,
- "select_data_run_time": 0.035505056381226,
- "total_count": 462,
- "data": [
- {
- "id": "101",
- "field_0": "Red",
- "field_1": "Array",
- "field_2": "Light",
- "field_3": "Left",
- "field_4": "Vanilla",
- "field_5": null
}, - {
- "id": "101",
- "field_0": "Blue",
- "field_1": "Object",
- "field_2": "Dark",
- "field_3": "Right",
- "field_4": "Chocolate",
- "field_5": null
}
], - "total_chunks": 1
}
db_id required | integer ID of the database that the export belongs to |
export_id required | integer ID of the export |
x-api-key required | string |
Downloads Data with several options including general, export or raw
delimiter required | string Enum: "tab" "comma" "pipe" "semicolon" The delimiter used to parse data |
do_notify required | boolean A flag to check if the user should be alerted when the process completes |
fe_download required | boolean A flag to format the response for download |
ignore_export_selector required | boolean A flag to determine if export selector should be ignored |
no_transformers | boolean A flag to return raw data (no transformers applied) |
push | string Enum: "true" "false" Determines if an export should get pushed or simply produce the output |
selected_columns | Array of any An array with the specific columns the output should include |
[- {
- "delimiter": "tab",
- "do_notify": false,
- "fe_download": true,
- "ignore_export_selector": false,
- "no_transformers": false,
- "push": "false"
}
]
{- "status": "success",
- "message": "",
- "data": {
- "url": "dev145.feedonomics.com\\/exports\\/51519_0_03ff4074fb83018e62292b9c8784182c9c58d28ce9d7188757657aahgsNgo.txt",
- "total_count": 123,
- "duration": null,
- "data_governance_queries": [ ],
- "summary": [ ],
- "extra": [ ],
- "correlation_id": "4d2f4a5470372f31",
- "ebs_metrics": [ ],
- "hostname": "dev145.feedonomics.com",
- "scheduled_run_time": "",
- "db": {
- "id": "12345",
- "name": "Luxury Knives",
- "category_field_offset": null,
- "user_id": "73",
- "account_id": "9876",
- "import_running": "0",
- "export_running": "1",
- "paused": "0",
- "visibility": "1",
- "oauth_id": "0",
- "email_address": "",
- "google_account_id": "",
- "google_account_name": "",
- "google_analytics_oauth_id": "0",
- "google_analytics_profile_id": "",
- "amazon_seller_id": "",
- "amazon_marketplace_id": "",
- "amazon_mws_auth_token": "",
- "bing_oauth_id": "0",
- "bing_shopping_account_id": "",
- "bing_shopping_campaign_id": "",
- "polyvore_username": "",
- "polyvore_password": "",
- "polyvore_campaign_id": "",
- "external_id": "",
- "time": "2024-01-01 01:00:00",
- "feedonomics_auth_token": "",
- "manual_billing_exclusion": "0",
- "google_merchant_center_oauth_id": "",
- "google_merchant_center_account_id": "",
- "google_my_business_oauth_id": "",
- "timestamp": "2024-01-01 01:00:00",
- "billing_parent_id": "0",
- "sears_email": "",
- "sears_seller_id": "",
- "sears_secret_key": "",
- "walmart_private_key": "",
- "walmart_consumer_id": "",
- "kijiji_oauth_id": "0",
- "mercado_libre_client_id": "",
- "mercado_libre_client_secret": "",
- "mercado_libre_oauth_id": "0",
- "mercado_libre_country": "",
- "google_sheets_oauth_id": "0",
- "shopify_oauth_id": "0",
- "facebook_oauth_id": "56789",
- "facebook_page_id": "",
- "facebook_cms_id": "454545454545",
- "character_set": "utf8",
- "host": "192.168.0.243",
- "scheduler_host": "scheduler1.feedonomics.com",
- "feed_report_host": "feedreport1.feedonomics.com",
- "cxn_id": "98765432",
- "run_import_id": "c9876543ce0",
- "data_count": "562",
- "google_service_account_id": "0",
- "woocommerce_oauth_id": "0",
- "bigcommerce_oauth_id": "0",
- "empty_exports_on_data_refresh_failures": "0",
- "last_run_imports_status": "success",
- "etsy_oauth_id": null,
- "shein_oauth_id": "0",
- "wish_oauth_id": "0",
- "tiktok_oauth_id": "0",
- "tiktok_country": "",
- "tiktok_env": "",
- "tiktok_store_name": "",
- "db_service": "1",
- "created_at": "2023-01-01 01:00:00",
- "deleted_at": "0000-00-00 00:00:00",
- "mirakl_oauth_id": "0",
- "run_import_stats": "{\\'123456\\':{\\'join_type\\':\\'product_feed\\',\\'update\\':0,\\'load\\':\\'562\\',\\'duration\\':0,\\'first_run\\':false},\\'234567\\':{\\'join_type\\':\\'join_info\\',\\'update\\':\\'562\\',\\'load\\':\\'562\\',\\'duration\\':0,\\'first_run\\':false},\\'345678\\':{\\'join_type\\':\\'join_info\\',\\'update\\':\\'3\\',\\'load\\':\\'3\\',\\'duration\\':0,\\'first_run\\':false}}",
- "run_import_duration": "1",
- "primary_db_field_key": "id",
- "event_sync": "0",
- "worker_pid": "65456",
- "worker_hostname": "db-service11.feedonomics.com",
- "subscribe_to_ebs_integration": "0",
- "chunk_size": "5000",
- "unique_pkey_constraint": "1",
- "requested_primary_key": "",
- "next_build_time": null,
- "paused_at": null,
- "query_worker_group": "php8",
- "redis_cluster": "data",
- "db_group_name": "Ungrouped"
}, - "account": {
- "account_name": "luxury_knives"
}, - "export": {
- "id": 0,
- "db_id": "12345",
- "name": "Knives Export",
- "cron": "",
- "legacy_workers": 0,
- "delimiter": "tab",
- "enclosure": "\\'",
- "escape": "\\'",
- "export_format": "delimited",
- "strip_characters": "",
- "show_empty_tags": 0,
- "show_empty_parent_tags": 0,
- "use_cdata": 0,
- "xml_write_document_tag": 0,
- "file_name": "",
- "protocol": "local",
- "protocol_info": "",
- "host": "",
- "username": "",
- "password": "",
- "export_selector": "true",
- "file_header": "",
- "file_footer": "",
- "threshold": "",
- "timeout": 60,
- "compression": "1",
- "quoted_fields": "0",
- "deduplicate_field_name": "",
- "include_column_names": "1",
- "export_encoding": "",
- "zip_inner_file_name": "",
- "time_between_attempts": 1,
- "max_attempts": 1,
- "chunk_transfer_protocol": "apache",
- "item_group_id": "",
- "timestamp": "1900-01-01",
- "db_group_id": null
}, - "error_time": "2024-02-01 02:00:00 EST",
- "push": false,
- "run_duration": 19
}
}
db_id required | integer ID of the database to get transformed data from |
export_id required | integer The export ID to get transformed data from. Default to 0 for all |
direction | string Order direction, can be > or < |
limit | number How many results should be returned |
offset | number Offset used for paging |
selector | string The query selector to filter data by |
override_logs | boolean Returns override_logs with each row of data to get the original values pre-transformed data overrides |
x-api-key required | string |
[- {
- "status": "success",
- "correlation_id": "185191d4bae6ed2a",
- "total_run_time": 13.243301868439,
- "total_count": 462,
- "data": [
- [
- "Pencil",
- "High",
- "Tap"
], - [
- "Pen",
- "Low",
- "Ballet"
]
], - "total_chunks": 1,
- "queue_chunk_metrics": [
- {
- "queue_time_chunk_0_0": {
- "local_host": "chunk-worker6.feedonomics.com",
- "remote_host": null,
- "db_id": 1,
- "resource_type": "",
- "resource_id": 0,
- "correlation_id": "abcdef",
- "event": "queue_time_chunk_0_0",
- "value1": 147473.81210327,
- "value2": null,
- "value3": null,
- "value4": null,
- "value5": null,
- "value6": null,
- "value7": null,
- "value8": null,
- "value9": null,
- "value10": null,
- "memory_usage": 6843656,
- "memory_peak": 24133736,
- "tag1": null,
- "tag2": null,
- "tag3": null,
- "tag4": null,
- "tag5": null,
- "timestamp": "2024-11-20 01:47:41",
- "scheduled": 0,
- "query_worker_group": null
}
}
]
}
]