npx skills add ...
npx skills add github/awesome-copilot --skill dataverse-python-usecase-builder
npx skills add github/awesome-copilot --skill dataverse-python-usecase-builder
Generate complete solutions for specific Dataverse SDK use cases with architecture recommendations
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:
Choose appropriate patterns based on use case:
When generating a solution, provide:
Before presenting solution, verify:
# 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
)