{"system":"Salesforce Sales Cloud","vendor":"Salesforce","category":"CRM","sector":"retail","company_target":"Maison Lumen SAS","openapi_url":"/openapi.json","endpoints":[{"path":"/services/data/v59.0/query?q=SELECT+Id,Name,Industry,AnnualRevenue+FROM+Account+LIMIT+200","method":"GET","business_object":"Account","description":"Comptes B2B / fournisseurs CRM","record_count_hint":120,"refresh_frequency":"DAILY","fields":[{"name":"Id","type":"string","example":"0011x00000ABC"},{"name":"Name","type":"string","example":"Cotonificio Albini SpA"},{"name":"Industry","type":"string","example":"Textile"},{"name":"AnnualRevenue","type":"number","example":28000000.0}]},{"path":"/services/data/v59.0/query?q=SELECT+Id,FirstName,LastName,Email+FROM+Contact+LIMIT+200","method":"GET","business_object":"Contact","description":"Contacts liés aux comptes","record_count_hint":240,"refresh_frequency":"DAILY","fields":[{"name":"Id","type":"string","example":"0031x00000DEF"},{"name":"FirstName","type":"string","example":"Sophie"},{"name":"LastName","type":"string","example":"Dubois"},{"name":"Email","type":"string","example":"sophie@example.com"}]},{"path":"/services/data/v59.0/query?q=SELECT+Id,Name,Amount,StageName+FROM+Opportunity+LIMIT+200","method":"GET","business_object":"Opportunity","description":"Pipeline opportunités B2B","record_count_hint":80,"refresh_frequency":"HOURLY","fields":[{"name":"Id","type":"string","example":"0061x00000GHI"},{"name":"Name","type":"string","example":"Galeries Lafayette - AH26"},{"name":"Amount","type":"number","example":145000.0},{"name":"StageName","type":"enum","example":"Negotiation"}]},{"path":"/aura/analytics/campaign-spend","method":"GET","business_object":"CampaignSpend","description":"Dépenses campagnes marketing et ROI","record_count_hint":60,"refresh_frequency":"WEEKLY","fields":[{"name":"campaign_id","type":"string","example":"CMP-0042"},{"name":"channel","type":"enum","example":"SOCIAL"},{"name":"actual_spend","type":"number","example":12500.0},{"name":"roi","type":"number","example":2.4}]},{"path":"/aura/analytics/data-quality-issues","method":"GET","business_object":"DataQualityIssue","description":"Anomalies qualité de données CRM","record_count_hint":2,"refresh_frequency":"DAILY","fields":[{"name":"issue_id","type":"string","example":"DQ-2026-0171"},{"name":"type","type":"enum","example":"SUPPLIER_SUBSIDIARY_RISK"},{"name":"severity","type":"enum","example":"HIGH"}]},{"path":"/aura/analytics/wholesale-pipeline","method":"GET","business_object":"Opportunity","description":"15 opportunités wholesale ouvertes par stage","record_count_hint":15,"refresh_frequency":"HOURLY","fields":[{"name":"opp_id","type":"string","example":"OPP-00001"},{"name":"account_name","type":"string","example":"Galeries Lafayette"},{"name":"stage","type":"enum","example":"NEGOTIATION"},{"name":"amount_eur","type":"number","example":142000.0},{"name":"probability_pct","type":"number","example":75},{"name":"close_date","type":"date","example":"2026-10-15"},{"name":"owner","type":"string","example":"S. Bernard"}]},{"path":"/aura/analytics/rfm-segmentation","method":"GET","business_object":"Customer","description":"Segmentation RFM (Recency, Frequency, Monetary) en 8 buckets","record_count_hint":8,"refresh_frequency":"WEEKLY","fields":[{"name":"segment","type":"enum","example":"CHAMPIONS"},{"name":"customer_count","type":"number","example":1240},{"name":"avg_ltv_eur","type":"number","example":2840.0},{"name":"recency_days","type":"number","example":24},{"name":"frequency","type":"number","example":8.4},{"name":"monetary","type":"number","example":2840.0}]},{"path":"/aura/analytics/vip-purchase-history","method":"GET","business_object":"Customer","description":"10 clientes VIP nommées (LTV, dernière commande, tier)","record_count_hint":10,"refresh_frequency":"DAILY","fields":[{"name":"customer_id","type":"string","example":"VIP-0001"},{"name":"name","type":"string","example":"Marie Lefebvre"},{"name":"total_spent_eur","type":"number","example":18400.0},{"name":"last_purchase_date","type":"date","example":"2026-05-12"},{"name":"favorite_category","type":"enum","example":"BAGS"},{"name":"purchase_frequency_per_year","type":"number","example":8.4},{"name":"loyalty_tier","type":"enum","example":"GOLD"}]},{"path":"/aura/analytics/churn-by-segment","method":"GET","business_object":"Customer","description":"Taux de churn par segment sur 12 mois","record_count_hint":60,"refresh_frequency":"MONTHLY","fields":[{"name":"segment","type":"enum","example":"REGULAR"},{"name":"period","type":"string","example":"2026-05"},{"name":"churn_rate_pct","type":"number","example":8.4},{"name":"retention_rate_pct","type":"number","example":91.6},{"name":"customers_lost","type":"number","example":142},{"name":"customers_recovered","type":"number","example":28}]}]}