Table of Contents

Search

  1. Preface
  2. Transformations
  3. Source transformation
  4. Target transformation
  5. Aggregator transformation
  6. Cleanse transformation
  7. Data Masking transformation
  8. Deduplicate transformation
  9. Expression transformation
  10. Filter transformation
  11. Hierarchy Builder transformation
  12. Hierarchy Parser transformation
  13. Hierarchy Processor transformation
  14. Input transformation
  15. Java transformation
  16. Java transformation API reference
  17. Joiner transformation
  18. Labeler transformation
  19. Lookup transformation
  20. Mapplet transformation
  21. Normalizer transformation
  22. Output transformation
  23. Parse transformation
  24. Python transformation
  25. Rank transformation
  26. Router transformation
  27. Rule Specification transformation
  28. Sequence Generator transformation
  29. Sorter transformation
  30. SQL transformation
  31. Structure Parser transformation
  32. Transaction Control transformation
  33. Union transformation
  34. Velocity transformation
  35. Verifier transformation
  36. Web Services transformation

Transformations

Transformations

Web Services transformation example

Web Services transformation example

The following example demonstrates how to use the Web Services transformation to interact with NetSuite to get product availability details.
You can review this example to learn how to configure a Web Services transformation to structure a SOAP request and response using the NetSuite operation, getItemAvailability. The web service client passes the item ID in the request. The web service then returns information on the latest item availability in a SOAP response.
First, to connect to the web service, create a WSConsumer connection. You add a WSDL that describes the request and response web service messages and configures the necessary security. For this example, we use the following NetSuite connection:
Second, define a business service using the connection. In this case, we use the connection to define a business service and access the getItemAvailability operation:
Third, create a mapping that uses the Web Service transformation. The example mapping includes the following configuration options:
  1. The source is a simple .csv file that includes four fields with the login details and an item ID:
  2. On the Web Service tab, select the business service and operation previously defined:
  3. After you add a Web Services transformation, you can connect the source and see four incoming fields. You can filter your view of the incoming fields to show all fields, mapped fields, unmapped fields, or keys:
  4. In the Request Mapping, the incoming fields are mapped to the SOAP message. The Envelope contains the credentials and the Body contains the item ID, as shown in the following image. You drag incoming fields onto items in the request structure to create the mapping:
  5. On the Response Mapping tab, you map the SOAP message to the output fields you want to use. You can choose Relational or Denormalized format for output fields. This example uses Relational format:
    The system generates these output field groups automatically:
    • FaultGroup, if it is supported by the connection type you are using.
    • Envelope, which contains the documentinfo, if you map the header.
    • One group for each element you have mapped where the cardinality is greater than one.
    The example above has three groups. In the response, you can choose to map or unmap objects and fields by selecting a node in the hierarchy and choosing an option to map (or unmap), as shown in this image. Click the down arrow to display the mapping options for a specific node:
  6. On the Output Fields tab, you can see each group. If needed, you can edit the type, precision, and scale of the fields:
  7. The mapping includes three targets: one for the status, one for the availability, and one for the FaultGroup data:
When the mapping runs, it returns the item availability and status code. If it cannot successfully run, it creates a record in the default target that contains the fault information.