Skip to content

Export Query Examples

Export data as JSON

This query exports news articles as JSON format.

python
params = {
    "category.id": "medtop:04000000",
    "export": "json",
    "api_key": "YOUR_API_KEY"
}
shell
curl -X GET "https://api.apitube.io/v1/news/everything?category.id=medtop:04000000&export=json&api_key=YOUR_API_KEY" -o financial_news.json

Export data as XML

This query exports news articles as XML format.

python
params = {
    "category.id": "medtop:04000000",
    "export": "xml",
    "api_key": "YOUR_API_KEY"
}
shell
curl -X GET "https://api.apitube.io/v1/news/everything?category.id=medtop:04000000&export=xml&api_key=YOUR_API_KEY" -o financial_news.xml

Export data as XLSX

This query exports news articles as XLSX (Excel) format.

python
params = {
    "category.id": "medtop:04000000",
    "export": "xlsx",
    "api_key": "YOUR_API_KEY"
}
shell
curl -X GET "https://api.apitube.io/v1/news/everything?category.id=medtop:04000000&export=xlsx&api_key=YOUR_API_KEY" -o financial_news.xlsx

Export data as CSV

This query exports news articles as CSV format.

python
params = {
    "category.id": "medtop:04000000",
    "export": "csv",
    "api_key": "YOUR_API_KEY"
}
shell
curl -X GET "https://api.apitube.io/v1/news/everything?category.id=medtop:04000000&export=csv&api_key=YOUR_API_KEY" -o financial_news.csv

Export data as TSV

This query exports news articles as TSV format.

python
params = {
    "category.id": "medtop:04000000",
    "export": "tsv",
    "api_key": "YOUR_API_KEY"
}
shell
curl -X GET "https://api.apitube.io/v1/news/everything?category.id=medtop:04000000&export=tsv&api_key=YOUR_API_KEY" -o financial_news.tsv

Data export for financial analysis

This query exports financial news in Excel format for analysis.

python
params = {
    "category.id": "medtop:04000000",
    "title": "finance,market,economy",
    "export": "xlsx",
    "api_key": "YOUR_API_KEY"
}
shell
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.xlsx

CSV export for sentiment analysis

This query exports sentiment data about major tech companies in CSV format.

python
params = {
    "organization.name": "Amazon,Microsoft,Google",
    "sort.by": "sentiment.overall.score",
    "sort.order": "desc",
    "export": "csv",
    "api_key": "YOUR_API_KEY"
}
shell
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.csv

Cross-market ESG reporting comparative analysis export

This query exports a comprehensive dataset for comparative analysis of ESG (Environmental, Social, Governance) reporting trends.

python
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"
}
shell
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.xlsx

Multi-source pharmaceutical innovation tracking export

This query exports a dataset tracking pharmaceutical innovations and clinical trials.

python
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"
}
shell
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.csv

Geopolitical crisis media coverage analysis export

This query exports a comprehensive dataset for analyzing media coverage patterns during major geopolitical crises.

python
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"
}
shell
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.xlsx

AI regulatory landscape comparative analysis export

This query exports a dataset tracking the evolution of AI regulations and ethical guidelines.

python
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"
}
shell
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