orchestrator
latest
false
Orchestrator User Guide
Automation CloudAutomation Cloud Public SectorAutomation SuiteStandalone
Last updated Nov 4, 2024

Managing Test Data Queues in Orchestrator

Overview

Manage test data queues and queue items in Orchestrator. Newly created test data queues are empty but you can upload queue items based on your defined JSON schema, either directly in Orchestrator, or through Studio.

JSON Schema Definition

To create a test data queue, you need to define a JSON schema that formats the data properly. This will support uploading items to your test data queue, where the columns are the first level properties of the JSON content, as defined by your schema.

The following JSON schema example contains a root schema.

{
    "$schema": "http://json-schema.org/draft-07/schema",
    "$id": "http://example.com/example.json",
    "type": "object",
    "title": "The root schema",
    "description": "The root schema comprises the entire JSON document.",
    "default": {},
    "examples": [
        {
            "id": 1,
            "first_name": "John",
            "last_name": "doe",
            "email": "john.doe@aol.com",
            "gender": "male",
            "ip_address": "148.38.201.83",
            "skills": "UHV"
        }
    ],
    "required": [
        "id",
        "first_name",
        "last_name",
        "email",
        "gender",
        "ip_address",
        "skills"
    ],
    "properties": {
        "id": {
            "$id": "#/properties/id",
            "type": "integer",
            "title": "The id schema",
            "description": "An explanation about the purpose of this instance.",
            "default": 0,
            "examples": [
                1
            ]
        },
        "first_name": {
            "$id": "#/properties/first_name",
            "type": "string",
            "title": "The first_name schema",
            "description": "An explanation about the purpose of this instance.",
            "default": "",
            "examples": [
                "John"
            ]
        },
        "last_name": {
            "$id": "#/properties/last_name",
            "type": "string",
            "title": "The last_name schema",
            "description": "An explanation about the purpose of this instance.",
            "default": "",
            "examples": [
                "doe"
            ]
        },
        "email": {
            "$id": "#/properties/email",
            "type": "string",
            "title": "The email schema",
            "description": "An explanation about the purpose of this instance.",
            "default": "",
            "examples": [
                "john.doe@aol.com"
            ]
        },
        "gender": {
            "$id": "#/properties/gender",
            "type": "string",
            "title": "The gender schema",
            "description": "An explanation about the purpose of this instance.",
            "default": "",
            "examples": [
                "male"
            ]
        },
        "ip_address": {
            "$id": "#/properties/ip_address",
            "type": "string",
            "title": "The ip_address schema",
            "description": "An explanation about the purpose of this instance.",
            "default": "",
            "examples": [
                "148.38.201.83"
            ]
        },
        "skills": {
            "$id": "#/properties/skills",
            "type": "string",
            "title": "The skills schema",
            "description": "An explanation about the purpose of this instance.",
            "default": "",
            "examples": [
                "UHV"
            ]
        }
    },
    "additionalProperties": true
}{
    "$schema": "http://json-schema.org/draft-07/schema",
    "$id": "http://example.com/example.json",
    "type": "object",
    "title": "The root schema",
    "description": "The root schema comprises the entire JSON document.",
    "default": {},
    "examples": [
        {
            "id": 1,
            "first_name": "John",
            "last_name": "doe",
            "email": "john.doe@aol.com",
            "gender": "male",
            "ip_address": "148.38.201.83",
            "skills": "UHV"
        }
    ],
    "required": [
        "id",
        "first_name",
        "last_name",
        "email",
        "gender",
        "ip_address",
        "skills"
    ],
    "properties": {
        "id": {
            "$id": "#/properties/id",
            "type": "integer",
            "title": "The id schema",
            "description": "An explanation about the purpose of this instance.",
            "default": 0,
            "examples": [
                1
            ]
        },
        "first_name": {
            "$id": "#/properties/first_name",
            "type": "string",
            "title": "The first_name schema",
            "description": "An explanation about the purpose of this instance.",
            "default": "",
            "examples": [
                "John"
            ]
        },
        "last_name": {
            "$id": "#/properties/last_name",
            "type": "string",
            "title": "The last_name schema",
            "description": "An explanation about the purpose of this instance.",
            "default": "",
            "examples": [
                "doe"
            ]
        },
        "email": {
            "$id": "#/properties/email",
            "type": "string",
            "title": "The email schema",
            "description": "An explanation about the purpose of this instance.",
            "default": "",
            "examples": [
                "john.doe@aol.com"
            ]
        },
        "gender": {
            "$id": "#/properties/gender",
            "type": "string",
            "title": "The gender schema",
            "description": "An explanation about the purpose of this instance.",
            "default": "",
            "examples": [
                "male"
            ]
        },
        "ip_address": {
            "$id": "#/properties/ip_address",
            "type": "string",
            "title": "The ip_address schema",
            "description": "An explanation about the purpose of this instance.",
            "default": "",
            "examples": [
                "148.38.201.83"
            ]
        },
        "skills": {
            "$id": "#/properties/skills",
            "type": "string",
            "title": "The skills schema",
            "description": "An explanation about the purpose of this instance.",
            "default": "",
            "examples": [
                "UHV"
            ]
        }
    },
    "additionalProperties": true
}

