(Please note that older articles might not render correctly in mobile view.)
- Before you Begin
- Upload a New Data Source Table
Note that the API only supports updating a Data Source data, not creating or renaming a Data Source. You must create your Data Source through the web administration before setting up an API Data Source update script.
This method updates the data table of a Data Source.
All URLs below are accessible via HTTPS only (HTTP not allowed). In the sample below, "[fs_id]" and "[ds_id]" represent the FormSpace and data source IDs (visible in the portal).
Document Data Types
CSV, JSON, XML
|delimiter||no||,||For CSV documents, the CSV delimiter.|
|encoding||no||utf-8||Specifies the character encoding of the CSV content. For CSV content generated from Microsoft Windows environments, set this parameter to "windows-1252".|
|suppressPush||no||false||Specifies if the data source update action should trigger any configured push notifications to mobile users|
Work Order ID,Work Type,Contact Name,Estimated Duration
"Work Order ID": 1,
"Work Type": "Installation",
"Contact Name": "D. Smith",
"Estimated Duration": 30
"Work Order ID": 2,
"Work Type": "Maintenance",
"Contact Name": "R. Garcia",
"Estimated Duration": 45
"Work Order ID": 3,
"Work Type": "Warranty",
"Contact Name": "Q. Johnson",
"Estimated Duration": 60
curl -v -k -u user:password -X PUT --upload-file FILENAME.csv https://api.prontoforms.com/api/1.1/formspaces/[fs_id]/sources/[ds_id]/upload.csv
- Replace user with your API Key ID and password with your API Key secret.
- Replace FILENAME with the name of your actual file which should be formatted as per the CSV request body samples above.
- Replace [fs_id] with your formspace ID.
- Replace [ds_id] with your data source ID.
|SourceHeaderTooLong||400||One of the column headers in your data file is too long. Headers can be at most 255 characters.|