Happy Flows

curl --location 'https://app.daloopa.com/api/v2/companies?keyword=AAPL' \
--header 'Authorization: Basic $(echo -n '[email protected]:abc123' | base64)'

[
  {
    "id": 2,
    "name": "Apple Inc.",
    "ticker": "AAPL",
    "industry_": "Technology Hardware, Storage and Peripherals",
    "sector_": "Information Technology",
    "companyidentifier_set": [
      {
        "identifier_type": "CIK",
        "identifier_value": "320193"
      },
      {
        "identifier_type": "CapIQCompanyId",
        "identifier_value": "24937"
      },
      {
        "identifier_type": "CapIQCompanyTicker",
        "identifier_value": "NasdaqGS:AAPL"
      },
      {
        "identifier_type": "CapIQCompanyId",
        "identifier_value": "IQ24937"
      },
      {
        "identifier_type": "ISIN",
        "identifier_value": "I_US0378331005"
      }
    ],
    "model_updated_at": "2026-02-02T12:12:38.482128Z",
    "earliest_quarter": "2012Q4",
    "latest_quarter": "2025Q4"
  }
]

curl --location 'https://app.daloopa.com/api/v2/companies/series?company_id=2&keywords=revenue&keywords=sales' \
--header 'Authorization: Basic $(echo -n '[email protected]:abc123' | base64)'

[
    {
      "id": 2467997,
      "full_series_name": "Income Statement | Net sales | Products"
    },
    {
      "id": 2467998,
      "full_series_name": "Income Statement | Net sales | Services"
    },
    {
      "id": 2467999,
      "full_series_name": "Income Statement | Total net sales"
    },
  ]

curl --location 'https://app.daloopa.com/api/v2/companies/fundamentals?company_id=2&periods=2024Q1&periods=2024Q2&series_ids=12345&series_ids=12346' \
--header 'Authorization: Basic $(echo -n '[email protected]:abc123' | base64)'

{
  "count": 2,
  "next": null,
  "previous": null,
  "results": [
    {
      "id": 95541471,
      "label": "Total net sales",
      "category": "Income Statement",
      "restated": false,
      "filing_type": "8-K",
      "series_id": 2467999,
      "title": "Income Statement | Total net sales",
      "value_raw": 90753,
      "value_normalized": 90753,
      "unit": "Million",
      "calendar_period": "2024Q1",
      "fiscal_period": "2024Q2",
      "span": "Quarterly",
      "fiscal_date": "2023-03-30",
      "document_id": 25165413,
      "filing_date": "2024-05-02",
      "document_released_at": "2024-05-02T20:30:34Z",
      "created_at": "2024-05-02T20:33:56.013697Z",
      "updated_at": "2026-02-02T12:12:56.284556Z"
    },
    {
      "id": 102519304,
      "label": "Total net sales",
      "category": "Income Statement",
      "restated": false,
      "filing_type": "8-K",
      "series_id": 2467999,
      "title": "Income Statement | Total net sales",
      "value_raw": 85777,
      "value_normalized": 85777,
      "unit": "Million",
      "calendar_period": "2024Q2",
      "fiscal_period": "2024Q3",
      "span": "Quarterly",
      "fiscal_date": "2024-06-29",
      "document_id": 26052485,
      "filing_date": "2024-08-01",
      "document_released_at": "2024-08-01T20:30:26Z",
      "created_at": "2024-08-01T20:40:09.417865Z",
      "updated_at": "2026-02-02T12:12:56.284616Z"
    }
  ]
}

curl --location 'https://app.daloopa.com/api/v2/series-continuation?company_id=2' \
--header 'Authorization: Basic $(echo -n '[email protected]:abc123' | base64)'

