GraffiticodeGraffiticode

Data Sources

Connect to public and private data sources, filter and transform data for downstream use.

Overview

Graffiticode connects to both public and private data sources, enabling you to pull in data from anywhere and shape it for your specific needs. Whether you're aggregating public APIs or accessing internal databases, data flows through Graffiticode to power your components.

Data Flow

  1. Connect - Establish connections to public or private data
  2. Filter - Select the subset of data you need
  3. Transform - Reshape data to match your requirements
  4. Use - Feed transformed data to components, APIs, or storage

Public Data Sources

Connect to publicly available data:

  • Public APIs - Weather, financial markets, government data
  • Open datasets - Census, scientific data, public records
  • RSS/Atom feeds - News, blogs, updates
  • Public databases - Open data portals, research datasets

Private Data Sources

Securely connect to your internal data:

  • Databases - PostgreSQL, MySQL, MongoDB, Firebase
  • Internal APIs - Your backend services
  • SaaS platforms - Salesforce, HubSpot, Stripe
  • Cloud storage - S3, GCS, Azure Blob

Filtering

Select exactly the data you need with conditions, limits, ordering, and field projections.

Transforming

Reshape data to match your requirements with grouping, aggregation, renaming, computed fields, and formatting.

Use

Feed transformed data to various destinations:

  • Components - Power interactive charts, tables, and forms
  • APIs - Expose transformed data via endpoints
  • Storage - Persist to databases or cloud storage

Benefits

  • Unified access - Single interface for public and private data
  • Security - Credentials never exposed to client
  • Flexibility - Filter and transform to any shape
  • Performance - Caching and incremental updates
  • Audit trail - Track data access and transformations