Integration using Appian Advance webservice query function

Hello All,

We are using appian Advance web service query function to consume a SOAP wsdl. Below is the code snippet.When executing we are getting errors.Please let me know what will is issue and how to resolve this.I suspect there is some problem with SOAPBody xml but not able to know exactly.Appreciate all the details.

Input

fn!advancedwebservicequery(


wsdlUrl: "adsvcs.dev.myjonline.com/.../CorporateActionsService.svc

serviceNamespace: "schemas.myjonline.com/.../1.0",

serviceName: "CorporateActionsService",

soapBodyXml:"<wsdl:CorporateActionsRequest xmlns:wsdl='schemas.myjonline.com/.../1.0 '><RequestedDate>5</RequestedDate><RequestedIndex>10</RequestedIndex></wsdl:CorporateActionsRequest>",

serviceAuthentication: {
keystoreSystemKey: "corporateactions.service",
keystoreDocument: cons!CA_KEYSTORE_DOC

}

)

 

Output

 

Dictionary Error Occurred: true Error Message:

"XML reader error: javax.xml.stream.XMLStreamException: Parse Error at [row,col]:[1,50]

Message: White spaces are required between publicId and systemId."

ResponseHTTPHeaderKeys: List of Text String: 0 items

ResponseHTTPHeaderValues: List of Text String: 0 items

ResponseSOAPHeadersXml: List of Text String: 0 items ResponseXml: null (Text)

 

Cheers

RajHasti

  Discussion posts and replies are publicly visible

Parents
  • Also I have updated the call like below and used toxml still i am getting error

    Input
    load(
    local!request: 'type!{schemas.myjonline.com/.../1.0}CorporateActionRequest'(
    RequestedDate: "01/07/2019",
    RequestedIndex: "0"
    ),
    local!body: toxml(
    local!request
    ),
    local!advanceWebserviceCall: fn!advancedwebservicequery(
    wsdlUrl: "adsvcs.dev.myjonline.com/.../CorporateActionsService.svc
    serviceNamespace: "schemas.myjonline.com/.../1.0""",
    serviceName: "CorporateActionsService",
    soapBodyXml: local!body,
    serviceAuthentication: {
    keystoreSystemKey: "corporateactions.service",
    keystoreDocument: cons!CA_KEYSTORE_DOC
    },
    httpHeaderKeys: {
    "Content-Type"
    },
    httpHeaderValues: {
    "text/xml;charset=UTF-8"
    }
    ),
    with(
    local!body
    /*,*/
    /*local!advanceWebserviceCall*/
    )
    )


    Error


    Dictionary
    ErrorOccurred: true
    ErrorMessage: "XML reader error: javax.xml.stream.XMLStreamException: ParseError at [row,col]:[1,50]
    Message: White spaces are required between publicId and systemId."
    ResponseHTTPHeaderKeys: List of Text String: 0 items
    ResponseHTTPHeaderValues: List of Text String: 0 items
    ResponseSOAPHeadersXml: List of Text String: 0 items
    ResponseXml: null (Text)
Reply
  • Also I have updated the call like below and used toxml still i am getting error

    Input
    load(
    local!request: 'type!{schemas.myjonline.com/.../1.0}CorporateActionRequest'(
    RequestedDate: "01/07/2019",
    RequestedIndex: "0"
    ),
    local!body: toxml(
    local!request
    ),
    local!advanceWebserviceCall: fn!advancedwebservicequery(
    wsdlUrl: "adsvcs.dev.myjonline.com/.../CorporateActionsService.svc
    serviceNamespace: "schemas.myjonline.com/.../1.0""",
    serviceName: "CorporateActionsService",
    soapBodyXml: local!body,
    serviceAuthentication: {
    keystoreSystemKey: "corporateactions.service",
    keystoreDocument: cons!CA_KEYSTORE_DOC
    },
    httpHeaderKeys: {
    "Content-Type"
    },
    httpHeaderValues: {
    "text/xml;charset=UTF-8"
    }
    ),
    with(
    local!body
    /*,*/
    /*local!advanceWebserviceCall*/
    )
    )


    Error


    Dictionary
    ErrorOccurred: true
    ErrorMessage: "XML reader error: javax.xml.stream.XMLStreamException: ParseError at [row,col]:[1,50]
    Message: White spaces are required between publicId and systemId."
    ResponseHTTPHeaderKeys: List of Text String: 0 items
    ResponseHTTPHeaderValues: List of Text String: 0 items
    ResponseSOAPHeadersXml: List of Text String: 0 items
    ResponseXml: null (Text)
Children