Create report
Create an Excel, CSV or visual report from one form.
POST https://cotlet.dev/api/v1/jotform/forms/{form_id}/reports
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. |
Request
curl -X POST https://cotlet.dev/api/v1/jotform/forms/242831904782058/reports \
-H "Authorization: Bearer $COTLET_API_KEY" \
-H "Content-Type: application/json" \
-d '{"type":"excel","title":"Event registration, week 41"}'result = client.call("jotform", "create_report", {"form_id":"242831904782058","type":"excel","title":"Event registration, week 41"})const result = await cotlet.call('jotform', 'create_report', {"form_id":"242831904782058","type":"excel","title":"Event registration, week 41"});cotlet call jotform create_report --data '{"form_id":"242831904782058","type":"excel","title":"Event registration, week 41"}'Example response
{
"report_id": "5001234567890",
"form_id": "242831904782058",
"title": "Event registration, week 41",
"type": "excel",
"link": "https://www.jotform.com/excel/example-event-registration"
}