Create report
Create an Excel, CSV or visual report from one form.
MCP tool jotform_write → create_report
write Confirm
Creates a report on one form and returns its link. Excel and CSV reports are plain data exports with the fields you pick, all fields by default. A visual report is the default one Report Builder makes, with the form title and charts for the responses. A report link can reach people outside the form, so the access level of a visual report stays as Jotform sets it and is returned in the response. By default you confirm each call; you can switch that off for this tool.
Parameters
| Name | Type | Description |
|---|---|---|
| form_id string required | string | Form ID from list_forms. |
| type enum required | enum | excel, csv or visual. |
| title string | string | Report name. Default: the form title. |
| field_ids array | array | Field IDs to include in an Excel or CSV report. Default: all fields. |
tools/call
{
"jsonrpc": "2.0",
"id": 1,
"method": "tools/call",
"params": {
"name": "jotform_write",
"arguments": {
"operation": "create_report",
"arguments": {
"form_id": "242831904782058",
"type": "excel",
"title": "Event registration, week 41"
}
}
}
}Example response
{
"content": [
{
"type": "text",
"text": "{ ... same JSON as structuredContent ... }"
}
],
"structuredContent": {
"report_id": "5001234567890",
"form_id": "242831904782058",
"title": "Event registration, week 41",
"type": "excel",
"link": "https://www.jotform.com/excel/example-event-registration"
},
"isError": false
}