Export Query Examples
Export data as JSON
This query exports news articles as JSON format.
params = {
"category.id": "medtop:04000000",
"export": "json",
"api_key": "YOUR_API_KEY"
}curl -X GET "https://api.apitube.io/v1/news/everything?category.id=medtop:04000000&export=json&api_key=YOUR_API_KEY" -o financial_news.jsonExport data as XML
This query exports news articles as XML format.
params = {
"category.id": "medtop:04000000",
"export": "xml",
"api_key": "YOUR_API_KEY"
}curl -X GET "https://api.apitube.io/v1/news/everything?category.id=medtop:04000000&export=xml&api_key=YOUR_API_KEY" -o financial_news.xmlExport data as XLSX
This query exports news articles as XLSX (Excel) format.
params = {
"category.id": "medtop:04000000",
"export": "xlsx",
"api_key": "YOUR_API_KEY"
}curl -X GET "https://api.apitube.io/v1/news/everything?category.id=medtop:04000000&export=xlsx&api_key=YOUR_API_KEY" -o financial_news.xlsxExport data as CSV
This query exports news articles as CSV format.
params = {
"category.id": "medtop:04000000",
"export": "csv",
"api_key": "YOUR_API_KEY"
}curl -X GET "https://api.apitube.io/v1/news/everything?category.id=medtop:04000000&export=csv&api_key=YOUR_API_KEY" -o financial_news.csvExport data as TSV
This query exports news articles as TSV format.
params = {
"category.id": "medtop:04000000",
"export": "tsv",
"api_key": "YOUR_API_KEY"
}curl -X GET "https://api.apitube.io/v1/news/everything?category.id=medtop:04000000&export=tsv&api_key=YOUR_API_KEY" -o financial_news.tsvData export for financial analysis
This query exports financial news in Excel format for analysis.
params = {
"category.id": "medtop:04000000",
"title": "finance,market,economy",
"export": "xlsx",
"api_key": "YOUR_API_KEY"
}curl -X GET "https://api.apitube.io/v1/news/everything?category.id=medtop:04000000&title=finance,market,economy&export=xlsx&api_key=YOUR_API_KEY" -o financial_news.xlsxCSV export for sentiment analysis
This query exports sentiment data about major tech companies in CSV format.
params = {
"organization.name": "Amazon,Microsoft,Google",
"sort.by": "sentiment.overall.score",
"sort.order": "desc",
"export": "csv",
"api_key": "YOUR_API_KEY"
}curl -X GET "https://api.apitube.io/v1/news/everything?organization.name=Amazon,Microsoft,Google&sort.by=sentiment.overall.score&sort.order=desc&export=csv&api_key=YOUR_API_KEY" -o tech_sentiment.csvCross-market ESG reporting comparative analysis export
This query exports a comprehensive dataset for comparative analysis of ESG (Environmental, Social, Governance) reporting trends.
params = {
"title": "ESG,sustainability,climate,governance",
"category.id": "medtop:04000000",
"source.country.code": "us,gb,de,fr",
"sort.by": "source.country.code,sentiment.overall.score",
"is_duplicate": "0",
"export": "xlsx",
"api_key": "YOUR_API_KEY"
}curl -X GET "https://api.apitube.io/v1/news/everything?title=ESG,sustainability,climate,governance&category.id=medtop:04000000&source.country.code=us,gb,de,fr&sort.by=source.country.code,sentiment.overall.score&is_duplicate=0&export=xlsx&api_key=YOUR_API_KEY" -o global_esg_reporting_analysis.xlsxMulti-source pharmaceutical innovation tracking export
This query exports a dataset tracking pharmaceutical innovations and clinical trials.
params = {
"title": "clinical trial,FDA,drug,pharmaceutical",
"category.id": "medtop:07000000",
"language.code": "en",
"sort.by": "published_at",
"is_duplicate": "0",
"export": "csv",
"api_key": "YOUR_API_KEY"
}curl -X GET "https://api.apitube.io/v1/news/everything?title=clinical%20trial,FDA,drug,pharmaceutical&category.id=medtop:07000000&language.code=en&sort.by=published_at&is_duplicate=0&export=csv&api_key=YOUR_API_KEY" -o pharma_innovation_tracking.csvGeopolitical crisis media coverage analysis export
This query exports a comprehensive dataset for analyzing media coverage patterns during major geopolitical crises.
params = {
"title": "conflict,crisis,war,peace,diplomacy",
"category.id": "medtop:11000000",
"language.code": "en",
"sort.by": "published_at",
"is_duplicate": "0",
"per_page": "100",
"export": "xlsx",
"api_key": "YOUR_API_KEY"
}curl -X GET "https://api.apitube.io/v1/news/everything?title=conflict,crisis,war,peace,diplomacy&category.id=medtop:11000000&language.code=en&sort.by=published_at&is_duplicate=0&per_page=100&export=xlsx&api_key=YOUR_API_KEY" -o geopolitical_crisis_media_analysis.xlsxAI regulatory landscape comparative analysis export
This query exports a dataset tracking the evolution of AI regulations and ethical guidelines.
params = {
"title": "AI regulation,AI governance,AI legislation",
"topic.id": "industry.ai_news",
"category.id": "medtop:04000000",
"language.code": "en",
"sort.by": "published_at",
"is_duplicate": "0",
"export": "json",
"api_key": "YOUR_API_KEY"
}curl -X GET "https://api.apitube.io/v1/news/everything?title=AI%20regulation,AI%20governance,AI%20legislation&topic.id=industry.ai_news&category.id=medtop:04000000&language.code=en&sort.by=published_at&is_duplicate=0&export=json&api_key=YOUR_API_KEY" -o global_ai_regulation_analysis.json