Validation Reports

You can download validation reports in JSON format from the Task Completion screen as highlighted:

Follow these steps to get detailed validation reports:

1. You can get your detailed validation reports by hitting the following API: https://get-validation-reports-142-870-master-proxy.devflows.devfactory.com/
2. Do a POST request.
3. With the following Payload: 

   {
       "task_id": <task_id>,
       "source_db_name": <source_db_name>,
       "validation_type": <validation_type>
   }

   Fields: 

   task_id	id of the migration task
   source_db_name  (optional)	to get report only of a particular db in a task
   validation_type (optional)	"pre-migration-validation-summary" or "pre-migration-validation-details" or "post-migration-schema-validation" or "post-migration-data-validation"

Validation report structures:

1. Pre-migration validation report

   {
       "summary": [
           {
              "id": 31,
              "task_id": 17,
              "db_name": "employees",
              "validation_type": "pre-migration-validation-summary",
              "report": []
            }
        ]
   }
   

2. Post-migration schema validation report

   Sample secondary schema migration stats JSON report.

3. Post-migration data validation report 

   Report type: JSON

   {
      "tables_summary": {
          "source": 0,
          "target": 0,
          "common": 0,
          "matched": 0,
          "changed": 0,
          "missing": 0,
          "unexpected": 0
      },
      "tables_diff": {
          "source": [],
          "target": [],
          "common": [],
          "matched": [],
          "changed": [],
          "missing": [],
          "unexpected": []
      },
      "table_row_counts": {
          "source": {
              "<table_name>": 0
          },
          "target": {
              "<table_name>": 0
          },
          "common": [],
          "matched": [],
          "changed": [],
          "missing": [],
          "unexpected": []
      },
      "table_checksums": {
          "source": {
              "<table_name>": 0
          },
          "target": {
              "<table_name>": 0
          },
          "common": [],
          "matched": [],
          "changed": [],
          "missing": [],
          "unexpected": []
      },
      "row_checksums": {}
   }