Quizzes & Exams — Export & Import Endpoints

Quiz / Exam JSON & ZIP export, bulk question import

​

Table of Contents

1. Overview
2. Base URL and Headers
3. Export / Import Endpoints
   • 3.1 Export Quiz JSON
   • 3.2 Import Questions & Options (with images)
   • 3.3 Export Exam JSON
   • 3.4 Export All Exams ZIP
   • 3.5 Export All Quizzes ZIP
4. Business Rules & Edge Cases
5. History Tracking Actions
6. Related Files

​

1. Overview

isQuiz()  ⇔  training_id IS NOT NULL  OR  chapter_id IS NOT NULL   → part of a course (chapter quiz OR training quiz)
isExam()  ⇔  training_id IS NULL     AND chapter_id IS NULL        → standalone, sellable

• Quiz (chapter quiz or training/final quiz) — exported via the /api/quizzes/... routes (§3.1, §3.5). Quiz JSON files additionally carry a belongs_to block naming the parent training/chapter.
• Exam (standalone, both FKs null) — exported via the /api/exams/... routes (§3.3, §3.4).

​

2. Base URL and Headers

{{base_url}}/api

{{base_url}} = http://127.0.0.1:8000
{{token}}    = your_sanctum_token

Accept: application/json
Content-Type: application/json
Authorization: Bearer {{token}}

company_id must be passed explicitly on most endpoints and is validated against the companies table. App\Http\Middleware\CompanyPolicyMiddleware enforces that the value matches the authenticated user’s own company_id (super admins bypass this check).

​

3. Export / Import Endpoints

​

3.1 Export Quiz JSON

GET {{base_url}}/api/quizzes/5/export-json

• Filename format: {slug(label)}-quiz-{Y-m-d-H-i}.json
• Example filename: chapter-1-final-quiz-2026-05-16-14-30.json

{
  "id": 5,
  "company_id": 1,
  "training_id": 3,
  "chapter_id": null,
  "label": "Chapter 1 Final Quiz",
  "slug": "chapter-1-final-quiz",
  "passing_percentage": "60.00",
  "duration": 20,
  "is_published": false,
  "belongs_to": {
    "training": { "id": 3, "label": "Web Development Bootcamp", "slug": "web-development-bootcamp" },
    "chapter": null
  },
  "categories": [
    { "id": 1, "label": "Web Development" }
  ],
  "quiz_questions": [
    {
      "id": 21,
      "label": "CSS stands for Cascading Style Sheets.",
      "quiz_question_type": { "id": 1, "label": "True or False" },
      "quiz_question_options": [
        { "id": 60, "label": "True",  "is_correct": true,  "quiz_question_option_items": [] },
        { "id": 61, "label": "False", "is_correct": false, "quiz_question_option_items": [] }
      ]
    }
  ]
}

belongs_to (quiz exports only). Every exported quiz JSON includes a belongs_to block naming the parent training and/or chapter the quiz lives under — so the file is self-describing even outside the database. Resolution:

• Quiz linked directly to a training (training_id set) → belongs_to.training is filled, belongs_to.chapter is null.
• Quiz linked to a chapter (chapter_id set) → belongs_to.chapter is filled, and belongs_to.training is resolved through the chapter (chapter.training_id), even when the quiz row itself has no training_id.
• Each entry exposes id, label, and (for training) slug; chapter also exposes its training_id. This block is not present in exam exports (§3.3 / §3.4) — exams are standalone and belong to no training/chapter.

​

3.2 Import Questions & Options (with images)

1. Set method to POST, URL to {{base_url}}/api/quizzes/5/import-questions-images
2. Under Headers: add Authorization: Bearer {{token}} and Accept: application/json (do not manually set Content-Type for form-data — Postman sets it automatically with the boundary)
3. Under Body, select form-data
4. Add row: Key = company_id, Type = Text, Value = 1
5. Add row: Key = questions_file, Type = File, Value = select your .json file

{
  "quiz_questions": [
    {
      "quiz_question_type_id": 1,
      "label": "Python uses indentation to define code blocks.",
      "tip": null,
      "explanation": "Python relies on indentation instead of braces {}.",
      "image_url": null,
      "quiz_question_options": [
        { "label": "True",  "is_correct": true  },
        { "label": "False", "is_correct": false }
      ]
    },
    {
      "quiz_question_type_id": 2,
      "label": "Which method converts a string to lowercase in Python?",
      "tip": "It is a built-in string method.",
      "explanation": "`str.lower()` returns the string in lowercase.",
      "image_url": null,
      "quiz_question_options": [
        { "label": "lower()",    "is_correct": true  },
        { "label": "toLower()",  "is_correct": false },
        { "label": "downcase()", "is_correct": false }
      ]
    },
    {
      "quiz_question_type_id": 3,
      "label": "Which of the following are mutable data types in Python? (Select all that apply)",
      "tip": null,
      "explanation": "list and dict are mutable; tuple and str are immutable.",
      "image_url": null,
      "quiz_question_options": [
        { "label": "list",  "is_correct": true,  "quiz_question_option_items": [] },
        { "label": "dict",  "is_correct": true,  "quiz_question_option_items": [] },
        { "label": "tuple", "is_correct": false, "quiz_question_option_items": [] },
        { "label": "str",   "is_correct": false, "quiz_question_option_items": [] }
      ]
    },
    {
      "quiz_question_type_id": 4,
      "label": "Match the Python exception to the error it represents.",
      "tip": null,
      "explanation": null,
      "image_url": null,
      "quiz_question_options": [
        {
          "label": "Dividing by zero",
          "is_correct": true,
          "quiz_question_option_items": [
            { "label": "ZeroDivisionError" }
          ]
        },
        {
          "label": "Accessing a non-existent dictionary key",
          "is_correct": true,
          "quiz_question_option_items": [
            { "label": "KeyError" }
          ]
        }
      ]
    }
  ]
}

