# API Integration Configuration
# Sets up comprehensive API integrations with external systems

# Create API endpoints
INSERT_UPDATE APIEndpoint;code[unique=true];name[lang=en];description[lang=en];url;active;authenticationType(code)
;PAYMENT_GATEWAY_API;Payment Gateway API;Integration with payment gateway;https://api.paymentgateway.com/v1;true;API_KEY
;SHIPPING_PROVIDER_API;Shipping Provider API;Integration with shipping provider;https://api.shipping.com/v2;true;OAUTH2
;INVENTORY_SYSTEM_API;Inventory System API;Integration with inventory system;https://api.inventory.com/v1;true;BASIC_AUTH
;CRM_SYSTEM_API;CRM System API;Integration with CRM system;https://api.crm.com/v3;true;JWT
;ANALYTICS_API;Analytics API;Integration with analytics platform;https://api.analytics.com/v1;true;API_KEY

# Create API credentials
INSERT_UPDATE APICredential;code[unique=true];endpoint(code);credentialType(code);value;active
;PAYMENT_API_KEY;PAYMENT_GATEWAY_API;API_KEY;sk_live_1234567890abcdef;true
;SHIPPING_CLIENT_ID;SHIPPING_PROVIDER_API;CLIENT_ID;shipping_client_123;true
;SHIPPING_CLIENT_SECRET;SHIPPING_PROVIDER_API;CLIENT_SECRET;shipping_secret_456;true
;INVENTORY_USERNAME;INVENTORY_SYSTEM_API;USERNAME;inventory_user;true
;INVENTORY_PASSWORD;INVENTORY_SYSTEM_API;PASSWORD;inventory_pass_789;true
;CRM_JWT_TOKEN;CRM_SYSTEM_API;JWT_TOKEN;jwt_token_xyz123;true
;ANALYTICS_API_KEY;ANALYTICS_API;API_KEY;analytics_key_abc456;true

# Create API configurations
INSERT_UPDATE APIConfiguration;code[unique=true];endpoint(code);timeout;retryAttempts;retryDelay;active
;PAYMENT_CONFIG;PAYMENT_GATEWAY_API;30000;3;1000;true
;SHIPPING_CONFIG;SHIPPING_PROVIDER_API;60000;5;2000;true
;INVENTORY_CONFIG;INVENTORY_SYSTEM_API;45000;3;1500;true
;CRM_CONFIG;CRM_SYSTEM_API;30000;2;1000;true
;ANALYTICS_CONFIG;ANALYTICS_API;15000;1;500;true

# Create webhook endpoints
INSERT_UPDATE WebhookEndpoint;code[unique=true];name[lang=en];description[lang=en];url;active;secret
;ORDER_WEBHOOK;Order Webhook;Webhook for order events;https://api.company.com/webhooks/orders;true;webhook_secret_123
;PAYMENT_WEBHOOK;Payment Webhook;Webhook for payment events;https://api.company.com/webhooks/payments;true;webhook_secret_456
;INVENTORY_WEBHOOK;Inventory Webhook;Webhook for inventory events;https://api.company.com/webhooks/inventory;true;webhook_secret_789
;CUSTOMER_WEBHOOK;Customer Webhook;Webhook for customer events;https://api.company.com/webhooks/customers;true;webhook_secret_abc

# Create integration mappings
INSERT_UPDATE IntegrationMapping;code[unique=true];name[lang=en];description[lang=en];sourceType(code);targetType(code);active
;ORDER_TO_CRM;Order to CRM Mapping;Maps order data to CRM format;Order;CRMOrder;true
;PRODUCT_TO_INVENTORY;Product to Inventory Mapping;Maps product data to inventory format;Product;InventoryItem;true
;CUSTOMER_TO_CRM;Customer to CRM Mapping;Maps customer data to CRM format;Customer;CRMCustomer;true
;PAYMENT_TO_GATEWAY;Payment to Gateway Mapping;Maps payment data to gateway format;PaymentInfo;GatewayPayment;true

# Create API rate limits
INSERT_UPDATE APIRateLimit;code[unique=true];endpoint(code);requestsPerMinute;requestsPerHour;requestsPerDay;active
;PAYMENT_RATE_LIMIT;PAYMENT_GATEWAY_API;100;5000;100000;true
;SHIPPING_RATE_LIMIT;SHIPPING_PROVIDER_API;50;2000;50000;true
;INVENTORY_RATE_LIMIT;INVENTORY_SYSTEM_API;200;10000;200000;true
;CRM_RATE_LIMIT;CRM_SYSTEM_API;150;7500;150000;true
;ANALYTICS_RATE_LIMIT;ANALYTICS_API;300;15000;300000;true

# Create API monitoring
INSERT_UPDATE APIMonitoring;code[unique=true];endpoint(code);monitoringEnabled;alertThreshold;alertEmail;active
;PAYMENT_MONITORING;PAYMENT_GATEWAY_API;true;5000;[email protected];true
;SHIPPING_MONITORING;SHIPPING_PROVIDER_API;true;10000;[email protected];true
;INVENTORY_MONITORING;INVENTORY_SYSTEM_API;true;3000;[email protected];true
;CRM_MONITORING;CRM_SYSTEM_API;true;5000;[email protected];true
;ANALYTICS_MONITORING;ANALYTICS_API;true;2000;[email protected];true

# Create API versioning
INSERT_UPDATE APIVersion;code[unique=true];endpoint(code);version;active;deprecated;deprecationDate[dateformat=dd.MM.yyyy]
;PAYMENT_V1;PAYMENT_GATEWAY_API;v1;false;true;31.12.2024
;PAYMENT_V2;PAYMENT_GATEWAY_API;v2;true;false;
;SHIPPING_V1;SHIPPING_PROVIDER_API;v1;true;false;
;INVENTORY_V1;INVENTORY_SYSTEM_API;v1;true;false;
;CRM_V2;CRM_SYSTEM_API;v2;true;false;
;CRM_V3;CRM_SYSTEM_API;v3;true;false;
;ANALYTICS_V1;ANALYTICS_API;v1;true;false;