Skip to Content
Information
This documentation supports the 20.02 version of BMC CMDB.To view an earlier version, select the version from the Product version menu.

Exporting web services data in Atrium Integrator Spoon

You can export web services data using the Web services lookup step. However, there are certain limitations with just using the Web services lookup plug-in. You need a use SOAP interface and generate the XML you need and push that to the web service using the HTTP Post step. For more information about limitations of the Web services lookup step refer to the Spoon User Guide. 

Related topics

Managing-complex-jobs-using-Atrium-Integrator-Spoon


You can also refer to the following sample transformation to export web services data:

  • Annotated SOAP Web Service call.ktr
  • WebServicesMovieListingAsHTTP.ktr

These sample transformations are available in the Samples folder, which is located at the following location: 
<ARInstallationDirectory>diserver\data-integration\samples\transformations


To export web services data

  1. Using a SOAP interface, create an XML to get data from the web service.
  2. Open a new transformation in Atrium Integrator Spoon.
  3. Add the Text file input step.
    1. Double-click the step. The Text File Input dialog box appears.
    2. In the Filename field, enter the location of SOAP XML file.
  4. Add the Add constant step.
    1. Double-click the step. The Add constant values dialog box appears.
    2. In the Values column, enter the location of the web service.
  5. Add the HTTP Post step.
    1. Double-click the step. The HTTP Post web service dialog box appears.
    2. Click the General tab.
    3. In the URL field, enter the enter the location of the web service.
  6. Add the Text file output step.
  7. Save and run the job.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*

BMC CMDB 20.02