image_url — when provided and not null, the server downloads the image via HTTP and registers it as a File record. The URL must be publicly reachable from the server. Set to null to skip image import for a question.

1. Authorize update on the quiz.
2. Verify company_id matches the quiz’s company_id.
3. Destructive replace — deletes all existing questions and options on the quiz.
4. Creates questions, options, and option items (drag & drop only) from the file.
5. Downloads any image_url values, stores files, and links them to the question.
6. History: imported_questions_with_images.

{
  "message": "Questions, options, and images imported successfully.",
  "quiz_id": 5
}

​

3.3 Export Exam JSON

GET {{base_url}}/api/exams/export-json?company_id=1&quiz_id=5

• Filename format: {slug(label)}-exam-{d-m-Y-H-i}.json
• Example filename: advanced-python-exam-16-05-2026-14-30.json
• File content has the same structure as §3.1, minus the belongs_to block (exams are standalone and belong to no training/chapter).

​

3.4 Export All Exams ZIP

GET {{base_url}}/api/exams/export-all-json?company_id=1

• ZIP filename format: exams_export_{d-m-Y-H-i}.zip
• Each exam inside: {slug(label)}-exam-{d-m-Y-H-i}.json

Large companies should expect this to be heavy. Make sure your server’s php.ini allows large uploads: upload_max_filesize = 300M, post_max_size = 300M, memory_limit = 512M, max_execution_time = 600.

​

3.5 Export All Quizzes ZIP

GET {{base_url}}/api/quizzes/export-all-json?company_id=1

• ZIP filename format: quizzes_export_{d-m-Y-H-i}.zip
• Each quiz inside: {slug(label)}-quiz-{d-m-Y-H-i}.json
• Each JSON file has the same structure as §3.1 — including the belongs_to block that records the parent training and/or chapter the quiz belongs to.

Like §3.4, this can be heavy for large companies — give PHP enough headroom (memory_limit = 512M, max_execution_time = 600).

​

4. Business Rules & Edge Cases

• Scope filtering decides 404s. Quiz export routes (/api/quizzes/...) only match isQuiz() rows; exam export routes (/api/exams/...) only match isExam() rows. Cross-using them returns 404.
• belongs_to is quiz-only. Only quiz JSON exports (§3.1, §3.5) carry the belongs_to block. For a chapter quiz (only chapter_id set), the training is resolved through the chapter. Exam exports never include it.
• Question import is destructive. §3.2 deletes all existing questions and options on the target quiz before re-creating them from the file — there is no merge mode. Back up via §3.1 first if needed.
• company_id must match. The import verifies the supplied company_id equals the quiz’s own company_id (422 on mismatch), on top of the tenant CompanyPolicyMiddleware check.
• Image import requires public URLs. image_url values are fetched server-side over HTTP; URLs unreachable from the server cause the import to fail (500).
• Bulk ZIP exports are heavy. Both §3.4 and §3.5 build the entire archive in memory/temp before streaming; ensure PHP memory_limit / max_execution_time are generous for large catalogs.

​

5. History Tracking Actions

The export endpoints (§3.1, §3.3, §3.4, §3.5) are read-only and do not write history rows.

​

6. Related Files

• app/Http/Controllers/Export_Import_Quizzes_Exams_Controller.php — the controller behind every endpoint in this file.
• routes/api.php — Export_Import_Quizzes_Exams_Controller route group.
• app/Models/Quiz.php — parent model (scopes isQuiz, isExam; training() / chapter() relations used to build belongs_to).
• app/Models/QuizQuestion.php, QuizQuestionType.php, QuizQuestionOption.php, QuizQuestionOptionItem.php — the structures serialized into / parsed from the JSON.
• app/Models/Training.php, app/Models/Chapter.php — sources for the belongs_to training/chapter context.
• Quizzes & Exams endpoints — data model, quiz/exam CRUD, and question authoring.
• Quizzes & Exams progress tracking — student attempt lifecycle.