- Upgrading from v1.x
- Finalized Submissions
- Debugging Mode
- API Error Codes
- API Sessions
- Feature Suggestions
getSubmission() function does pretty much what you'd expect it to do: it retrieves
all information about a form submission. Unlike many other API functions, this one is more
for programmers. It returns a hash of information (where the keys are the database column names
and the values are the actual values in the field, directly from the database) which you can use
for whatever you need.
The function takes two parameters: form ID and submission ID. Both fields are required. Here's an example of how it's called, where the form ID is 2 and submission ID is 550.
Now, assuming your form has database columns called first_name and last_name, you could access those values like so:
Tip: to find out what the database columns are all named, log into Form Tools and go to the Edit Form » Database tab. There, look at the DB column name column. If you haven't already done so, you might want to click the "Smart Fill" button to rename all your database columns to the same values as you form fields. This can simplify working with the database directly since the column names will be more descriptive.