list_attivita_opportunita
Retrieve activities linked to a specific opportunity in VTENext CRM to track progress and manage follow-ups.
Instructions
Elenca le attività associate a un'opportunità
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| opportunita_id | Yes | ID dell'opportunità (es. 13x42) | |
| limit | No |
Implementation Reference
- index.js:163-177 (handler)The handler for 'list_attivita_opportunita' which queries the 'Activities' table for a given opportunita_id.
server.tool( 'list_attivita_opportunita', 'Elenca le attività associate a un\'opportunità', { opportunita_id: z.string().describe('ID dell\'opportunità (es. 13x42)'), limit: z.number().optional().default(10), }, async ({ opportunita_id, limit }) => { const results = await client.query( `SELECT id, subject, activitytype, date_start, status FROM Activities WHERE related_id = '${opportunita_id}' LIMIT ${limit};` ); return { content: [{ type: 'text', text: JSON.stringify(results, null, 2) }], }; }