BusinessObjects Board

Unable to fetch data from Service Now Web Services

dataservices realtime
#1

Problem Statement:
Trying to fetch data from ServiceNow web services but getting below error.

Error:
An element named <Product_Name> present in the XML data input does not exist in the XML format used to set up this XML source in data flow <DF_SERVNOW_CLIENTS>. Validate your XML data.
Data flow DF_SERVNOW_CLIENTS|Transform Query-Function2.XML parser failed: See previously displayed error message.

WSDL and other details attached for reference.

System/Config details:
BODS: 4.2 (14.2.4.668)

Source: ServiceNow SOAP Web Services

Details:

WSDL used is running successfully in SOAP UI.

Configured the ‘axis2.xml’ file as in the data services integrator guide. Axis file attached.
https basic authentication
No proxy is used.

Job design:
Using Webservice SOAP datastore. Configured the Keystore and axis path
Details on http://scn.sap.com/thread/3895483

Thanks.
Rishabh Awasthi
WSDL.zip (2.0 KB)

rishabh_awasthi (BOB member since 2016-04-21)

#2

the following error means, there is a mis-match between the response schema and actual response that you are getting from the webservice

an element named <Product_Name> present in the XML data input does not exist in the XML format used to set up this XML source in data flow <DF_SERVNOW_CLIENTS>. Validate your XML data.
Data flow DF_SERVNOW_CLIENTS|Transform Query-Function2.XML parser failed: See previously displayed error message.

use SoapUI to call the same webService using the same input that you are using in DS, and compare the output with the function schema (Response) that you see in the WebService Datastore for this function possibly the Product_Name is not appearing at the correct level in the response XML

manoj_d (BOB member since 2009-01-02)