CData Arc の AI コネクタはREST API を介して、任意のAI モデルに接続出来るコネクタで、v26 で新たに追加されたコネクタです。システムやユーザープロンプトを使って入力メッセージを処理し、データフロー内で構造化された出力を生成することを可能にします。
次にAI コネクタを追加します。AI コネクタの利用には利用するLLM やモデルの設定が必要となります。未設定の場合は必要に応じて、Configure AI Settings より構成ください。
そしてシステムプロンプトとユーザープロンプトに以下のプロンプトを指定します。今回はkintone の案件管理アプリから取得したデータを営業戦略レポートとして分析するプロンプトを指定しています。
次に設定タブで「Outut In JSON」を「Enabled」にして、JSON スキーマを指定することで、Arc のフロー内で扱いやすいJSON として結果を受けとることが出来ます。
{"type":"object","properties":{"sales_analysis_result":{"type":"object","properties":{"metadata":{"type":"object","properties":{"analysis_date":{"type":"string","description":"YYYY-MM-DD\u5F62\u5F0F"},"analyst":{"type":"string"},"data_source":{"type":"string"}},"required":["analysis_date","analyst","data_source"],"additionalProperties":false},"executive_summary":{"type":"object","properties":{"total_deals":{"type":"integer"},"total_pipeline_value":{"type":"integer"},"weighted_forecast":{"type":"integer"},"average_deal_size":{"type":"integer"},"high_priority_count":{"type":"integer"},"risk_deals_count":{"type":"integer"}},"required":["total_deals","total_pipeline_value","weighted_forecast","average_deal_size","high_priority_count","risk_deals_count"],"additionalProperties":false},"revenue_forecast":{"type":"object","properties":{"current_month":{"type":"object","properties":{"period":{"type":"string"},"forecast_amount":{"type":"integer"},"deal_count":{"type":"integer"},"confidence_level":{"type":"string","enum":["high","medium","low"]},"achievement_rate":{"type":"number"},"comment":{"type":"string"}},"required":["period","forecast_amount","deal_count","confidence_level","achievement_rate","comment"],"additionalProperties":false},"current_quarter":{"type":"object","properties":{"period":{"type":"string"},"forecast_amount":{"type":"integer"},"deal_count":{"type":"integer"},"confidence_level":{"type":"string","enum":["high","medium","low"]},"achievement_rate":{"type":"number"},"comment":{"type":"string"}},"required":["period","forecast_amount","deal_count","confidence_level","achievement_rate","comment"],"additionalProperties":false}},"required":["current_month","current_quarter"],"additionalProperties":false},"priority_deals":{"type":"array","items":{"type":"object","properties":{"rank":{"type":"integer"},"record_id":{"type":"string"},"deal_name":{"type":"string"},"customer_name":{"type":"string"},"amount":{"type":"integer"},"probability":{"type":"integer"},"stage":{"type":"string"},"expected_close_date":{"type":"string"},"priority_level":{"type":"string","enum":["critical","high","medium","low"]},"weighted_value":{"type":"integer"},"days_since_last_action":{"type":"integer"},"urgency_score":{"type":"number"},"recommended_action":{"type":"string"},"risk_factors":{"type":"string"},"next_milestone":{"type":"string"}},"required":["rank","record_id","deal_name","customer_name","amount","probability","stage","expected_close_date","priority_level","weighted_value","days_since_last_action","urgency_score","recommended_action","risk_factors","next_milestone"],"additionalProperties":false}},"risk_analysis":{"type":"object","properties":{"high_risk_deals":{"type":"array","items":{"type":"object","properties":{"record_id":{"type":"string"},"deal_name":{"type":"string"},"customer_name":{"type":"string"},"amount":{"type":"integer"},"stage":{"type":"string"},"probability":{"type":"integer"},"risk_level":{"type":"string","enum":["high","medium","low"]},"days_stagnant":{"type":"integer"},"risk_factors":{"type":"array","items":{"type":"string"}},"impact":{"type":"string"},"recovery_actions":{"type":"array","items":{"type":"object","properties":{"priority":{"type":"string"},"action":{"type":"string"}},"required":["priority","action"],"additionalProperties":false}},"deadline":{"type":"string"}},"required":["record_id","deal_name","customer_name","amount","stage","probability","risk_level","days_stagnant","risk_factors","impact","recovery_actions","deadline"],"additionalProperties":false}}},"required":["high_risk_deals"],"additionalProperties":false},"pipeline_health":{"type":"object","properties":{"stage_distribution":{"type":"array","items":{"type":"object","properties":{"stage_name":{"type":"string"},"count":{"type":"integer"},"total_value":{"type":"integer"},"percentage":{"type":"number"},"weighted_value":{"type":"integer"}},"required":["stage_name","count","total_value","percentage","weighted_value"],"additionalProperties":false}},"conversion_metrics":{"type":"object","properties":{"proposal_to_commitment":{"type":"number"},"commitment_to_win":{"type":"number"}},"required":["proposal_to_commitment","commitment_to_win"],"additionalProperties":false},"health_status":{"type":"string","enum":["good","fair","poor"]},"bottleneck_stage":{"type":"string"},"concerns":{"type":"array","items":{"type":"string"}},"recommendations":{"type":"array","items":{"type":"string"}}},"required":["stage_distribution","conversion_metrics","health_status","bottleneck_stage","concerns","recommendations"],"additionalProperties":false},"customer_analysis":{"type":"object","properties":{"top_customers":{"type":"array","items":{"type":"object","properties":{"name":{"type":"string"},"deal_count":{"type":"integer"},"total_pipeline":{"type":"integer"},"relationship_strength":{"type":"string","enum":["strong","medium","weak"]},"strategy":{"type":"string"}},"required":["name","deal_count","total_pipeline","relationship_strength","strategy"],"additionalProperties":false}}},"required":["top_customers"],"additionalProperties":false},"action_insights":{"type":"object","properties":{"critical_actions":{"type":"array","items":{"type":"object","properties":{"priority":{"type":"string"},"title":{"type":"string"},"target_deals":{"type":"string"},"expected_impact":{"type":"string"},"deadline":{"type":"string"}},"required":["priority","title","target_deals","expected_impact","deadline"],"additionalProperties":false}}},"required":["critical_actions"],"additionalProperties":false},"strategic_insights":{"type":"array","items":{"type":"object","properties":{"priority":{"type":"string"},"category":{"type":"string"},"message":{"type":"string"},"impact":{"type":"string","enum":["high","medium","low"]}},"required":["priority","category","message","impact"],"additionalProperties":false}},"overall_recommendation":{"type":"object","properties":{"focus_this_week":{"type":"object","properties":{"primary":{"type":"string"},"secondary":{"type":"string"},"tertiary":{"type":"string"}},"required":["primary","secondary","tertiary"],"additionalProperties":false},"action_plan":{"type":"array","items":{"type":"string"}},"expected_outcomes":{"type":"array","items":{"type":"string"}}},"required":["focus_this_week","action_plan","expected_outcomes"],"additionalProperties":false}},"required":["metadata","executive_summary","revenue_forecast","priority_deals","risk_analysis","pipeline_health","customer_analysis","action_insights","strategic_insights","overall_recommendation"],"additionalProperties":false}},"required":["sales_analysis_result"],"additionalProperties":false}
またJSON ではなくテキスト形式で受け取るようにプロンプトや設定を編集することで、後続のフローで受け取った分析レポートをメールで担当者に送付したり、Teams にメールで送るといったことも可能です。
