Page Comparison

...

{
  "api_key": "########-####-####-####-############",
  "server_url": "https://tx3.qtestnet.com" ,
  "project_ids": ["116893", "117063123456"],
  "fields_to_match": [
    {
      "name": "Status",
      "values": [ "Closed", "Approved" ],
      "constraint": "Field Contains"
    },
    {
      "name": "Priority",
      "values": ["Medium"],
      "constraint": "Field Contains"
    },
    {
      "name": "VERA Approval Status",
      "values": ["Draft"],
      "constraint": "Field Contains"
    },
    {
      "name": "Version",
      "values": ["0.1", "0.2", "0.3"],
      "constraint": "Version Field Contains"
    },
    {
      "name": "Assigned To",
      "values": ["Firstname Lastname"],
      "constraint": "Field Is Equal"
    },
    {
      "name": "Last Modified User",
      "values": ["Firstname Lastname"],
      "constraint": "Field Is ContainsEqual"
    },
    {
      "name": "Date Modified",
      "values": [ "03/0304/2023 101:00:00 PM" ],
	  "constraint": "Date Field Is Greater Than Or Equal"
    }
  ],
  "fields_to_update": [
    {
      "name": "Status",
      "value": "Imported",
      "overwrite": true
    },
    {
      "name": "Description",
      "value": "Approved in previous system",
      "overwrite": false
    }
  ]
}

1. Provide an API Key (optional):

   1. This is the API key available from qTest for the account that will be updating records:

      1. To access your api key, click on the Resources button

         1. Image RemovedImage Added

      2. Then expand the API & SDK section

         1. Image RemovedImage Added

      3. Finally, copy the token after bearer:

         1. Image RemovedImage Added

            
            

            Note
            title Required Permissions
            The account used for the migration utility must have access to edit all tests and fields in the projects being updated.

            
            

   2. This can also be left blank and the utility will ask for the API Key each time it is run.

2. Provide the Server URL:

   1. This is the URL for the qTest server and is required,

3. Provide Project IDs:

   1. Enter a list of Project IDs for the projects that you want the utility to scan.

   2. Project IDs can be obtained from either the URL for a project or the list of Projects in the Administration area:

      1. URL:

         1.  

            Image RemovedImage Added

      2. Project Administration:

         1. As a site admin, access the Administration Area > Projects:

            1. Image RemovedImage Added

         2. The table displays all projects and their ids:

            1. Image RemovedImage Added

   3. This is required and the utility will fail if it is not provided.

4. Provide a list of criteria to match when selecting tests:

   1. Criteria are presented as JSON objects with three properties: Name, Values and Constraint

      1. Name is the qTest Label of the field. This must match exactly with what is in qTest.

      2. Values is a list of string values to match. The utility will match any of the values in the list. This will only work for single select field and text fields. The field must match the text of the value exactly but is case insensitive. The default constraint for text field comparisons is “Field Contains”.

      3. Date fields can be specified for test selection. For date field comparisons, a single date value is specified in the “Values” property in the format “M/d/yyyy h:mm:ss tt" where the month and day are specified in one or two digits, year as four digits and the hour, minutes and minutes seconds as two digits with the AM or PM designation. Multiple date values cannot be specified. The supported Date field constraints are “Date Field Is Equal”, “Date Field Is Less Than”, “Date Field Is Less Than Or Equal”, “Date Field Is Greater Than” and “Date Field Is Greater Than Or Equal”.

      4. User list fields can be specified for test selection. The constraint “User Field Contains” “Field Is Equal” can be used to specify the first and last name defined for the user in the user account profile.

      5. The Version information is saved in the test properties. Selection of the test based on the Version property can be specified with the “Version Field Contains” constraint.

   2. At least one criteria must be present or else the utility will not run.

5. Provide a list of field updates:

   1. Field updates are presented as a list of JSON objects with three properties: Name, Value, and Overwrite

      1. Name is the qTest Label of the field. This must match exactly with what is in qTest.

      2. Value is the value to set the field to or append to the existing value

      3. Overwrite is a boolean indicating if the existing field value should be overwritten or appended to. True or omitting the property will overwrite the contents of the field and false will append to the existing value.

         1. Appending only works for text fields and will be ignored for single select fields.

   2. This is not required for the utility to process.