Skill UI

This skill provides advanced methods for interacting with Salesforce, focusing on high-volume data processing. It covers using Bulk API 2.0 for mass data ingestion, querying, and exporting millions of records. Furthermore, it demonstrates the Composite API for executing complex, multi-step, and dependent transactions (e.g., creating Account, then referencing it to create Contact) in a single, atomic call, ensuring data integrity and maximum efficiency.

A comprehensive guide and implementation pattern for handling Salesforce API quotas and rate limits. Learn how to monitor daily usage, implement exponential backoff with jitter for transient errors (like REQUEST_LIMIT_EXCEEDED), and optimize API calls using bulk operations, caching, and queryMore to ensure stable, high-throughput integrations.

A comprehensive guide providing production-ready patterns for integrating with Salesforce using jsforce (TypeScript) and simple-salesforce (Python). These patterns cover essential topics such as implementing singleton connection management with automatic token refresh, defining typed sObject interfaces, building type-safe SOQL query builders, and wrapping API calls with robust error handling mechanisms. Ideal for developers refactoring existing Salesforce integrations or establishing standardized team coding practices.

A comprehensive guide for deep debugging complex Shopify API issues. Learn how to use GraphQL introspection, analyze query cost headers, trace specific requests using X-Request-Id, and inspect webhook delivery status. This skill helps diagnose intermittent failures, throttling, and data inconsistencies in high-volume e-commerce environments.

A comprehensive guide to mastering Shopify's calculated query cost system. Learn how to prevent API throttling errors by understanding the difference between requested and actual query costs. The guide covers advanced techniques like optimizing pagination, selecting minimal fields, avoiding deep nesting, and utilizing bulk operations for massive data exports.

This guide provides a minimal, working example of connecting to a Shopify store using the GraphQL Admin API. It demonstrates how to initialize the API client, authenticate the connection, and execute a query to retrieve product and variant details. Ideal for developers starting a new e-commerce integration, testing API connectivity, or learning basic Shopify data retrieval patterns.

Set up comprehensive observability for Shopify app integrations. This skill tracks crucial metrics like GraphQL query costs, REST rate limit consumption, webhook delivery success, and API latency. It is essential for production monitoring, setting up robust Prometheus metrics, and configuring alerts for performance bottlenecks in e-commerce SaaS environments.

This comprehensive guide details strategies for optimizing Shopify API performance. Key techniques include reducing excessive GraphQL query costs, implementing bulk operations for large data exports, setting up robust response caching with webhook invalidation, and utilizing the Storefront API for high-traffic public storefronts. Essential for developers hitting rate limits or slow data retrieval.

Implement comprehensive automated policy enforcement for Shopify apps, ensuring security and adherence to App Store guidelines. This skill includes ESLint rules for detecting hardcoded API secrets, enforcing GraphQL query cost budgets, and running pre-commit hooks and CI checks for critical compliance validations (e.g., GDPR webhooks). Use it when hardening a production-ready Shopify application.

A comprehensive skill for managing Shopify's unique rate limiting systems, covering both the REST API's leaky bucket mechanism and the GraphQL API's calculated query cost. It provides robust techniques for handling 429 errors, implementing exponential backoff, and optimizing queries to ensure stable, high-throughput e-commerce integrations.

This guide details how to build modern, custom headless storefronts using Shopify's Storefront API and Cart API. It covers key functionalities like product querying, cart management (adding/updating lines), and initiating the checkout flow. Designed for developers building client-facing e-commerce experiences, it emphasizes the use of public access tokens for decoupled, highly customizable online stores.

This guide provides minimal working examples for connecting to Snowflake and executing core SQL operations. It comprehensively covers connection setup, running simple SELECT queries, creating databases and tables, and performing parameterized inserts using both Python and Node.js. It is ideal for initial environment setup, testing the Snowflake SDK, or learning fundamental data warehouse interactions.