Using the data grid element in the Service Broker custom form designer

If you use a data grid element in a custom form, the data that is presented in the table might be manually provided.

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 defines the grid headers. 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.
   
   

   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 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, you can use a more complex action where you retrieve this information from a another database or system.

1. In vRealize Orchestrator, configure an action, getUserDetails, with an array similar to the following example.
   
   
   1. On the General tab, enter the name getUserDetails and provide a Module name.
   2. On the Script tab, use the following script example.

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

   3. In the Return type area, clear the initial selection and click New Composite Type.
   4. Define a new composite type named UserDetails and add the following fields, then click Create.

      Field	Type
      username	string
      employeeId	number
      manager	string

   5. In the Return type area, click Array.
   6. Version and save the action.
2. In Service Broker, add the data grid and use the Values tab to 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 Default value, Value source list, select External source.
4. In Select action, enter getUserDetails and select the action you created in vRealize Orchestrator.
5. Save the form.
6. In the catalog, verify the table in the request form.