[
  {
    "old_series": [
      {
        "id": 303689,
        "full_series_name": "Other Breakdown | Purchases of equity securities by the issuer and affiliated purchasers | Total number of shares purchased | Period 2 | ASR 2",
        "created_at": "2020-10-15T11:42:27.469449Z"
      },
      {
        "id": 303685,
        "full_series_name": "Other Breakdown | Purchases of equity securities by the issuer and affiliated purchasers | Total number of shares purchased | Period 1 | ASR 2",
        "created_at": "2020-10-15T11:42:26.131450Z"
      }
    ],
    "new_series": [
      {
        "id": 3544161,
        "full_series_name": "Other Breakdown | Purchases of equity securities by the issuer and affiliated purchasers | Total number of shares purchased | First month | ASR 2",
        "created_at": "2022-11-07T08:55:26.660085Z"
      },
      {
        "id": 3544162,
        "full_series_name": "Other Breakdown | Purchases of equity securities by the issuer and affiliated purchasers | Total number of shares purchased | Second month | ASR 2",
        "created_at": "2022-11-07T08:55:26.670273Z"
      }
    ],
    "type": "COMPOSITE",
    "created_at": "2022-11-07T08:55:28.392781Z"
  }
]

curl --location 'https://app.daloopa.com/api/v2/taxonomy/metrics?keyword=total%20revenue' \
--header 'Authorization: Basic $(echo -n '[email protected]:abc123' | base64)'

{
  "count": 8,
  "next": null,
  "previous": null,
  "results": [
    {
      "metric_id": 1617,
      "metric_name": "Total Revenue",
      "metric_description": "This metric measures the total amount of money a company earns from its business activities before any expenses are deducted, typically over a specific period such as a quarter or year."
    },
  ]
}

curl --location 'https://app.daloopa.com/api/v2/taxonomy/metrics/501' \
--header 'Authorization: Basic $(echo -n '[email protected]:abc123' | base64)'

{
  "metric_id": 1617,
  "metric_name": "Total Revenue",
  "metric_description": "This metric measures the total amount of money a company earns from its business activities before any expenses are deducted, typically over a specific period such as a quarter or year.",
  "metric_series": [
    {
       "company_id": 2,
       "ticker": "AAPL",
       "series_id": 2467999,
       "full_series_name": "Income Statement | Total net sales"
     },
    {
      "company_id": 135,
      "ticker": "MSFT",
      "series_id": 2542359,
      "full_series_name": "Income Statement | Total revenue"
    }
  ]
}

# For Apple
curl --location 'https://app.daloopa.com/api/v2/companies/fundamentals?company_id=2&periods=2024Q1&periods=2024Q2&series_ids=2467999' \
--header 'Authorization: Basic $(echo -n '[email protected]:abc123' | base64)'

# For Microsoft
curl --location 'https://app.daloopa.com/api/v2/companies/fundamentals?company_id=135&periods=2024Q1&periods=2024Q2&series_ids=2542359' \
--header 'Authorization: Basic $(echo -n '[email protected]:abc123' | base64)'

{
  "event_type": "clientview_updated",
  "company_id": 2,
  "series": {
    "SERIES_ID_1": {
      "periods": [
        "2025Q1"
      ]
    },
    "SERIES_ID_2": {
      "periods": [
        "2025Q1"
      ]
    }
  }
}

curl --location --request POST 'https://app.daloopa.com/api/v2/companies/status' \
--header 'Authorization: Basic $(echo -n '[email protected]:abc123' | base64)' \
--header 'Content-Type: application/json' \
--data '{
  "company_ids": [2]
}'

[
  {
    "company_id": 2,
    "latest_datapoint_created_at": "2026-02-02T11:57:43.113262Z",
    "latest_period": "2025Q4",
    "model_updated_at": "2026-02-02T12:13:55.029076Z"
  }
]

curl --location 'https://app.daloopa.com/api/v2/export/AAPL' \
--header 'Authorization: Basic $(echo -n '[email protected]:abc123' | base64)' \
--output aapl_data.csv