Manage Test Data Queues

Create Test Data Queues

  1. Log in to Orchestrator.
  2. Open your folder.
  3. Navigate to Testing>Test Data Queues.
  4. Click Add test data queue.
  5. Enter a Name for your test data queue.
  6. Add an optional Description to help you easily identify the use of each test data queue.
  7. Click Browse to find and upload your JSON schema.
    Important: To create a JSON schema, click How do I create a JSON schema?, and see JSON Schema Definition.
  8. Click Add to save changes.

    Your test data queue is added to the list. You can start uploading items to your queue through:

Edit Test Data Queues

  1. Log in to Orchestrator.
  2. Open your folder.
  3. Navigate to Testing>Test Data Queues.
  4. Select a test data queue and click the vertical ellipsis to open the dropdown menu.
  5. Click Edit.
  6. Configure your test data queue settings.
  7. Click Update to confirm changes.

Delete Test Data Queues

  1. Log in to Orchestrator.
  2. Open your folder.
  3. Navigate to Testing>Test Data Queues.
  4. Select a test data queue and click the vertical ellipsis to open the dropdown menu.
  5. Click Delete.
  6. Click Ok to confirm changes.

Upload Items to Test Data Queues

Before uploading items make sure that you have created a JSON schema and added a test data queue.

  1. Log in to Orchestrator.
  2. Open your folder.
  3. Navigate to Testing and then to Test Data Queues.
  4. Select a test data queue and click the vertical ellipsis and select Upload Items from the dropdown list.
  5. Select a CSV file and click Upload.
    Important: Make sure that your CSV content matches the JSON schema.
    For the previously provided JSON schema , you can use the following matching CSV content, stored in a .csv file.
    id,first_name,last_name,email,gender,ip_address,skills
    1,John,Doe,john.doe@aol.com,male,148.38.201.83,UHVid,first_name,last_name,email,gender,ip_address,skills
    1,John,Doe,john.doe@aol.com,male,148.38.201.83,UHV

Manage Test Data Queue Items

Manage queue items in Orchestrator to prepare your test queues for consumption.

To manage test data queue items, navigate to Testing>Test Data Queues, click the vertical ellipsis on a queue, and then click View Items.

The following table lists the actions that you can take to manage your test data queue items

Action

Description

Procedure

Upload items

Upload items to your test data queue.

  1. In the Test Data Queues page, select a queue and click the vertical ellipsis to open the dropdown menu.
  2. Click Upload Items.

IsConsumed

The item was used in a test data queue. Items flagged as Consumed will be excluded from future test data queue runs.

  1. In the Test Data Queues page, select a queue and click the vertical ellipsis to open the dropdown menu.
  2. Click View Items.
  3. Click the Is-Consumed box on individual items.

Set all items in the queue as consumed

Flag all items as Consumed to be excluded from future test data queue runs.

  1. In the Test Data Queues page, select a queue and click the vertical ellipsis to open the dropdown menu.
  2. Click View Items.
  3. Click Set all items in the queue as consumed.

Set all items in the queue as un-consumed

Flag all items as Un-consumed to be included in future test data queue runs.

  1. In the Test Data Queues page, select a queue and click the vertical ellipsis to open the dropdown menu.
  2. Click View Items.
  3. Click Set all items in the queue as consumed.

Remove

Remove an item from the test data queue.

  1. In the Test Data Queues page, select a queue and click the vertical ellipsis to open the dropdown menu.
  2. Click View Items.
  3. Click Set all items in the queue as consumed.

Was this page helpful?

Get The Help You Need
Learning RPA - Automation Courses
UiPath Community Forum
Uipath Logo White
Trust and Security
© 2005-2024 UiPath. All rights reserved.