Hi Vijitha, Thanks for the support. First I have tried out the above scenario. it works fine and retrieved the Email_ID and Record_ID However when I applied to suggested Xpath configurations to my API, It not functioned. An empty value is returned.
Could you tell me what is the reason for that. *Senuwan Withana* Software Engineer - Support Team | WSO2 Email : [email protected] Mobile: 94773212853 Web: http://www.wso2.com On Sat, Jan 6, 2018 at 6:20 PM, Vijitha Ekanayake <[email protected]> wrote: > Hi Senuwan, > > I tried this in EI WUM updated pack with below API configurations and was > able to get CUSTOMER_EMAIL and RECORD_ID by defining data service namespace > inside property mediator. > > *API configurations* > > <api xmlns="http://ws.apache.org/ns/synapse"; > name="ContextServiceAPI-2.0.0" context="/context-2.0.0"> > <resource methods="DELETE OPTIONS POST PUT GET" url-mapping="/*"> > <inSequence> > <call> > <endpoint> > <address uri="http://www.mocky.io/v2/ > 5a50c0d32f0000fc128d52ee"> > <timeout> > <duration>30000</duration> > <responseAction>discard</responseAction> > </timeout> > <suspendOnFailure> > <initialDuration>0</initialDuration> > <progressionFactor>1.0</progressionFactor> > <maximumDuration>0</maximumDuration> > </suspendOnFailure> > </address> > </endpoint> > </call> > <log level="custom"> > <property xmlns:m0="http://ws.wso2.org/dataservice"; > name="EmailID" expression="//m0:CUSTOMER_EMAIL"/> > <property xmlns:m0="http://ws.wso2.org/dataservice"; > name="Record_ID" expression="//m0:RECORD_ID"/> > </log> > <respond/> > </inSequence> > </resource> > </api> > > *Request* > > curl -v http://localhost:8280/context-2.0.0/abc > > *Output in the console* > > [2018-01-06 18:15:15,206] [EI-Core] INFO - LogMediator EmailID = > [email protected], Record_ID = 138 > > Could you try your scenario with suggested Xpath configurations as above? > > Thanks, > Vijitha. > > > On Sat, Jan 6, 2018 at 3:34 PM, Senuwan Withana <[email protected]> wrote: > >> Hi Team, >> >> In my Scenario, I want to get Email_ID and Record_ID from the database >> response. >> Response is correctly come to the wire-log. But I could not able to log >> the Email_ID and Record_ID. >> >> I have tried out following Xpath expressions but non of those give me >> the correct result. >> >> >> [1]. $body/m0:Entries/m0:Entry/m0:CUSTOMER_EMAIL/text() - Not work >> [2]. "//*[local-name()='CUSTOMER_EMAIL']"- Not work >> [3].$body /Entries/Entry/CUSTOMER_EMAIL/text()- Not work >> [4].//body/Entries/Entry/CUSTOMER_EMAIL/text()- Not work >> [5].$body - Works, but all the data log. >> >> >> >> [2018-01-06 15:08:24,160] [EI-Core] DEBUG - content << "?xm" >> [2018-01-06 15:08:24,160] [EI-Core] DEBUG - content << "l version='1.0' >> encoding='UTF-8'?><soapenv:Envelope xmlns:soapenv="http://schemas. >> xmlsoap.org/soap/envelope/"><soapenv:Body><Entries xmlns=" >> http://ws.wso2.org/dataservice";><Entry><RECORD_ID> >> 138</RECORD_ID><CUSTOMER_EMAIL>[email protected]</CUSTOMER_ >> EMAIL><CAR_MODEL>Alto</CAR_MODEL><BODY_COLOR>blue</BODY_ >> COLOR><ENGINE_CAPACITY>800</ENGINE_CAPACITY><INTERIOR_ >> MATERIAL></INTERIOR_MATERIAL><SUN_ROOF>Yes</SUN_ROOF>< >> HEATED_LEATHER_SEATS>Yes</HEATED_LEATHER_SEATS><NAVIGATI >> ON>No</NAVIGATION><AUTOMATIC_TAILGATE>No</AUTOMATIC_ >> TAILGATE><STATUS>Approved</STATUS><INTERIOR_COLOR>Pink</ >> INTERIOR_COLOR><TIRE_SIZE>5T</TIRE_SIZE></Entry></Entries></ >> soapenv:Body></soapenv:Envelope>" >> [2018-01-06 15:08:24,161] [EI-Core] DEBUG - content << "[\r]" >> [2018-01-06 15:08:24,161] [EI-Core] DEBUG - content << "[\n]" >> [2018-01-06 15:08:24,161] [EI-Core] DEBUG - content << "0" >> [2018-01-06 15:08:24,161] [EI-Core] DEBUG - content << "[\r]" >> [2018-01-06 15:08:24,161] [EI-Core] DEBUG - content << "[\n]" >> [2018-01-06 15:08:24,161] [EI-Core] DEBUG - content << "[\r]" >> [2018-01-06 15:08:24,161] [EI-Core] DEBUG - content << "[\n]" >> [2018-01-06 15:08:24,161] [EI-Core] DEBUG - header << "[\r][\n]" >> [2018-01-06 15:08:24,163] [EI-Core] INFO - LogMediator Body************ >> = <soapenv:Body xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/ >> "><Entries xmlns="http://ws.wso2.org/dataservice";><Entry><RECORD_ID> >> 138</RECORD_ID><CUSTOMER_EMAIL>[email protected]</CUSTOMER_ >> EMAIL><CAR_MODEL>Alto</CAR_MODEL><BODY_COLOR>blue</BODY_ >> COLOR><ENGINE_CAPACITY>800</ENGINE_CAPACITY><INTERIOR_ >> MATERIAL/><SUN_ROOF>Yes</SUN_ROOF><HEATED_LEATHER_SEATS> >> Yes</HEATED_LEATHER_SEATS><NAVIGATION>No</NAVIGATION>< >> AUTOMATIC_TAILGATE>No</AUTOMATIC_TAILGATE><STATUS> >> Approved</STATUS><INTERIOR_COLOR>Pink</INTERIOR_COLOR>< >> TIRE_SIZE>5T</TIRE_SIZE></Entry></Entries></soapenv:Body> >> [2018-01-06 15:08:24,164] [EI-Core] INFO - LogMediator Email************ >> = >> [2018-01-06 15:08:24,186] [EI-Core] DEBUG - wire HTTP-Listener I/O >> dispatcher-3 << "HTTP/1.1 202 Accepted[\r][\n]" >> [2018-01-06 15:08:24,189] [EI-Core] DEBUG - wire HTTP-Listener I/O >> dispatcher-3 << "Content-Type: text/xml; charset=UTF-8[\r][\n]" >> >> >> >> >> Any suggestion to for the correct Xpath Expression. >> >> Thanks. >> >> *Senuwan Withana* >> Software Engineer - Support Team | WSO2 >> >> Email : [email protected] >> Mobile: 94773212853 >> Web: http://www.wso2.com >> >> >> >> _______________________________________________ >> Dev mailing list >> [email protected] >> http://wso2.org/cgi-bin/mailman/listinfo/dev >> >> > > > -- > Vijitha Ekanayake > Senior Software Engineer*, *WSO2, Inc.; http://wso2.com/ > Mobile : +94 777 24 73 39 | +94 718 74 44 08 > lean.enterprise.middleware >
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