curl --location 'https://app.daloopa.com/api/v2/export/MMM?real_time=true&show_historical_data=false' \
--header 'Authorization: Basic $(echo -n '[email protected]:abc123' | base64)' \
--output mmm_realtime.csv

curl --location 'https://app.daloopa.com/api/v2/download-company-model?company_id=2&model_type=company' \
--header 'Authorization: Basic $(echo -n '[email protected]:abc123' | base64)'

{
  "download_url": "https://daloopa-excel-model.s3.amazonaws.com/1031277.xlsx?AWSAccessKeyId=AKIAYH2MSS6UCWRAXJ23&Signature=XtKT7JwJYKSXOp3NPBl5tJWSRAw%3D&Expires=1770152604"
}

curl --location 'https://daloopa-models.s3.amazonaws.com/models/AAPL_model.xlsx?AWSAccessKeyId=...' \
--output AAPL_model.xlsx

curl --location 'https://app.daloopa.com/api/v2/taxonomy/sub-industries' \
--header 'Authorization: Basic $(echo -n '[email protected]:abc123' | base64)'

{
  "count": 220,
  "next": "http://app.daloopa.com/api/v2/taxonomy/sub-industries?limit=100&offset=100",
  "previous": null,
  "results": [
    {
      "sub_industry_id": 281,
      "sub_industry_name": "Cruise Lines",
      "industry_name": "Restaurants, Hotels & Leisure",
      "sub_sector_name": "Consumer Services",
      "sector_name": "Consumer Discretionary",
      "companies": [
        {
          "id": 312,
          "ticker": "CCL",
          "name": "Carnival Corp"
        },
        {
          "id": 508,
          "ticker": "NCLH",
          "name": "Norwegian Cruise Line Holdings Ltd."
        },
        {
          "id": 555,
          "ticker": "RCL",
          "name": "Royal Caribbean Cruises Ltd"
        }
      ]
	   }
  ]
}

curl --location 'https://app.daloopa.com/api/v2/taxonomy/metrics?sub_industry_id=281' \
--header 'Authorization: Basic $(echo -n '[email protected]:abc123' | base64)'

{
  "count": 69,
  "next": null,
  "previous": null,
  "results": [
    {
      "metric_id": 1558,
      "metric_name": "Passenger Revenue",
      "metric_description": "Total revenue generated from transporting passengers, excluding ancillary (e.g., fees, onboard add-ons) and cargo/freight revenues. Includes passenger ticket sales and related passenger-service revenues across passenger transportation operators (e.g., airlines, cruise lines)."
    },
    {
      "metric_id": 1560,
      "metric_name": "Operating Income",
      "metric_description": "Operating Income (Loss) represents the profit or loss a company generates from its core operating activities before non-operating items (e.g., interest and other financing costs/income) and income taxes. It is generally calculated as revenue (or net sales) minus operating costs and expenses (e.g., cost of goods/services, selling/general/administrative, R&D, depreciation and amortization, and other operating items), and may be presented as EBIT when interest is excluded by definition."
    },
 ]
}

# For Passenger Revenue
curl --request GET \
     --url 'https://app.daloopa.com/api/v2/taxonomy/metrics/1558?sub_industry_id=281' \
     --header 'Authorization: Basic YXBpLW1hcml6dUBwb2ludDcyLmNvbTp4cU84RFdNaFM5dkdzeWZ3SXI1cGVHMGFudUNXcGVMbThRelFzV1FYQW5WRnI3cjFHWHlEYUE=' \
     --header 'accept: application/json'

# For Operating Income
curl --request GET \
     --url 'https://app.daloopa.com/api/v2/taxonomy/metrics/1560?sub_industry_id=281' \
     --header 'Authorization: Basic YXBpLW1hcml6dUBwb2ludDcyLmNvbTp4cU84RFdNaFM5dkdzeWZ3SXI1cGVHMGFudUNXcGVMbThRelFzV1FYQW5WRnI3cjFHWHlEYUE=' \
     --header 'accept: application/json'

