Api and saas ingestion patterns
Skill vaquarkhan/data-engineering-agent-skills/skills/api-and-saas-ingestion-patterns
Production-grade Agent Skills for data engineering AI agents: 73 workflows, platform presets, safe backfill/replay, Kafka & Spark reliability, MCP observability, and VS Code/JetBrains installers.
npx -y skills add vaquarkhan/data-engineering-agent-skills --skill api-and-saas-ingestion-patternsAssembled from the repository path, not quoted from the project. Check it against their README if it does not work.
One thing to look at
- 21 stars21 stars. Stars are a popularity signal and not a quality one, but at this level it is likely that nobody has read this closely except its author, and you would be relying on your own review.
What its author says it does
Copied from the file, not written here
Guides agents through API and SaaS ingestion workflows. Use when extracting data from REST, GraphQL, or SaaS platforms with pagination, rate limits, auth rotation, backfills, or unstable source contracts.
SKILL.md
2.4 KB, as published. Nobody here has run it
API And SaaS Ingestion Patterns
Overview
Use this skill when the source system is an external API or SaaS platform rather than a database or file drop. It helps agents design reliable extraction, pagination, throttling, auth handling, and backfill-safe ingestion contracts.
When to Use
- extracting from REST or GraphQL APIs
- ingesting SaaS platform data
- handling pagination, cursors, or sync tokens
- dealing with rate limits and source-side throttling
- backfilling historical API data safely
Do not treat APIs like static tables. They change behavior, availability, and limits over time.
Workflow
-
Define the source contract. Include:
- endpoint or object name
- auth method
- extraction window
- pagination style
- rate limits
- data freshness expectations
-
Design for extraction resilience. Handle:
- retries
- backoff
- token refresh
- idempotent re-fetch behavior
- partial page failure
-
Make incremental behavior explicit. Decide whether the source supports:
- updated timestamps
- cursors
- change tokens
- full snapshots only
-
Record raw source evidence where useful. API sources often need raw response retention for incident diagnosis.
-
Validate contracts against source drift.
Common Rationalizations
| Rationalization | Reality |
|---|---|
| "We can just loop through pages." | Pagination bugs and retry gaps often cause silent data loss. |
| "The vendor API is stable enough." | SaaS APIs change rate limits, fields, and semantics more often than teams expect. |
| "If a request fails, we can rerun later." | Without windowing and idempotency rules, reruns can miss or duplicate data. |
Red Flags
- no rate-limit strategy exists
- extraction windows depend on undocumented source behavior
- retries ignore duplicate or partial-page risks
- auth rotation and token expiry are not considered
Verification
- The source contract covers pagination, limits, auth, and cadence
- Extraction retries and failures are operationally safe
- Incremental or snapshot behavior is explicit
- Source drift and raw evidence handling are considered