I created a web service in SAP and I tried to call this SOAP web service from google app script.
This WS is in BASIC authentication, in variable response I receive the same wsdl that I pass in input.
I encountered a problem in back-end system call
Unsupported Content Type is received: " "
Someone can help me?
var user = 'user';
var pwd = 'pwd';
var webservice = 'http://xx.xxx.xx.xx:xxxx/sap/bc/srt/wsdl/flv_10002A111AD1/bndg_url/sap/bc/srt/rfc/sap/zdemo_google_ws/100/zdemo_google_ws/zdemo_google_ws?sap-client=100.wsdl';
function readData() {
//Clean up anything currently on the spreadsheet
SpreadsheetApp.getActiveSheet().clear();
try {
//Various XML parsing.
var xml = "<soapenv:Envelope xmlns:soapenv=\"http://schemas.xmlsoap.org/soap/envelope/\" xmlns:urn=\"urn:sap-com:document:sap:soap:functions:mc-style\">"
+"<soapenv:Header/>"
+" <soapenv:Body>"
+" <urn:ZDemoGoogle>"
+" <ItWebs>"
+" <item>"
+" <Protocol></Protocol>"
+" <Tasktype></Tasktype>"
+" <EntryId></EntryId>"
+" <Account></Account>"
+" <Mandt></Mandt>"
+" <Host></Host>"
+" <Port></Port>"
+" <Destination></Destination>"
+" <Path></Path>"
+" <Counter></Counter>"
+" <Calltime></Calltime>"
+" <ExecutionTi></ExecutionTi>"
+" <DataSend></DataSend>"
+" <DataSendTi></DataSendTi>"
+" <DataReceive></DataReceive>"
+" <DataReceiveTi></DataReceiveTi>"
+" </item>"
+" </ItWebs>"
+" </urn:ZDemoGoogle>"
+" </soapenv:Body>"
+"</soapenv:Envelope>"
var options = {
headers: {
"Authorization": "Basic " + Utilities.base64Encode(user + ':' + pwd),
"method" : "post",
"contentType" : "text/xml",
"payload" : xml,
"muteHttpExceptions":true
},
};
//UrlFetchApp is a powerful built-in library from Google
var serviceaddress = webservice ;
var response = UrlFetchApp.fetch(serviceaddress, options);
In order to use UrlFetchApp.fetch()
, it is required to modify option
of your script. So how about this modification?
var options = {
headers: {
"Authorization": "Basic " + Utilities.base64Encode(user + ':' + pwd),
"method" : "post",
"contentType" : "text/xml",
"payload" : xml,
"muteHttpExceptions":true
},
};
var options = {
headers: {"Authorization": "Basic " + Utilities.base64Encode(user + ':' + pwd)},
method: "post",
contentType: "text/xml",
payload: xml,
muteHttpExceptions: true,
};
If this was not the direct solution of your issue, I'm sorry.