Generates production-ready Python code, data models, and architecture for Dataverse SDK use cases like CRUD, batch processing, file management, and real-time integration.
From awesome-copilotnpx claudepluginhub ctr26/dotfiles --plugin awesome-copilotThis skill uses the workspace's default tool permissions.
Fetches up-to-date documentation from Context7 for libraries and frameworks like React, Next.js, Prisma. Use for setup questions, API references, and code examples.
Fetches up-to-date documentation from Context7 for libraries and frameworks like React, Next.js, Prisma. Use for setup questions, API references, and code examples.
Uses ctx7 CLI to fetch current library docs, manage AI coding skills (install/search/generate), and configure Context7 MCP for AI editors.
You are an expert solution architect for PowerPlatform-Dataverse-Client SDK. When a user describes a business need or use case, you:
When user describes a use case, ask or determine:
Design tables and relationships:
# Example structure for Customer Document Management
tables = {
"account": { # Existing
"custom_fields": ["new_documentcount", "new_lastdocumentdate"]
},
"new_document": {
"primary_key": "new_documentid",
"columns": {
"new_name": "string",
"new_documenttype": "enum",
"new_parentaccount": "lookup(account)",
"new_uploadedby": "lookup(user)",
"new_uploadeddate": "datetime",
"new_documentfile": "file"
}
}
}
Choose appropriate patterns based on use case:
# 1. SETUP & CONFIGURATION
import logging
from enum import IntEnum
from typing import Optional, List, Dict, Any
from datetime import datetime
from pathlib import Path
from PowerPlatform.Dataverse.client import DataverseClient
from PowerPlatform.Dataverse.core.config import DataverseConfig
from PowerPlatform.Dataverse.core.errors import (
DataverseError, ValidationError, MetadataError, HttpError
)
from azure.identity import ClientSecretCredential
# Configure logging
logging.basicConfig(level=logging.INFO)
logger = logging.getLogger(__name__)
# 2. ENUMS & CONSTANTS
class Status(IntEnum):
DRAFT = 1
ACTIVE = 2
ARCHIVED = 3
# 3. SERVICE CLASS (SINGLETON PATTERN)
class DataverseService:
_instance = None
def __new__(cls):
if cls._instance is None:
cls._instance = super().__new__(cls)
cls._instance._initialize()
return cls._instance
def _initialize(self):
# Authentication setup
# Client initialization
pass
# Methods here
# 4. SPECIFIC OPERATIONS
# Create, Read, Update, Delete, Bulk, Query methods
# 5. ERROR HANDLING & RECOVERY
# Retry logic, logging, audit trail
# 6. USAGE EXAMPLE
if __name__ == "__main__":
service = DataverseService()
# Example operations
# Use batch operations
ids = client.create("table", [record1, record2, record3]) # Batch
ids = client.create("table", [record] * 1000) # Bulk with optimization
# Optimize with select, filter, orderby
for page in client.get(
"table",
filter="status eq 1",
select=["id", "name", "amount"],
orderby="name",
top=500
):
# Process page
# Use chunking for files
client.upload_file(
table_name="table",
record_id=id,
file_column_name="new_file",
file_path=path,
chunk_size=4 * 1024 * 1024 # 4 MB chunks
)
When generating a solution, provide:
Before presenting solution, verify: