call_api
Fetch data from a Massive.com REST API endpoint and optionally store results as a table for SQL querying or apply built-in functions for post-processing.
Instructions
Fetch data from a Massive.com REST API endpoint. Use a path from search_endpoints results. Set store_as to save results as an in-memory table for SQL querying with query_data. Paginated responses include a next-page hint with the exact path and params for the follow-up request. The apply parameter runs built-in functions on results — string input values refer to table columns, numeric values are literals. Use search_endpoints with scope="functions" to discover available functions.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| path | Yes | API endpoint path (e.g., /v2/aggs/ticker/AAPL/range/1/day/2024-01-01/2024-01-31) | |
| apply | No | List of function steps to post-process results. Each step: {"function": "name", "inputs": {...}, "output": "col_name"} | |
| params | No | Query parameters as key-value pairs | |
| api_key | No | API key for this request. Overrides the server's default key. | |
| store_as | No | Table name to store results as a DataFrame for SQL querying (e.g. 'prices') |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |