When you customize the request form for a blueprint, you add information in a table format. The data that is presented in the table might be manually provided or based on an external source.

Provided CSV Data Example

In this use case, you have a table of values that you provide in the custom request form. You provide the information in the table as a constant value source. The source is based on a CSV data structure where the first row header. The headers are the column IDs separated by a comma. Each additional row is the data that appears in each row in the table.

  1. Add the Data Grid generic element to the design canvas.

  2. Select the data grid and define the values in the properties pane.

    Properties pane for the data grid

    Label

    ID

    Type

    Username

    username

    String

    Employee ID

    employeeId

    Integer

    Manger

    manager

    String

    Define the CSV values.

    username,employeeId,manager
    leonardo,95621,Farah
    vindhya,15496,Farah
    martina,52648,Nikolai

  3. Verify that the data grid displays the expected data in the blueprint request form.

    Data grid in the custom request form

External Source Example

This example uses the previous example but the values are based on a vRealize Orchestrator action. Although this is a simple action example, but you can use a more complex action that you retrieve this information from a local database or system.

  1. In vRealize Orchestrator, configure an action, getUserDetails, with an array similar to the following example.

    vRealize Orchestrator action to populate a custom form data grid

    Use the following script example.

    return [{"username":"Fritz", "employeeId":6096,"manager":"Tom"}]

  2. In vRealize Automation, add the data grid and configure the data grid columns with the following values.

    Label

    ID

    Type

    Username

    username

    String

    Employee ID

    employeeId

    Integer

    Manger

    manger

    String

  3. In the Value source list, select External source.

  4. In Select action, enter getUserDetails and select the action you created in vRealize Orchestrator.

  5. Save and verify the table in the request form.

    Data grid populated by vRealize Orchestrator action