...
- Click on the Form Properties
icon in the toolbar at the top of the form.
- Select the Document Actions tab and the Send Data sub-tab.
- Select Manually set document URIs.
- You should see the Document name 'createOrder', which is the data source we are interested in.
- Set the Write URL to: http://localhost:8082/database/BIRT/createOrderDetail
- Leave the Read method empty.
- Set the Write method to POST.
- Click the Submit button.
When the form is submitted, will issue an HTTP POST request to the above URL sending the createOrderDetail XML document in the payload. The database connector will map this to the <create> operation of the createOrderDetail query that we defined above, will use the data in the XML document to resolve the query. Since there are multiple line items, the query will be executed once for each Order line item thereby inserting the multiple line items for an Order.
...