[![FactSet](https://raw.githubusercontent.com/factset/enterprise-sdk/main/docs/images/factset-logo.svg)](https://www.factset.com)
# Formula client library for Python
[![API Version](https://img.shields.io/badge/api-v1.8.0-blue)](https://developer.factset.com/api-catalog/formula-api)
[![PyPi](https://img.shields.io/pypi/v/fds.sdk.Formula)](https://pypi.org/project/fds.sdk.Formula/)
[![Apache-2 license](https://img.shields.io/badge/license-Apache2-brightgreen.svg)](https://www.apache.org/licenses/LICENSE-2.0)
**FactSet Formula API**
FactSet’s Formula API is a modern, flexible, formula-based API that enables users to access FactSet’s wide range of financial data and content. The API offers two endpoints, one optimized for time-series analysis and one designed for cross-sectional analysis, providing users a simplified interface into FactSet’s expansive offering. By providing two endpoints, it allows for the optimization of user workflows, while reducing complexity.
Leverage the power and flexibility of the Formula API to -
* Pull data from across most content sets that a user has access to in a single request
* Include business logic and mathematical operations in request
* Submit a dynamic universe in both endpoints
* Return the fsymId to easily combine with other FactSet content / products
* Set the trading calendar
* Define custom display names
**Formula API Request Builder**
The Formula API Request Builder provides users everything they need to form a Formula API request. In the Request Builder, you can select identifiers, build a universe expression, select FQL or Screening formulas, easily apply business logic and mathematical functions to the FQL or Screening formulas, specify optional parameters, and construct a GET or POST request. The Request Builder eliminates the need to have previous FQL and Screening knowledge and allows you to quickly find your desired data items and form the request.
The Formula API Request Builder can be accessed by navigating to [https://developer.factset.com/formula-api-request-builder](https://developer.factset.com/formula-api-request-builder) and logging in using your FactSet.net ID. When using the Request Builder to construct requests for the one of the Formula API's endpoints, be sure to toggle to the correct endpoint at the top of the page.
**How to Check the Health and Availability of the Formula API**
Please use the below endpoint to check the health and availability of the Formula API. You must be authorized for this API to use the Health endpoint.
[https://api.factset.com/formula-api/health](https://api.factset.com/formula-api/health)
**How to Programmatically Download API Specification File**
You can download the FactSet Formula API Specification File in .yaml. using the \"Download Spec\" button to the right of the version number. This specification can then be used for Codegen to create your own SDKs.
This Python package is automatically generated by the [OpenAPI Generator](https://openapi-generator.tech) project:
- API version: 1.8.0
- SDK version: 3.0.1
- Build package: org.openapitools.codegen.languages.PythonClientCodegen
For more information, please visit [https://developer.factset.com/contact](https://developer.factset.com/contact)
## Requirements
* Python >= 3.7
## Installation
### Poetry
```shell
poetry add fds.sdk.utils fds.sdk.Formula==3.0.1
```
### pip
```shell
pip install fds.sdk.utils fds.sdk.Formula==3.0.1
```
## Usage
1. [Generate authentication credentials](../../../../README.md#authentication).
2. Setup Python environment.
1. Install and activate python 3.7+. If you're using [pyenv](https://github.com/pyenv/pyenv):
```sh
pyenv install 3.9.7
pyenv shell 3.9.7
```
2. (optional) [Install poetry](https://python-poetry.org/docs/#installation).
3. [Install dependencies](#installation).
4. Run the following:
> [!IMPORTANT]
> The parameter variables defined below are just examples and may potentially contain non valid values. Please replace them with valid values.
### Example Code
```python
from fds.sdk.utils.authentication import ConfidentialClient
import fds.sdk.Formula
from fds.sdk.Formula.api import batch_processing_api
from fds.sdk.Formula.models import *
from dateutil.parser import parse as dateutil_parser
from pprint import pprint
# See configuration.py for a list of all supported configuration parameters.
# Examples for each supported authentication method are below,
# choose one that satisfies your use case.
# (Preferred) OAuth 2.0: FactSetOAuth2
# See https://github.com/FactSet/enterprise-sdk#oauth-20
# for information on how to create the app-config.json file
#
# The confidential client instance should be reused in production environments.
# See https://github.com/FactSet/enterprise-sdk-utils-python#authentication
# for more information on using the ConfidentialClient class
configuration = fds.sdk.Formula.Configuration(
fds_oauth_client=ConfidentialClient('/path/to/app-config.json')
)
# Basic authentication: FactSetApiKey
# See https://github.com/FactSet/enterprise-sdk#api-key
# for information how to create an API key
# configuration = fds.sdk.Formula.Configuration(
# username='USERNAME-SERIAL',
# password='API-KEY'
# )
# Enter a context with an instance of the API client
with fds.sdk.Formula.ApiClient(configuration) as api_client:
# Create an instance of the API class
api_instance = batch_processing_api.BatchProcessingApi(api_client)
id = "id_example" # str | Batch Request identifier.
try:
# Returns the response for a Batch Request
# example passing only required values which don't have defaults set
api_response_wrapper = api_instance.get_batch_data(id)
# This endpoint returns a response wrapper that contains different types of responses depending on the query.
# To access the correct response type, you need to perform one additional step, as shown below.
if api_response_wrapper.get_status_code() == 200:
api_response = api_response_wrapper.get_response_200()
if api_response_wrapper.get_status_code() == 202:
api_response = api_response_wrapper.get_response_202()
pprint(api_response)
except fds.sdk.Formula.ApiException as e:
print("Exception when calling BatchProcessingApi->get_batch_data: %s\n" % e)
# # Get response, http status code and response headers
# try:
# # Returns the response for a Batch Request
# api_response_wrapper, http_status_code, response_headers = api_instance.get_batch_data_with_http_info(id)
# # This endpoint returns a response wrapper that contains different types of responses depending on the query.
# # To access the correct response type, you need to perform one additional step, as shown below.
# if api_response_wrapper.get_status_code() == 200:
# api_response = api_response_wrapper.get_response_200()
# if api_response_wrapper.get_status_code() == 202:
# api_response = api_response_wrapper.get_response_202()
# pprint(api_response)
# pprint(http_status_code)
# pprint(response_headers)
# except fds.sdk.Formula.ApiException as e:
# print("Exception when calling BatchProcessingApi->get_batch_data: %s\n" % e)
# # Get response asynchronous
# try:
# # Returns the response for a Batch Request
# async_result = api_instance.get_batch_data_async(id)
# api_response_wrapper = async_result.get()
# # This endpoint returns a response wrapper that contains different types of responses depending on the query.
# # To access the correct response type, you need to perform one additional step, as shown below.
# if api_response_wrapper.get_status_code() == 200:
# api_response = api_response_wrapper.get_response_200()
# if api_response_wrapper.get_status_code() == 202:
# api_response = api_response_wrapper.get_response_202()
# pprint(api_response)
# except fds.sdk.Formula.ApiException as e:
# print("Exception when calling BatchProcessingApi->get_batch_data: %s\n" % e)
# # Get response, http status code and response headers asynchronous
# try:
# # Returns the response for a Batch Request
# async_result = api_instance.get_batch_data_with_http_info_async(id)
# api_response_wrapper, http_status_code, response_headers = async_result.get()
# # This endpoint returns a response wrapper that contains different types of responses depending on the query.
# # To access the correct response type, you need to perform one additional step, as shown below.
# if api_response_wrapper.get_status_code() == 200:
# api_response = api_response_wrapper.get_response_200()
# if api_response_wrapper.get_status_code() == 202:
# api_response = api_response_wrapper.get_response_202()
# pprint(api_response)
# pprint(http_status_code)
# pprint(response_headers)
# except fds.sdk.Formula.ApiException as e:
# print("Exception when calling BatchProcessingApi->get_batch_data: %s\n" % e)
```
### Using Pandas
To convert an API response to a Pandas DataFrame, it is necessary to transform it first to a dictionary.
```python
import pandas as pd
response_dict = api_response.to_dict()['data']
simple_json_response = pd.DataFrame(response_dict)
nested_json_response = pd.json_normalize(response_dict)
```
### Debugging
The SDK uses the standard library [`logging`](https://docs.python.org/3/library/logging.html#module-logging) module.
Setting `debug` to `True` on an instance of the `Configuration` class sets the log-level of related packages to `DEBUG`
and enables additional logging in Pythons [HTTP Client](https://docs.python.org/3/library/http.client.html).
**Note**: This prints out sensitive information (e.g. the full request and response). Use with care.
```python
import logging
import fds.sdk.Formula
logging.basicConfig(level=logging.DEBUG)
configuration = fds.sdk.Formula.Configuration(...)
configuration.debug = True
```
### Configure a Proxy
You can pass proxy settings to the Configuration class:
* `proxy`: The URL of the proxy to use.
* `proxy_headers`: a dictionary to pass additional headers to the proxy (e.g. `Proxy-Authorization`).
```python
import fds.sdk.Formula
configuration = fds.sdk.Formula.Configuration(
# ...
proxy="http://secret:password@localhost:5050",
proxy_headers={
"Custom-Proxy-Header": "Custom-Proxy-Header-Value"
}
)
```
### Custom SSL Certificate
TLS/SSL certificate verification can be configured with the following Configuration parameters:
* `ssl_ca_cert`: a path to the certificate to use for verification in `PEM` format.
* `verify_ssl`: setting this to `False` disables the verification of certificates.
Disabling the verification is not recommended, but it might be useful during
local development or testing.
```python
import fds.sdk.Formula
configuration = fds.sdk.Formula.Configuration(
# ...
ssl_ca_cert='/path/to/ca.pem'
)
```
### Request Retries
In case the request retry behaviour should be customized, it is possible to pass a `urllib3.Retry` object to the `retry` property of the Configuration.
```python
from urllib3 import Retry
import fds.sdk.Formula
configuration = fds.sdk.Formula.Configuration(
# ...
)
configuration.retries = Retry(total=3, status_forcelist=[500, 502, 503, 504])
```
## Documentation for API Endpoints
All URIs are relative to *https://api.factset.com/formula-api/v1*
Class | Method | HTTP request | Description
------------ | ------------- | ------------- | -------------
*BatchProcessingApi* | [**get_batch_data**](https://github.com/FactSet/enterprise-sdk/tree/main/code/python/Formula/v1/docs/BatchProcessingApi.md#get_batch_data) | **GET** /batch-result | Returns the response for a Batch Request
*BatchProcessingApi* | [**get_batch_data_with_post**](https://github.com/FactSet/enterprise-sdk/tree/main/code/python/Formula/v1/docs/BatchProcessingApi.md#get_batch_data_with_post) | **POST** /batch-result | Returns the status for a Batch Request
*BatchProcessingApi* | [**get_batch_status**](https://github.com/FactSet/enterprise-sdk/tree/main/code/python/Formula/v1/docs/BatchProcessingApi.md#get_batch_status) | **GET** /batch-status | Returns the status for a Batch Request
*BatchProcessingApi* | [**get_batch_status_with_post**](https://github.com/FactSet/enterprise-sdk/tree/main/code/python/Formula/v1/docs/BatchProcessingApi.md#get_batch_status_with_post) | **POST** /batch-status | Returns the status for a Batch Request
*CrossSectionalApi* | [**get_cross_sectional_data**](https://github.com/FactSet/enterprise-sdk/tree/main/code/python/Formula/v1/docs/CrossSectionalApi.md#get_cross_sectional_data) | **GET** /cross-sectional | Retrieve data items (Screening formulas) for a list of identifiers or defined universe.
*CrossSectionalApi* | [**get_cross_sectional_data_for_list**](https://github.com/FactSet/enterprise-sdk/tree/main/code/python/Formula/v1/docs/CrossSectionalApi.md#get_cross_sectional_data_for_list) | **POST** /cross-sectional | Retrieve data items (Screening formulas) for a list of identifiers or defined universe.
*TimeSeriesApi* | [**get_time_series_data**](https://github.com/FactSet/enterprise-sdk/tree/main/code/python/Formula/v1/docs/TimeSeriesApi.md#get_time_series_data) | **GET** /time-series | Retrieve data items (FQL formulas) for a list of identifiers or defined universe.
*TimeSeriesApi* | [**get_time_series_data_for_list**](https://github.com/FactSet/enterprise-sdk/tree/main/code/python/Formula/v1/docs/TimeSeriesApi.md#get_time_series_data_for_list) | **POST** /time-series | Retrieve data items (FQL formulas) for a list of identifiers or defined universe.
## Documentation For Models
- [BatchData](https://github.com/FactSet/enterprise-sdk/tree/main/code/python/Formula/v1/docs/BatchData.md)
- [BatchDataRequest](https://github.com/FactSet/enterprise-sdk/tree/main/code/python/Formula/v1/docs/BatchDataRequest.md)
- [BatchDataRequestData](https://github.com/FactSet/enterprise-sdk/tree/main/code/python/Formula/v1/docs/BatchDataRequestData.md)
- [BatchDataResponse](https://github.com/FactSet/enterprise-sdk/tree/main/code/python/Formula/v1/docs/BatchDataResponse.md)
- [BatchStatus](https://github.com/FactSet/enterprise-sdk/tree/main/code/python/Formula/v1/docs/BatchStatus.md)
- [BatchStatusResponse](https://github.com/FactSet/enterprise-sdk/tree/main/code/python/Formula/v1/docs/BatchStatusResponse.md)
- [CrossSectionalRequest](https://github.com/FactSet/enterprise-sdk/tree/main/code/python/Formula/v1/docs/CrossSectionalRequest.md)
- [CrossSectionalRequestData](https://github.com/FactSet/enterprise-sdk/tree/main/code/python/Formula/v1/docs/CrossSectionalRequestData.md)
- [CrossSectionalResponse](https://github.com/FactSet/enterprise-sdk/tree/main/code/python/Formula/v1/docs/CrossSectionalResponse.md)
- [CrossSectionalResponseObjectItems](https://github.com/FactSet/enterprise-sdk/tree/main/code/python/Formula/v1/docs/CrossSectionalResponseObjectItems.md)
- [CrossSectionalResultObjectFlattened](https://github.com/FactSet/enterprise-sdk/tree/main/code/python/Formula/v1/docs/CrossSectionalResultObjectFlattened.md)
- [CrossSectionalResultObjectFlattenedAddl](https://github.com/FactSet/enterprise-sdk/tree/main/code/python/Formula/v1/docs/CrossSectionalResultObjectFlattenedAddl.md)
- [CrossSectionalResultObjectNonflattened](https://github.com/FactSet/enterprise-sdk/tree/main/code/python/Formula/v1/docs/CrossSectionalResultObjectNonflattened.md)
- [CrossSectionalResultObjectNonflattenedResultAttribute](https://github.com/FactSet/enterprise-sdk/tree/main/code/python/Formula/v1/docs/CrossSectionalResultObjectNonflattenedResultAttribute.md)
- [ErrorDetail](https://github.com/FactSet/enterprise-sdk/tree/main/code/python/Formula/v1/docs/ErrorDetail.md)
- [ErrorObject](https://github.com/FactSet/enterprise-sdk/tree/main/code/python/Formula/v1/docs/ErrorObject.md)
- [TimeSeriesRequest](https://github.com/FactSet/enterprise-sdk/tree/main/code/python/Formula/v1/docs/TimeSeriesRequest.md)
- [TimeSeriesRequestData](https://github.com/FactSet/enterprise-sdk/tree/main/code/python/Formula/v1/docs/TimeSeriesRequestData.md)
- [TimeSeriesResponse](https://github.com/FactSet/enterprise-sdk/tree/main/code/python/Formula/v1/docs/TimeSeriesResponse.md)
- [TimeSeriesResponseObjectItems](https://github.com/FactSet/enterprise-sdk/tree/main/code/python/Formula/v1/docs/TimeSeriesResponseObjectItems.md)
- [TimeSeriesResultObjectFlattened](https://github.com/FactSet/enterprise-sdk/tree/main/code/python/Formula/v1/docs/TimeSeriesResultObjectFlattened.md)
- [TimeSeriesResultObjectFlattenedAddl](https://github.com/FactSet/enterprise-sdk/tree/main/code/python/Formula/v1/docs/TimeSeriesResultObjectFlattenedAddl.md)
- [TimeSeriesResultObjectNonflattened](https://github.com/FactSet/enterprise-sdk/tree/main/code/python/Formula/v1/docs/TimeSeriesResultObjectNonflattened.md)
- [TimeSeriesResultObjectNonflattenedArray](https://github.com/FactSet/enterprise-sdk/tree/main/code/python/Formula/v1/docs/TimeSeriesResultObjectNonflattenedArray.md)
- [TimeSeriesResultObjectNonflattenedBase](https://github.com/FactSet/enterprise-sdk/tree/main/code/python/Formula/v1/docs/TimeSeriesResultObjectNonflattenedBase.md)
- [TimeSeriesResultObjectNonflattenedMatrix](https://github.com/FactSet/enterprise-sdk/tree/main/code/python/Formula/v1/docs/TimeSeriesResultObjectNonflattenedMatrix.md)
- [TimeSeriesResultObjectNonflattenedScalar](https://github.com/FactSet/enterprise-sdk/tree/main/code/python/Formula/v1/docs/TimeSeriesResultObjectNonflattenedScalar.md)
- [TimeSeriesResultObjectNonflattenedTimeseriesObject](https://github.com/FactSet/enterprise-sdk/tree/main/code/python/Formula/v1/docs/TimeSeriesResultObjectNonflattenedTimeseriesObject.md)
- [TimeSeriesScalarValue](https://github.com/FactSet/enterprise-sdk/tree/main/code/python/Formula/v1/docs/TimeSeriesScalarValue.md)
- [TimeSeriesTimeseriesObject](https://github.com/FactSet/enterprise-sdk/tree/main/code/python/Formula/v1/docs/TimeSeriesTimeseriesObject.md)
- [WarningsObject](https://github.com/FactSet/enterprise-sdk/tree/main/code/python/Formula/v1/docs/WarningsObject.md)
## Documentation For Authorization
## FactSetApiKey
- **Type**: HTTP basic authentication
## FactSetOAuth2
- **Type**: OAuth
- **Flow**: application
- **Authorization URL**:
- **Scopes**: N/A
## Notes for Large OpenAPI documents
If the OpenAPI document is large, imports in fds.sdk.Formula.apis and fds.sdk.Formula.models may fail with a
RecursionError indicating the maximum recursion limit has been exceeded. In that case, there are a couple of solutions:
Solution 1:
Use specific imports for apis and models like:
- `from fds.sdk.Formula.api.default_api import DefaultApi`
- `from fds.sdk.Formula.model.pet import Pet`
Solution 2:
Before importing the package, adjust the maximum recursion limit as shown below:
```
import sys
sys.setrecursionlimit(1500)
import fds.sdk.Formula
from fds.sdk.Formula.apis import *
from fds.sdk.Formula.models import *
```
## Contributing
Please refer to the [contributing guide](../../../../CONTRIBUTING.md).
## Copyright
Copyright 2022 FactSet Research Systems Inc
Licensed under the Apache License, Version 2.0 (the "License");
you may not use this file except in compliance with the License.
You may obtain a copy of the License at
http://www.apache.org/licenses/LICENSE-2.0
Unless required by applicable law or agreed to in writing, software
distributed under the License is distributed on an "AS IS" BASIS,
WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
See the License for the specific language governing permissions and
limitations under the License.
Raw data
{
"_id": null,
"home_page": "https://github.com/FactSet/enterprise-sdk/tree/main/code/python/Formula/v1",
"name": "fds.sdk.Formula",
"maintainer": null,
"docs_url": null,
"requires_python": ">=3.7",
"maintainer_email": null,
"keywords": "FactSet, API, SDK",
"author": "FactSet Research Systems",
"author_email": null,
"download_url": "https://files.pythonhosted.org/packages/20/95/3a71f3124af97e6048af9b4e690584c0bc157d003626e18f8f9c99bde5eb/fds.sdk.Formula-3.0.1.tar.gz",
"platform": null,
"description": "[![FactSet](https://raw.githubusercontent.com/factset/enterprise-sdk/main/docs/images/factset-logo.svg)](https://www.factset.com)\n\n# Formula client library for Python\n\n[![API Version](https://img.shields.io/badge/api-v1.8.0-blue)](https://developer.factset.com/api-catalog/formula-api)\n[![PyPi](https://img.shields.io/pypi/v/fds.sdk.Formula)](https://pypi.org/project/fds.sdk.Formula/)\n[![Apache-2 license](https://img.shields.io/badge/license-Apache2-brightgreen.svg)](https://www.apache.org/licenses/LICENSE-2.0)\n\n\n**FactSet Formula API**\n\nFactSet\u2019s Formula API is a modern, flexible, formula-based API that enables users to access FactSet\u2019s wide range of financial data and content. The API offers two endpoints, one optimized for time-series analysis and one designed for cross-sectional analysis, providing users a simplified interface into FactSet\u2019s expansive offering. By providing two endpoints, it allows for the optimization of user workflows, while reducing complexity.\n\nLeverage the power and flexibility of the Formula API to -\n * Pull data from across most content sets that a user has access to in a single request\n * Include business logic and mathematical operations in request\n * Submit a dynamic universe in both endpoints\n * Return the fsymId to easily combine with other FactSet content / products\n * Set the trading calendar\n * Define custom display names\n\n**Formula API Request Builder**\n\nThe Formula API Request Builder provides users everything they need to form a Formula API request. In the Request Builder, you can select identifiers, build a universe expression, select FQL or Screening formulas, easily apply business logic and mathematical functions to the FQL or Screening formulas, specify optional parameters, and construct a GET or POST request. The Request Builder eliminates the need to have previous FQL and Screening knowledge and allows you to quickly find your desired data items and form the request.\n\nThe Formula API Request Builder can be accessed by navigating to [https://developer.factset.com/formula-api-request-builder](https://developer.factset.com/formula-api-request-builder) and logging in using your FactSet.net ID. When using the Request Builder to construct requests for the one of the Formula API's endpoints, be sure to toggle to the correct endpoint at the top of the page.\n\n**How to Check the Health and Availability of the Formula API**\n\nPlease use the below endpoint to check the health and availability of the Formula API. You must be authorized for this API to use the Health endpoint.\n\n[https://api.factset.com/formula-api/health](https://api.factset.com/formula-api/health)\n\n**How to Programmatically Download API Specification File**\n\nYou can download the FactSet Formula API Specification File in .yaml. using the \\\"Download Spec\\\" button to the right of the version number. This specification can then be used for Codegen to create your own SDKs.\n\n\nThis Python package is automatically generated by the [OpenAPI Generator](https://openapi-generator.tech) project:\n\n- API version: 1.8.0\n- SDK version: 3.0.1\n- Build package: org.openapitools.codegen.languages.PythonClientCodegen\n\nFor more information, please visit [https://developer.factset.com/contact](https://developer.factset.com/contact)\n\n## Requirements\n\n* Python >= 3.7\n\n## Installation\n\n### Poetry\n\n```shell\npoetry add fds.sdk.utils fds.sdk.Formula==3.0.1\n```\n\n### pip\n\n```shell\npip install fds.sdk.utils fds.sdk.Formula==3.0.1\n```\n\n## Usage\n\n1. [Generate authentication credentials](../../../../README.md#authentication).\n2. Setup Python environment.\n 1. Install and activate python 3.7+. If you're using [pyenv](https://github.com/pyenv/pyenv):\n\n ```sh\n pyenv install 3.9.7\n pyenv shell 3.9.7\n ```\n\n 2. (optional) [Install poetry](https://python-poetry.org/docs/#installation).\n3. [Install dependencies](#installation).\n4. Run the following:\n\n> [!IMPORTANT]\n> The parameter variables defined below are just examples and may potentially contain non valid values. Please replace them with valid values.\n\n### Example Code\n\n```python\nfrom fds.sdk.utils.authentication import ConfidentialClient\n\nimport fds.sdk.Formula\nfrom fds.sdk.Formula.api import batch_processing_api\nfrom fds.sdk.Formula.models import *\nfrom dateutil.parser import parse as dateutil_parser\nfrom pprint import pprint\n\n# See configuration.py for a list of all supported configuration parameters.\n\n# Examples for each supported authentication method are below,\n# choose one that satisfies your use case.\n\n# (Preferred) OAuth 2.0: FactSetOAuth2\n# See https://github.com/FactSet/enterprise-sdk#oauth-20\n# for information on how to create the app-config.json file\n#\n# The confidential client instance should be reused in production environments.\n# See https://github.com/FactSet/enterprise-sdk-utils-python#authentication\n# for more information on using the ConfidentialClient class\nconfiguration = fds.sdk.Formula.Configuration(\n fds_oauth_client=ConfidentialClient('/path/to/app-config.json')\n)\n\n# Basic authentication: FactSetApiKey\n# See https://github.com/FactSet/enterprise-sdk#api-key\n# for information how to create an API key\n# configuration = fds.sdk.Formula.Configuration(\n# username='USERNAME-SERIAL',\n# password='API-KEY'\n# )\n\n# Enter a context with an instance of the API client\nwith fds.sdk.Formula.ApiClient(configuration) as api_client:\n # Create an instance of the API class\n api_instance = batch_processing_api.BatchProcessingApi(api_client)\n id = \"id_example\" # str | Batch Request identifier.\n\n try:\n # Returns the response for a Batch Request\n # example passing only required values which don't have defaults set\n api_response_wrapper = api_instance.get_batch_data(id)\n\n # This endpoint returns a response wrapper that contains different types of responses depending on the query.\n # To access the correct response type, you need to perform one additional step, as shown below.\n if api_response_wrapper.get_status_code() == 200:\n api_response = api_response_wrapper.get_response_200()\n if api_response_wrapper.get_status_code() == 202:\n api_response = api_response_wrapper.get_response_202()\n\n pprint(api_response)\n except fds.sdk.Formula.ApiException as e:\n print(\"Exception when calling BatchProcessingApi->get_batch_data: %s\\n\" % e)\n\n # # Get response, http status code and response headers\n # try:\n # # Returns the response for a Batch Request\n # api_response_wrapper, http_status_code, response_headers = api_instance.get_batch_data_with_http_info(id)\n\n # # This endpoint returns a response wrapper that contains different types of responses depending on the query.\n # # To access the correct response type, you need to perform one additional step, as shown below.\n # if api_response_wrapper.get_status_code() == 200:\n # api_response = api_response_wrapper.get_response_200()\n # if api_response_wrapper.get_status_code() == 202:\n # api_response = api_response_wrapper.get_response_202()\n\n # pprint(api_response)\n # pprint(http_status_code)\n # pprint(response_headers)\n # except fds.sdk.Formula.ApiException as e:\n # print(\"Exception when calling BatchProcessingApi->get_batch_data: %s\\n\" % e)\n\n # # Get response asynchronous\n # try:\n # # Returns the response for a Batch Request\n # async_result = api_instance.get_batch_data_async(id)\n # api_response_wrapper = async_result.get()\n\n # # This endpoint returns a response wrapper that contains different types of responses depending on the query.\n # # To access the correct response type, you need to perform one additional step, as shown below.\n # if api_response_wrapper.get_status_code() == 200:\n # api_response = api_response_wrapper.get_response_200()\n # if api_response_wrapper.get_status_code() == 202:\n # api_response = api_response_wrapper.get_response_202()\n\n # pprint(api_response)\n # except fds.sdk.Formula.ApiException as e:\n # print(\"Exception when calling BatchProcessingApi->get_batch_data: %s\\n\" % e)\n\n # # Get response, http status code and response headers asynchronous\n # try:\n # # Returns the response for a Batch Request\n # async_result = api_instance.get_batch_data_with_http_info_async(id)\n # api_response_wrapper, http_status_code, response_headers = async_result.get()\n\n # # This endpoint returns a response wrapper that contains different types of responses depending on the query.\n # # To access the correct response type, you need to perform one additional step, as shown below.\n # if api_response_wrapper.get_status_code() == 200:\n # api_response = api_response_wrapper.get_response_200()\n # if api_response_wrapper.get_status_code() == 202:\n # api_response = api_response_wrapper.get_response_202()\n\n # pprint(api_response)\n # pprint(http_status_code)\n # pprint(response_headers)\n # except fds.sdk.Formula.ApiException as e:\n # print(\"Exception when calling BatchProcessingApi->get_batch_data: %s\\n\" % e)\n\n```\n\n### Using Pandas\n\nTo convert an API response to a Pandas DataFrame, it is necessary to transform it first to a dictionary.\n```python\nimport pandas as pd\n\nresponse_dict = api_response.to_dict()['data']\n\nsimple_json_response = pd.DataFrame(response_dict)\nnested_json_response = pd.json_normalize(response_dict)\n```\n\n### Debugging\n\nThe SDK uses the standard library [`logging`](https://docs.python.org/3/library/logging.html#module-logging) module.\n\nSetting `debug` to `True` on an instance of the `Configuration` class sets the log-level of related packages to `DEBUG`\nand enables additional logging in Pythons [HTTP Client](https://docs.python.org/3/library/http.client.html).\n\n**Note**: This prints out sensitive information (e.g. the full request and response). Use with care.\n\n```python\nimport logging\nimport fds.sdk.Formula\n\nlogging.basicConfig(level=logging.DEBUG)\n\nconfiguration = fds.sdk.Formula.Configuration(...)\nconfiguration.debug = True\n```\n\n### Configure a Proxy\n\nYou can pass proxy settings to the Configuration class:\n\n* `proxy`: The URL of the proxy to use.\n* `proxy_headers`: a dictionary to pass additional headers to the proxy (e.g. `Proxy-Authorization`).\n\n```python\nimport fds.sdk.Formula\n\nconfiguration = fds.sdk.Formula.Configuration(\n # ...\n proxy=\"http://secret:password@localhost:5050\",\n proxy_headers={\n \"Custom-Proxy-Header\": \"Custom-Proxy-Header-Value\"\n }\n)\n```\n\n### Custom SSL Certificate\n\nTLS/SSL certificate verification can be configured with the following Configuration parameters:\n\n* `ssl_ca_cert`: a path to the certificate to use for verification in `PEM` format.\n* `verify_ssl`: setting this to `False` disables the verification of certificates.\n Disabling the verification is not recommended, but it might be useful during\n local development or testing.\n\n```python\nimport fds.sdk.Formula\n\nconfiguration = fds.sdk.Formula.Configuration(\n # ...\n ssl_ca_cert='/path/to/ca.pem'\n)\n```\n\n### Request Retries\n\nIn case the request retry behaviour should be customized, it is possible to pass a `urllib3.Retry` object to the `retry` property of the Configuration.\n\n```python\nfrom urllib3 import Retry\nimport fds.sdk.Formula\n\nconfiguration = fds.sdk.Formula.Configuration(\n # ...\n)\n\nconfiguration.retries = Retry(total=3, status_forcelist=[500, 502, 503, 504])\n```\n\n\n## Documentation for API Endpoints\n\nAll URIs are relative to *https://api.factset.com/formula-api/v1*\n\nClass | Method | HTTP request | Description\n------------ | ------------- | ------------- | -------------\n*BatchProcessingApi* | [**get_batch_data**](https://github.com/FactSet/enterprise-sdk/tree/main/code/python/Formula/v1/docs/BatchProcessingApi.md#get_batch_data) | **GET** /batch-result | Returns the response for a Batch Request\n*BatchProcessingApi* | [**get_batch_data_with_post**](https://github.com/FactSet/enterprise-sdk/tree/main/code/python/Formula/v1/docs/BatchProcessingApi.md#get_batch_data_with_post) | **POST** /batch-result | Returns the status for a Batch Request\n*BatchProcessingApi* | [**get_batch_status**](https://github.com/FactSet/enterprise-sdk/tree/main/code/python/Formula/v1/docs/BatchProcessingApi.md#get_batch_status) | **GET** /batch-status | Returns the status for a Batch Request\n*BatchProcessingApi* | [**get_batch_status_with_post**](https://github.com/FactSet/enterprise-sdk/tree/main/code/python/Formula/v1/docs/BatchProcessingApi.md#get_batch_status_with_post) | **POST** /batch-status | Returns the status for a Batch Request\n*CrossSectionalApi* | [**get_cross_sectional_data**](https://github.com/FactSet/enterprise-sdk/tree/main/code/python/Formula/v1/docs/CrossSectionalApi.md#get_cross_sectional_data) | **GET** /cross-sectional | Retrieve data items (Screening formulas) for a list of identifiers or defined universe.\n*CrossSectionalApi* | [**get_cross_sectional_data_for_list**](https://github.com/FactSet/enterprise-sdk/tree/main/code/python/Formula/v1/docs/CrossSectionalApi.md#get_cross_sectional_data_for_list) | **POST** /cross-sectional | Retrieve data items (Screening formulas) for a list of identifiers or defined universe.\n*TimeSeriesApi* | [**get_time_series_data**](https://github.com/FactSet/enterprise-sdk/tree/main/code/python/Formula/v1/docs/TimeSeriesApi.md#get_time_series_data) | **GET** /time-series | Retrieve data items (FQL formulas) for a list of identifiers or defined universe.\n*TimeSeriesApi* | [**get_time_series_data_for_list**](https://github.com/FactSet/enterprise-sdk/tree/main/code/python/Formula/v1/docs/TimeSeriesApi.md#get_time_series_data_for_list) | **POST** /time-series | Retrieve data items (FQL formulas) for a list of identifiers or defined universe.\n\n\n## Documentation For Models\n\n - [BatchData](https://github.com/FactSet/enterprise-sdk/tree/main/code/python/Formula/v1/docs/BatchData.md)\n - [BatchDataRequest](https://github.com/FactSet/enterprise-sdk/tree/main/code/python/Formula/v1/docs/BatchDataRequest.md)\n - [BatchDataRequestData](https://github.com/FactSet/enterprise-sdk/tree/main/code/python/Formula/v1/docs/BatchDataRequestData.md)\n - [BatchDataResponse](https://github.com/FactSet/enterprise-sdk/tree/main/code/python/Formula/v1/docs/BatchDataResponse.md)\n - [BatchStatus](https://github.com/FactSet/enterprise-sdk/tree/main/code/python/Formula/v1/docs/BatchStatus.md)\n - [BatchStatusResponse](https://github.com/FactSet/enterprise-sdk/tree/main/code/python/Formula/v1/docs/BatchStatusResponse.md)\n - [CrossSectionalRequest](https://github.com/FactSet/enterprise-sdk/tree/main/code/python/Formula/v1/docs/CrossSectionalRequest.md)\n - [CrossSectionalRequestData](https://github.com/FactSet/enterprise-sdk/tree/main/code/python/Formula/v1/docs/CrossSectionalRequestData.md)\n - [CrossSectionalResponse](https://github.com/FactSet/enterprise-sdk/tree/main/code/python/Formula/v1/docs/CrossSectionalResponse.md)\n - [CrossSectionalResponseObjectItems](https://github.com/FactSet/enterprise-sdk/tree/main/code/python/Formula/v1/docs/CrossSectionalResponseObjectItems.md)\n - [CrossSectionalResultObjectFlattened](https://github.com/FactSet/enterprise-sdk/tree/main/code/python/Formula/v1/docs/CrossSectionalResultObjectFlattened.md)\n - [CrossSectionalResultObjectFlattenedAddl](https://github.com/FactSet/enterprise-sdk/tree/main/code/python/Formula/v1/docs/CrossSectionalResultObjectFlattenedAddl.md)\n - [CrossSectionalResultObjectNonflattened](https://github.com/FactSet/enterprise-sdk/tree/main/code/python/Formula/v1/docs/CrossSectionalResultObjectNonflattened.md)\n - [CrossSectionalResultObjectNonflattenedResultAttribute](https://github.com/FactSet/enterprise-sdk/tree/main/code/python/Formula/v1/docs/CrossSectionalResultObjectNonflattenedResultAttribute.md)\n - [ErrorDetail](https://github.com/FactSet/enterprise-sdk/tree/main/code/python/Formula/v1/docs/ErrorDetail.md)\n - [ErrorObject](https://github.com/FactSet/enterprise-sdk/tree/main/code/python/Formula/v1/docs/ErrorObject.md)\n - [TimeSeriesRequest](https://github.com/FactSet/enterprise-sdk/tree/main/code/python/Formula/v1/docs/TimeSeriesRequest.md)\n - [TimeSeriesRequestData](https://github.com/FactSet/enterprise-sdk/tree/main/code/python/Formula/v1/docs/TimeSeriesRequestData.md)\n - [TimeSeriesResponse](https://github.com/FactSet/enterprise-sdk/tree/main/code/python/Formula/v1/docs/TimeSeriesResponse.md)\n - [TimeSeriesResponseObjectItems](https://github.com/FactSet/enterprise-sdk/tree/main/code/python/Formula/v1/docs/TimeSeriesResponseObjectItems.md)\n - [TimeSeriesResultObjectFlattened](https://github.com/FactSet/enterprise-sdk/tree/main/code/python/Formula/v1/docs/TimeSeriesResultObjectFlattened.md)\n - [TimeSeriesResultObjectFlattenedAddl](https://github.com/FactSet/enterprise-sdk/tree/main/code/python/Formula/v1/docs/TimeSeriesResultObjectFlattenedAddl.md)\n - [TimeSeriesResultObjectNonflattened](https://github.com/FactSet/enterprise-sdk/tree/main/code/python/Formula/v1/docs/TimeSeriesResultObjectNonflattened.md)\n - [TimeSeriesResultObjectNonflattenedArray](https://github.com/FactSet/enterprise-sdk/tree/main/code/python/Formula/v1/docs/TimeSeriesResultObjectNonflattenedArray.md)\n - [TimeSeriesResultObjectNonflattenedBase](https://github.com/FactSet/enterprise-sdk/tree/main/code/python/Formula/v1/docs/TimeSeriesResultObjectNonflattenedBase.md)\n - [TimeSeriesResultObjectNonflattenedMatrix](https://github.com/FactSet/enterprise-sdk/tree/main/code/python/Formula/v1/docs/TimeSeriesResultObjectNonflattenedMatrix.md)\n - [TimeSeriesResultObjectNonflattenedScalar](https://github.com/FactSet/enterprise-sdk/tree/main/code/python/Formula/v1/docs/TimeSeriesResultObjectNonflattenedScalar.md)\n - [TimeSeriesResultObjectNonflattenedTimeseriesObject](https://github.com/FactSet/enterprise-sdk/tree/main/code/python/Formula/v1/docs/TimeSeriesResultObjectNonflattenedTimeseriesObject.md)\n - [TimeSeriesScalarValue](https://github.com/FactSet/enterprise-sdk/tree/main/code/python/Formula/v1/docs/TimeSeriesScalarValue.md)\n - [TimeSeriesTimeseriesObject](https://github.com/FactSet/enterprise-sdk/tree/main/code/python/Formula/v1/docs/TimeSeriesTimeseriesObject.md)\n - [WarningsObject](https://github.com/FactSet/enterprise-sdk/tree/main/code/python/Formula/v1/docs/WarningsObject.md)\n\n\n## Documentation For Authorization\n\n\n## FactSetApiKey\n\n- **Type**: HTTP basic authentication\n\n\n## FactSetOAuth2\n\n- **Type**: OAuth\n- **Flow**: application\n- **Authorization URL**: \n- **Scopes**: N/A\n\n\n## Notes for Large OpenAPI documents\nIf the OpenAPI document is large, imports in fds.sdk.Formula.apis and fds.sdk.Formula.models may fail with a\nRecursionError indicating the maximum recursion limit has been exceeded. In that case, there are a couple of solutions:\n\nSolution 1:\nUse specific imports for apis and models like:\n- `from fds.sdk.Formula.api.default_api import DefaultApi`\n- `from fds.sdk.Formula.model.pet import Pet`\n\nSolution 2:\nBefore importing the package, adjust the maximum recursion limit as shown below:\n```\nimport sys\nsys.setrecursionlimit(1500)\nimport fds.sdk.Formula\nfrom fds.sdk.Formula.apis import *\nfrom fds.sdk.Formula.models import *\n```\n\n## Contributing\n\nPlease refer to the [contributing guide](../../../../CONTRIBUTING.md).\n\n## Copyright\n\nCopyright 2022 FactSet Research Systems Inc\n\nLicensed under the Apache License, Version 2.0 (the \"License\");\nyou may not use this file except in compliance with the License.\nYou may obtain a copy of the License at\n\n http://www.apache.org/licenses/LICENSE-2.0\n\nUnless required by applicable law or agreed to in writing, software\ndistributed under the License is distributed on an \"AS IS\" BASIS,\nWITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.\nSee the License for the specific language governing permissions and\nlimitations under the License.\n\n\n\n",
"bugtrack_url": null,
"license": "Apache License, Version 2.0",
"summary": "Formula client library for Python",
"version": "3.0.1",
"project_urls": {
"Homepage": "https://github.com/FactSet/enterprise-sdk/tree/main/code/python/Formula/v1"
},
"split_keywords": [
"factset",
" api",
" sdk"
],
"urls": [
{
"comment_text": "",
"digests": {
"blake2b_256": "28ddf3fb39d532eb16522a79b95242bc91bc88c60a3449215c267a8e4f8234e3",
"md5": "95f6dcc5404391043a4d8196913f34a7",
"sha256": "dedd2c5c80d249c20c8160d0263c1e44b0455eb650378012fe64602fab20df0d"
},
"downloads": -1,
"filename": "fds.sdk.Formula-3.0.1-py3-none-any.whl",
"has_sig": false,
"md5_digest": "95f6dcc5404391043a4d8196913f34a7",
"packagetype": "bdist_wheel",
"python_version": "py3",
"requires_python": ">=3.7",
"size": 198060,
"upload_time": "2024-11-01T10:12:23",
"upload_time_iso_8601": "2024-11-01T10:12:23.219524Z",
"url": "https://files.pythonhosted.org/packages/28/dd/f3fb39d532eb16522a79b95242bc91bc88c60a3449215c267a8e4f8234e3/fds.sdk.Formula-3.0.1-py3-none-any.whl",
"yanked": false,
"yanked_reason": null
},
{
"comment_text": "",
"digests": {
"blake2b_256": "20953a71f3124af97e6048af9b4e690584c0bc157d003626e18f8f9c99bde5eb",
"md5": "3cf430dfdf472d5e14217bad227a39dd",
"sha256": "837d5fd3a28efe52e2bb28a68de5f2c1af2fd7decc4e64b4a6fa73fb4416759b"
},
"downloads": -1,
"filename": "fds.sdk.Formula-3.0.1.tar.gz",
"has_sig": false,
"md5_digest": "3cf430dfdf472d5e14217bad227a39dd",
"packagetype": "sdist",
"python_version": "source",
"requires_python": ">=3.7",
"size": 88080,
"upload_time": "2024-11-01T10:12:20",
"upload_time_iso_8601": "2024-11-01T10:12:20.768346Z",
"url": "https://files.pythonhosted.org/packages/20/95/3a71f3124af97e6048af9b4e690584c0bc157d003626e18f8f9c99bde5eb/fds.sdk.Formula-3.0.1.tar.gz",
"yanked": false,
"yanked_reason": null
}
],
"upload_time": "2024-11-01 10:12:20",
"github": true,
"gitlab": false,
"bitbucket": false,
"codeberg": false,
"github_user": "FactSet",
"github_project": "enterprise-sdk",
"travis_ci": false,
"coveralls": false,
"github_actions": false,
"lcname": "fds.sdk.formula"
}