Export Query Examples

Export data as JSON

This query exports news articles as JSON format.

params = {
    "category.id": "2",
    "published_at.start": "2023-01-01",
    "export": "json",
    "api_key": "YOUR_API_KEY"
}

curl -X GET "https://api.apitube.io/v1/news/everything?category.id=2&published_at.start=2023-01-01&export=json&api_key=YOUR_API_KEY" -o financial_news.json

Export data as XML

This query exports news articles as XML format.

params = {
    "category.id": "2",
    "published_at.start": "2023-01-01",
    "export": "xml",
    "api_key": "YOUR_API_KEY"
}

curl -X GET "https://api.apitube.io/v1/news/everything?category.id=2&published_at.start=2023-01-01&export=xml&api_key=YOUR_API_KEY" -o financial_news.xml

Export data as XLSX

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

params = {
    "category.id": "2",
    "published_at.start": "2023-01-01",
    "export": "xlsx",
    "api_key": "YOUR_API_KEY"
}

curl -X GET "https://api.apitube.io/v1/news/everything?category.id=2&published_at.start=2023-01-01&export=xlsx&api_key=YOUR_API_KEY" -o financial_news.xlsx

Export data as CSV

This query exports news articles as CSV format.

params = {
    "category.id": "2",
    "published_at.start": "2023-01-01",
    "export": "csv",
    "api_key": "YOUR_API_KEY"
}

curl -X GET "https://api.apitube.io/v1/news/everything?category.id=2&published_at.start=2023-01-01&export=csv&api_key=YOUR_API_KEY" -o financial_news.csv

Export data as TSV

This query exports news articles as TSV format.

params = {
    "category.id": "2",
    "published_at.start": "2023-01-01",
    "export": "tsv",
    "api_key": "YOUR_API_KEY"
}

curl -X GET "https://api.apitube.io/v1/news/everything?category.id=2&published_at.start=2023-01-01&export=tsv&api_key=YOUR_API_KEY" -o financial_news.tsv

Data export for financial analysis

This query exports financial news from 2023 in Excel format for analysis.

params = {
    "category.id": "2",
    "published_at.start": "2023-01-01",
    "published_at.end": "2023-12-31",
    "export": "xlsx",
    "api_key": "YOUR_API_KEY"
}

curl -X GET "https://api.apitube.io/v1/news/everything?category.id=2&published_at.start=2023-01-01&published_at.end=2023-12-31&export=xlsx&api_key=YOUR_API_KEY" -o financial_news_2023.xlsx

CSV export for sentiment analysis

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

params = {
    "organization.name": "Amazon,Microsoft,Google",
    "published_at.start": "2023-01-01",
    "published_at.end": "2023-12-31",
    "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&published_at.start=2023-01-01&published_at.end=2023-12-31&sort.by=sentiment.overall.score&sort.order=desc&export=csv&api_key=YOUR_API_KEY" -o tech_sentiment_2023.csv

Cross-market ESG reporting comparative analysis export

This query exports a comprehensive dataset for comparative analysis of ESG (Environmental, Social, Governance) reporting trends across different markets and industries, enabling detailed sustainability performance benchmarking.

params = {
    "title": "ESG,sustainability,climate,governance,social responsibility",
    "category.id": "2,4,9",
    "source.country.code": "us,uk,de,fr,jp,cn",
    "source.rank.opr.min": "0.8",
    "published_at.start": "2022-01-01",
    "published_at.end": "2023-12-31",
    "sort.by": "source.country.code,category.id,sentiment.overall.score",
    "is_duplicate": "0",
    "per_page": "200",
    "export": "xlsx",
    "api_key": "YOUR_API_KEY"
}

curl -X GET "https://api.apitube.io/v1/news/everything?title=ESG,sustainability,climate,governance,social%20responsibility&category.id=2,4,9&source.country.code=us,uk,de,fr,jp,cn&source.rank.opr.min=0.8&published_at.start=2022-01-01&published_at.end=2023-12-31&sort.by=source.country.code,category.id,sentiment.overall.score&is_duplicate=0&per_page=200&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 across multiple high-quality sources, enabling longitudinal analysis of drug development trends, regulatory impacts, and market reactions.

params = {
    "title": "clinical trial,FDA approval,EMA,drug development,breakthrough,pharmaceutical innovation",
    "organization.name": "Pfizer,Moderna,AstraZeneca,Johnson&Johnson,Merck,Novartis,Roche",
    "category.id": "2,4,9",
    "source.rank.opr.min": "0.75",
    "language.code": "en",
    "published_at.start": "2020-01-01",
    "published_at.end": "2023-12-31",
    "sort.by": "organization.name,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%20approval,EMA,drug%20development,breakthrough,pharmaceutical%20innovation&organization.name=Pfizer,Moderna,AstraZeneca,Johnson&Johnson,Merck,Novartis,Roche&category.id=2,4,9&source.rank.opr.min=0.75&language.code=en&published_at.start=2020-01-01&published_at.end=2023-12-31&sort.by=organization.name,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, facilitating assessment of reporting biases, narrative framing, and sentiment variations across different media ecosystems.

params = {
    "title": "conflict,crisis,war,peace,negotiation,diplomacy",
    "location.name": "Gaza,Israel,Taiwan,China",
    "category.id": "3",
    "source.country.code": "us,gb,fr,de,cn,in",
    "language.code": "en",
    "published_at.start": "2022-02-01",
    "published_at.end": "2023-12-31",
    "sort.by": "location.name,source.country.code,published_at",
    "is_duplicate": "0",
    "per_page": "500",
    "export": "xlsx",
    "api_key": "YOUR_API_KEY"
}

curl -X GET "https://api.apitube.io/v1/news/everything?title=conflict,crisis,war,peace,negotiation,diplomacy&location.name=Gaza,Israel,Taiwan,China&category.id=3&source.country.code=us,gb,fr,de,cn,in&language.code=en&published_at.start=2022-02-01&published_at.end=2023-12-31&sort.by=location.name,source.country.code,published_at&is_duplicate=0&per_page=500&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 across different jurisdictions and industries, supporting cross-regional benchmarking and compliance planning.

params = {
    "title": "AI regulation,ethical AI,responsible AI,AI governance,AI legislation,algorithm bias",
    "topic.id": "artificial_intelligence,machine_learning",
    "category.id": "2,3,4",
    "source.country.code": "us,eu,uk,cn,jp,in,sg",
    "source.rank.opr.min": "0.7",
    "language.code": "en",
    "published_at.start": "2021-01-01",
    "published_at.end": "2023-12-31",
    "sort.by": "source.country.code,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,ethical%20AI,responsible%20AI,AI%20governance,AI%20legislation,algorithm%20bias&topic.id=artificial_intelligence,machine_learning&category.id=2,3,4&source.country.code=us,eu,uk,cn,jp,in,sg&source.rank.opr.min=0.7&language.code=en&published_at.start=2021-01-01&published_at.end=2023-12-31&sort.by=source.country.code,published_at&is_duplicate=0&export=json&api_key=YOUR_API_KEY" -o global_ai_regulation_analysis.json