Vizlib Writeback Table has a Writeback Settings menu to make changes to your writeback configuration quick to action and easy to manage. These settings are found in the right hand panel of the Writeback Table Editor (Figure 1), below the Columns menu.
Figure 1: Writeback Settings
There are 4 sections for Writeback settings.
- Destination contains configuration settings for writeback data output and writeback operations.
- Audit Trail contains settings to enable and customise an audit trail.
- Table Settings manages the formatting of the output table.
- Reload settings configure when writeback operations are performed.
In this article we're going to focus on the properties for the Destination section. If you need further information on Audit Trail, Table Settings and Reload, you can find a link to the article here.
The first set of configuration settings in the Destination section relates to Pick Destination (Figure 2), where you choose if you'd like your writeback output to be written to a file (QVD/CSV/TXT icon on the left), or a REST API response (REST icon on the right).
Figure 2: Pick Destination
Clicking on one of these icons will display a related list of settings.
- Click the QVD/CSV/TXT icon (Figure 3).
- Scroll down to the Folder Settings options.
- Select the Data Connection.
- Click the button to select a connection from the dropdown.
- Click the button to enter the connection name as an expression.
- Select the File type by clicking on the extension name you want.
- Choose the File name.
- Click the button to select a file from the dropdown.
- Click the button to enter the filename as an expression.
Figure 3: Folder Settings
If you're working with an output file, you can also configure the writeback Operation type (Figure 4). The operations are
, You can find out more about operations in our article here.
- Select the operation type you need to use. If you choose an Insert operation, you'll also need to define the insert state.
Figure 4: Operation Type
The Allowed Row Actions setting controls permissions for deleting, adding or duplicating rows (Figure 5). If a 0 is added in the expression text box, the permission is granted, so in this example adding rows is permitted, but deleting or duplicating rows is not.
Figure 5: Allowed Row Actions
You can check these settings by right-clicking on the writeback table in View mode (i.e. closed for editing). This will display the list of available row actions. Figure 6 shows an example where add, delete and duplicate are all permitted.
Figure 6: Allowed Actions List
- Click the REST icon (Figure 7). and go to the REST Settings options.
- Select the endpoint URL for your output by clicking the button to enter the URL.
- Select the Method by clicking on POST, GET or PUT. If you choose GET you can go straight to step 6 as steps 4 and 5 are not required.
- Choose the Payload by clicking on JSON, Form or as Params.
- Choose to send the payload as an Array or a Record/Request.
- Choose an Authentication method from the dropdown (None, Basic, Auth).
- Click on Add Param to add any additional parameters.
- Click on Add Header to add a header.
Figure 7: REST Settings