Adding components for the POST request

Add new components and connect them to use a POST operation to add a movie to a database.

1. Add a tExtractXMLField to your workspace.
2. From Metadata > Db Connections > connection_mysql > Table schemas, drag your movies schema and drop it on your workspace, then select tDBOutput(MySQL).
3. Add a tXMLMap and a tRESTResponse.
4. Connect your tRESTRequest to the tExtractXMLField with a Row > addMovie connection.
5. Connect the tExtractXMLField to the tDBOutput and the tDBOutput to the tXMLMap_3 with Row > Main connections.
6. Connect the tXMLMap_3 to the tRESTResponse_3 with a Row > Main connection and name it newMovie.
7. Drop the movies schema from your repository below the tDBOutput and select tDBInput(MySQL).
8. Add a tLogRow and connect the tDBInput_3 to it using a Row > Main connection.
9. Connect the tDBOutput to the tDBInput_3 with a Trigger > On Component Ok connection.
10. Save your service.

Results

All the components are added and connected, you can now configure them.

Your service should look like this: