sustainalytics 0.0.4

This is a package that helps clients access sustainalytics API

Introduction

This python package provides access to Sustainalytics API (Application Programming Interface) service which provides developers with 24x7 programmatic access to Sustainalytics data. The API has been developed based on market standards with a primary focus on secure connectivity and ease of use. It allows users to retrieve and integrate Sustainalytics data into their own internal systems and custom or third-party applications

This document is meant to provide developers with python sample code for the Sustainalytics API service. Technical documentation can also be found on the dedicated website for the API.

Installation

Install the package via pip with code below:

pip install sustainalytics

To Upgrade:

pip install --upgrade sustainalytics

Connection

A clientid and a secret key must be provided by the Sustainalytics Team in order to access the API. See connection via python:

from sustainalytics.api import API

#Access
client_id = 'xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx'
client_secret_key = 'xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx'

api = API(client_id,client_secret_key)

#To verify print token or access headers
print(api.access_headers)

Endpoints

DataService

The DataService enables the user to call the research data associated with the companies in the universe of access. Within this service there are two endpoints, as described below.

The code below shows you how to extract data from these endpoints

GetData

Retrieves data from the DataService endpoint by passing the following paramenters below.

You can only combine identifiers argument with ONE of the the other arguments:

identifiers : A list of security or entity identifiers separated by comma. You can obtain list of EntityIds from the api.get_universe_entityIds(keep_duplicates=True)

productIds : A list of product ids separated by comma. You can obtain list of ProductIds from the api.get_productIds()

packageIds : A list of package ids separated by comma. You can obtain list of PackageIds from the api.get_packageIds()

fieldClusterIds : A list of field cluster ids separated by comma. You can obtain list of FieldClusterIds from the api.get_fieldClusterIds()

fieldIds : A list of field ids separated by comma. You can obtain list of FieldIds from the api.get_fieldIds()

#### GetData
data = con.get_data(identifiers=[], productIds=[], packageIds=[], fieldClusterIds=[], fieldIds=[])
#retrieves data for the specified identifier(s). Only the identifiers parameter is required for the function to work.
print(data)

Product Structure & Definitions

Each product is built from data packages and each data package is built from field clusters. The datafields are the smallest components of the product structure.

The Product Structure service provides an overview of the data fields available in the Sustainalytics API and the unique FieldIds linked to each of these data fields. Within this service there are three endpoints, as described below.

The code below shows you how to extract data from these endpoints

#### FieldDefinitions
field_definitions = con.get_fieldDefinitions(dtype='dataframe') #by default dtype='json'
print(field_definitions)

#### FieldMappings
field_mappings = con.get_fieldMappings(dtype='dataframe') #by default dtype='json'
print(field_mappings)

#### FieldMappingDefinitions
field_mapping_definition = con.get_fieldMappingDefinition(dtype='dataframe') #by default dtype='json'
print(field_mapping_definition)

Reports

The ReportService endpoint allows users to retrieve a list of all available PDF report types by ReportId, ReportType, and ReportName for companies belonging to the universe of access.

(Please note this Endpoint is not part of the standard API product.)

The code below shows you how to extract data from these endpoints

####ReportService
report_info = con.get_pdfReportInfo(dtype='dataframe') #by default dtype='json'
#gives all the available report fieldIDs (reportids)
print(report_info)

####ReportService(identifier)(reportid)
report_identifier_reportid = con.get_pdfReportUrl(identifier='x', reportId='y') 
#returns the url to given pdf report for specified companies (if available)
print(report_identifier_reportid)

The function supports only 1 identifier and reportID per call.

Universe of Access

The UniverseOfAccess endpoint allows users to determine thelist ofEntityIds contained inthe universe of access (all permissioned securities lists).

####UniverseofAccess
universe = con.get_universe_access(dtype='dataframe') #by default dtype='json'
#gets all universe constituents
print(universe)