[](https://www.factset.com)
# FactSet Fundamentals client library for Python
[](https://pypi.org/project/fds.sdk.FactSetFundamentals/)
[](https://www.apache.org/licenses/LICENSE-2.0)
Gain access to current, comprehensive, and comparative information on securities in worldwide developed and emerging markets. Composed of annual and interim/quarterly data, detailed historical financial statement content, per share data, and calculated ratios, FactSet Fundamentals provides you with the information you need for a global investment perspective.
This Python package is automatically generated by the [OpenAPI Generator](https://openapi-generator.tech) project:
- API version: 1.1.0
- Package version: 1.0.1
- Build package: org.openapitools.codegen.languages.PythonClientCodegen
## Requirements
* Python >= 3.7
## Installation
### Poetry
```shell
poetry add fds.sdk.utils fds.sdk.FactSetFundamentals
```
### pip
```shell
pip install fds.sdk.utils fds.sdk.FactSetFundamentals
```
## 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:
```python
from fds.sdk.utils.authentication import ConfidentialClient
import fds.sdk.FactSetFundamentals
from fds.sdk.FactSetFundamentals.api import data_items_api
from fds.sdk.FactSetFundamentals.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
# See https://github.com/FactSet/enterprise-sdk-utils-python#authentication
# for more information on using the ConfidentialClient class
configuration = fds.sdk.FactSetFundamentals.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.FactSetFundamentals.Configuration(
# username='USERNAME-SERIAL',
# password='API-KEY'
# )
# Enter a context with an instance of the API client
with fds.sdk.FactSetFundamentals.ApiClient(configuration) as api_client:
# Create an instance of the API class
api_instance = data_items_api.DataItemsApi(api_client)
category = "INCOME_STATEMENT" # str | Filters the list of FF_* metrics by major category - * **INCOME_STATEMENT** = Income Statement line items, such as Sales, Gross Profit, Net Income. * **BALANCE_SHEET** = Balance Sheet line items, such as Assets, Liabilities, and Shareholders Equity. * **CASH_FLOW** = Cash Flow Statement line items, such as Financing activities, Operation, and Per Share. * **RATIOS** = Pre-calculated Ratios, including Financial, Growth Rates, Profitability, Liquidity, Size, and Valuation. * **FINANCIAL_SERVICES** = Financial Statement Items modified for Financial Services companies. * **INDUSTRY_METRICS** = Industry Specific Line Items or Modifications. View subcategory for list of Industries. * **PENSION_AND_POSTRETIREMENT** = Accumulated Pension Benefit Obligations and related data. * **MARKET_DATA** = General Market Data, such as Shares Outstanding. *Note - /factset-prices/prices/ endpoints may be better suited for pricing related market data.* * **MISCELLANEOUS** = Corporation Data, Financial Records details, Indicators. * **DATES** = Relevant Dates (optional)
subcategory = "INCOME_STATEMENT" # str | Sub-Category Filter for the Primary Category Requested. Choose a related sub-category for the Category requested- * **INCOME_STATEMENT** - INCOME_STATEMENT, NON-OPERATING, PER_SHARE, SUPPLEMENTAL, OTHER * **BALANCE_SHEET** - ASSETS, BALANCE_SHEET, HEALTHCARE, LIABILITIES, PER_SHARE, SHAREHOLDERS_EQUITY, SUPPLEMENTAL * **CASH_FLOW** - CASH_FLOW, CHANGE_IN_CASH, FINANCING, INVESTING, OPERATING, PER_SHARE, SUPPLEMENTAL * **RATIOS** - FINANCIAL, GROWTH_RATE, LIQUIDITY, PROFITABILITY, SIZE, VALUATION * **FINANCIAL_SERVICES** - BALANCE_SHEET, INCOME_STATEMENT, SUPPLEMENTAL * **INDUSTRY_METRICS** - AIRLINES, BANKING, HOTELS_AND_GAMING, METALS_AND_MINING, OIL_AND_GAS, PHARMACEUTICAL, REIT, RETAIL, BANK, INSURANCE, UTILITY * **PENSION_AND_POSTRETIREMENT** - PENSION_AND_POSTRETIREMENT * **MARKET_DATA** - MARKET_DATA * **MISCELLANEOUS** - CLASSIFICATION, CORPORATE_DATA, FINANCIAL_RECORDS, INDICATOR, EMPLOYEES_AND_MANAGEMENT * **DATES** - DATES (optional)
try:
# Available fundamental metrics or ratios.
api_response = api_instance.get_fds_fundamentals_metrics(category=category, subcategory=subcategory)
pprint(api_response)
except fds.sdk.FactSetFundamentals.ApiException as e:
print("Exception when calling DataItemsApi->get_fds_fundamentals_metrics: %s\n" % e)
# Get response, http status code and response headers
# try:
# # Available fundamental metrics or ratios.
# api_response, http_status_code, response_headers = api_instance.get_fds_fundamentals_metrics_with_http_info(category=category, subcategory=subcategory)
# pprint(api_response)
# pprint(http_status_code)
# pprint(response_headers)
# except fds.sdk.FactSetFundamentals.ApiException as e:
# print("Exception when calling DataItemsApi->get_fds_fundamentals_metrics: %s\n" % e)
# Get response asynchronous
# try:
# # Available fundamental metrics or ratios.
# async_result = api_instance.get_fds_fundamentals_metrics_async(category=category, subcategory=subcategory)
# api_response = async_result.get()
# pprint(api_response)
# except fds.sdk.FactSetFundamentals.ApiException as e:
# print("Exception when calling DataItemsApi->get_fds_fundamentals_metrics: %s\n" % e)
# Get response, http status code and response headers asynchronous
# try:
# # Available fundamental metrics or ratios.
# async_result = api_instance.get_fds_fundamentals_metrics_with_http_info_async(category=category, subcategory=subcategory)
# api_response, http_status_code, response_headers = async_result.get()
# pprint(api_response)
# pprint(http_status_code)
# pprint(response_headers)
# except fds.sdk.FactSetFundamentals.ApiException as e:
# print("Exception when calling DataItemsApi->get_fds_fundamentals_metrics: %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.FactSetFundamentals
logging.basicConfig(level=logging.DEBUG)
configuration = fds.sdk.FactSetFundamentals.Configuration(...)
configuration.debug = True
```
## Documentation for API Endpoints
All URIs are relative to *https://api.factset.com/content*
Class | Method | HTTP request | Description
------------ | ------------- | ------------- | -------------
*DataItemsApi* | [**get_fds_fundamentals_metrics**](docs/DataItemsApi.md#get_fds_fundamentals_metrics) | **GET** /factset-fundamentals/v1/metrics | Available fundamental metrics or ratios.
*DataItemsApi* | [**get_fds_fundamentals_metrics_for_list**](docs/DataItemsApi.md#get_fds_fundamentals_metrics_for_list) | **POST** /factset-fundamentals/v1/metrics | Available fundamental metrics or ratios.
*FactSetFundamentalsApi* | [**get_fds_fundamentals**](docs/FactSetFundamentalsApi.md#get_fds_fundamentals) | **GET** /factset-fundamentals/v1/fundamentals | Returns the Company Fundamental Data.
*FactSetFundamentalsApi* | [**get_fds_fundamentals_for_list**](docs/FactSetFundamentalsApi.md#get_fds_fundamentals_for_list) | **POST** /factset-fundamentals/v1/fundamentals | Returns the Company Fundamental Data.
## Documentation For Models
- [Category](docs/Category.md)
- [ErrorResponse](docs/ErrorResponse.md)
- [ErrorResponseSubErrors](docs/ErrorResponseSubErrors.md)
- [Fundamental](docs/Fundamental.md)
- [FundamentalsRequest](docs/FundamentalsRequest.md)
- [FundamentalsResponse](docs/FundamentalsResponse.md)
- [Ids](docs/Ids.md)
- [Metric](docs/Metric.md)
- [Metrics](docs/Metrics.md)
- [MetricsRequest](docs/MetricsRequest.md)
- [MetricsResponse](docs/MetricsResponse.md)
- [Periodicity](docs/Periodicity.md)
- [Restated](docs/Restated.md)
- [Subcategory](docs/Subcategory.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.FactSetFundamentals.apis and fds.sdk.FactSetFundamentals.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.FactSetFundamentals.api.default_api import DefaultApi`
- `from fds.sdk.FactSetFundamentals.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.FactSetFundamentals
from fds.sdk.FactSetFundamentals.apis import *
from fds.sdk.FactSetFundamentals.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.