New Integration: S&P Global

Description

Add S&P Global Market Intelligence integration to sync financial data including equities, fixed income, credit ratings, company fundamentals, and market analytics into CORE.

Reference Implementations

Existing Integrations (use as templates)

• integrations/hubspot/ - Similar enterprise data system
• integrations/linear/ - Project management integration
• integrations/slack/ - For reference

Required Files Structure

integrations/spglobal/
├── src/
│   ├── index.ts          # Main entry, API spec
│   ├── schedule.ts       # Sync logic
│   ├── utils.ts          # S&P Global API utilities
│   ├── account-create.ts # API key/OAuth setup
│   └── create-activity.ts # Activity formatting
├── package.json
├── tsup.config.ts
└── README.md

S&P Global API Integration

Authentication Setup

• API key or OAuth 2.0 authentication (varies by product)
• Access via S&P Global Marketplace or Capital IQ API
• Developer portal: https://developer.spglobal.com/
• Marketplace: https://www.marketplace.spglobal.com/

Key Endpoints

• Capital IQ API - Company fundamentals, financial statements
• Market Data API - Real-time or end-of-day pricing for equities, fixed income, derivatives
• Credit Ratings API - S&P credit ratings and outlooks
• Marketplace Catalog API - Dataset catalog and discovery
• Commodity Insights API - Energy and commodity data
• Kensho Link API - Entity resolution and linking

Events to Track

1. Market Data - Price updates, volume changes, index movements
2. Company Data - Earnings released, fundamental data updated, filing published
3. Credit Ratings - Rating changed, outlook revised, new rating assigned
4. Research - New research published, analyst report released
5. Commodities - Price changes, supply/demand updates

Implementation Tasks

• Set up basic integration structure following integrations/github/src/index.ts pattern
• Implement authentication flow in account-create.ts
• Create API utilities in utils.ts for S&P Global API calls
• Implement sync logic in schedule.ts for financial data feeds
• Convert financial events to CORE activity format
• Add error handling and rate limiting
• Create integration documentation
• Add to integrations/README.md

Technical Notes

• RESTful APIs return data in JSON format
• SDKs available in C++, C# and Java
• Enterprise subscription required for most data products
• Swagger documentation available via centralized API Catalog portal
• Consider data licensing restrictions when storing/displaying financial data
• Real-time vs. delayed data options depending on subscription tier
• Large dataset queries may require pagination and batch processing

Resources

• S&P Global Marketplace
• S&P Global Developer Portal
• S&P Capital IQ API
• S&P Global API Brochure (PDF)

Labels

enhancement, integration, new-feature