{
  "count": 69,
  "next": null,
  "previous": null,
  "results": [
    {
      "metric_id": 1558,
      "metric_name": "Passenger Revenue",
      "metric_description": "Total revenue generated from transporting passengers, excluding ancillary (e.g., fees, onboard add-ons) and cargo/freight revenues. Includes passenger ticket sales and related passenger-service revenues across passenger transportation operators (e.g., airlines, cruise lines)."
    },
    {
      "metric_id": 1560,
      "metric_name": "Operating Income",
      "metric_description": "Operating Income (Loss) represents the profit or loss a company generates from its core operating activities before non-operating items (e.g., interest and other financing costs/income) and income taxes. It is generally calculated as revenue (or net sales) minus operating costs and expenses (e.g., cost of goods/services, selling/general/administrative, R&D, depreciation and amortization, and other operating items), and may be presented as EBIT when interest is excluded by definition."
    },
 ]
}

# For CCL
curl --location 'https://app.daloopa.com/api/v2/companies/fundamentals?company_id=312&periods=2024Q1&periods=2024Q2&series_ids=2729066&series_ids=2729081' \
--header 'Authorization: Basic $(echo -n '[email protected]:abc123' | base64)'

# For NCLH
curl --location 'https://app.daloopa.com/api/v2/companies/fundamentals?company_id=508&periods=2024Q1&periods=2024Q2&series_ids=1866377&series_ids=1866391' \
--header 'Authorization: Basic $(echo -n '[email protected]:abc123' | base64)'

# For RCL
curl --location 'https://app.daloopa.com/api/v2/companies/fundamentals?company_id=555&periods=2024Q1&periods=2024Q2&series_ids=2865083&series_ids=2865097' \
--header 'Authorization: Basic $(echo -n '[email protected]:abc123' | base64)'

curl --location 'https://app.daloopa.com/api/v2/documents/search?keyword=cybersecurity' \
--header 'Authorization: Basic $(echo -n '[email protected]:abc123' | base64)'

{
  "success": true,
  "total_hits": 11,
  "documents": [
    {
      "document_id": "23465209",
      "company_id": 2,
      "filing_type": "PRIVATE",
      "affinitized_date": "2022-12-31",
      "document_title": "c3f1ec093cb388c4282baebcce982bf2",
      "score": 0.9860914,
      "matches": [
        {
          "keyword": "guidance",
          "indexed_position": "24187-24195",
          "context": "[...] ncertainty around the world in the near term, we are not providing revenue guidance, but we are sharing some directional insights based on the assumption that [...]",
          "match_id": "eyJkb2N1bWVudF9pZCI6ICIyMzQ2NTIwOSIsICJlbmQiOiAyNDE5NSwgImtleXdvcmQiOiAiZ3VpZGFuY2UiLCAic3RhcnQiOiAyNDE4N30="
        },
      ]
    }
  ],
  "offset": 0,
  "limit": 10
}

curl --location 'https://app.daloopa.com/api/v2/companies/2/documents?filing_type=10-Q&fiscal_period=2024Q2' \
--header 'Authorization: Basic $(echo -n '[email protected]:abc123' | base64)'

{
  "company_id": 2,
  "ticker": "AAPL",
  "documents": [
    {
      "document_id": 789012,
      "filing_type": "10-Q",
      "fiscal_period": "2024Q2",
      "filing_date": "2024-05-03",
      "url": "https://daloopa.com/documents/789012"
    }
  ]
}

curl --location 'https://app.daloopa.com/api/v2/documents/789012' \
--header 'Authorization: Basic $(echo -n '[email protected]:abc123' | base64)'

{
  "document_id": 789012,
  "company_id": 2,
  "ticker": "AAPL",
  "filing_type": "10-Q",
  "fiscal_period": "2024Q2",
  "filing_date": "2024-05-03",
  "content": "Full document text...",
  "source_url": "https://www.sec.gov/..."
}