How to Use ProProfs API to Capture Learners' Data for a Database/Website

 

Using our API, you can capture quiz data on your website or web-server with ease.

 

Example Use Cases of Capture API

• Inserting lead capture into your own database such as name, email, etc. of quiz taker
• Inserting names and information for people that take the test into SugarCRM, SalesForce, or any other CRM system
• Triggering emails or any other process on your website when someone takes the test

 

This feature requires minor programming at your end to accept the data sent by ProProfs. There are two ways you can capture data through API.

 

How it works

 

Whenever someone takes your quiz, your callback script will be called, which will accept the data. After accepting the data, you can write any custom code such as inserting into your database or CRM or triggering some business logic process.

 

Please follow the steps below to set up the callback URL:

 

Go to the Settings page and click on Advanced. Enable "Notification via API". Type the call back URL indicating where the script is on your site. This is the URL of the script which will accept the data in the REQUEST method. Select the "Query String/REQUEST" or "JSON" option from the drop-down menu.

 

 

This integration can be done either through the REQUEST method or the JSON method.

 

Examples for both have been given below. Both methods use the same variable and variable attributes. The variables have been given in the table.

 

#	Variable Name	Variable Description	Data Type	Example (PHP)
1	result_id	A unique ID to identify an attempt	INT	$_REQUEST['result_id']
2	status	New: Refers to a new attempt.           Update: Refers to a score update on an existing attempt such as an instructor grading essay or assigning bonus points to update a student's score. Update existing score with the help of result_id in such a case.	VARCHAR	$_REQUEST['status_id']
3	quiz_id	A unique ID which will identify your quiz.	INT	$_REQUEST['quiz_id']
4	quiz_title	A unique quiz title to identify your quiz.	VARCHAR	$_REQUEST['quiz_title']
5	quiz_name	Name of your quiz.	VARCHAR	$_REQUEST['quiz_name']
6	attempt_date	The date and time stamp of the attempt (UNIX TIMESTAMP)	TIMESTAMP	$_REQUEST['attempt_date']
7	total_marks	Total number of marks you set for the quiz. Eg: 100.	INT	$_REQUEST['total_marks']
8	user_obtained_marks	Total number of marks obtained by the quiz taker.	INT	$_REQUEST['user_obtained_marks']
9	user_percent_marks	Percentage marks of quiz taker.	INT	$_REQUEST['user_percent_marks']
10	user_totalcorrect_answers	Total number of correct answers by quiz taker.	INT	$_REQUEST['user_totalcorrect_answers']
11	user_totalwrong_answers	Total number of wrong answers/anwer by the quiz taker.	INT	$_REQUEST['user_totalwrong_answer']
12	user_Id	Quiz taker's ID	VARCHAR	$_REQUEST['user_Id']
13	user_Email	Quiz taker's email address.	VARCHAR	$_REQUEST['user_Email']
14	user_Address	Quiz taker's address	VARCHAR	$_REQUEST['user_Address']
15	user_City	Quiz taker's city	VARCHAR	$_REQUEST['user_City']
16	user_State	Quiz taker's state	VARCHAR	$_REQUEST['user_State']
17	user_Zipcode	Quiz taker's zipcode	VARCHAR	$_REQUEST['user_Zipcode']
18	user_Phone	Quiz taker's phone number	VARCHAR	$_REQUEST['user_Phone']
19	user_name	Quiz taker's name	VARCHAR	$_REQUEST['user_name']
20	min_pass_marks	Minimum passing marks	INT	$_REQUEST['min_pass_marks']

 

REQUEST Method

 

To get started, you would need to make a file (your callback script) which will accept the data sent by the quiz through REQUEST method.

 

Example:

 

This example uses PHP & MySQL. Test this feature using PHP for server scripting.

 

Step 1: SQL: Create a table with the following SQL query:

 

 

Step 2: PHP: Given below is the sample code that you can use to code what data is retrieved.

 

 

 

Step 3: Download and implement the following PHP code to retrieve data.

 

Click here to download the PHP script (responsetest.php)

 

JSON Method
 

You can get JSON data by using the POST request. The sample code below shows how data can be retrieved. The POST request is enough to retrieve the data in the JSON method.

 

JSON gets two additional attributes and variables over the REQUEST method. With JSON, you can retrieve data for custom questions and tag-based scores.

 

 

 

 

 

Related Articles:

ProProfs REST API Guide
How To Auto-enroll Learners To Classroom Using API
How To Track Progress Of Learners In My Systems Using API