Extracting values from Webservice Response

vendredi 29 août 2014

Mirth Version: 3.0.1.7051

Java Version: 1.7.0_25



Hello Everyone,



I know there's tons of samples out there, but every sample i've searched have assisted on getting closer. Can anyone show me the error of my ways...I'm not too experience on webservice setup. I have a channel with a dummy source, on the destination I'm connecting to the webservice and in the response. I'm trying to iterate through the response with NO success. I have tried various ways, but so far, i cannot extract any of the values from the response. So I'm thinking either the webservice response is INCORRECT or i have a syntax error which is driving me crazy! below is the script i have in the destination. Attach is my channel and webservice response.



var rsp = new XML(response.getMessage());

var s = new Namespace('http://ift.tt/sVJIaE');

var ns1 = new Namespace('http://ift.tt/1qLuLGP');

var i = new Namespace('http://ift.tt/1eexYEw');



logger.error('Outside:'+ rsp.s::Body.GetPendingOrdersResponse.i::GetPending OrdersResult.Orders.PartnerOrder.length());



for(var c= 0; c < rsp.s::Body.GetPendingOrdersResponse.i::GetPending OrdersResult.Orders.PartnerOrder.length();c++)

{

logger.error('inside: '+ c);

}



******************

Webservice Response Below

******************



<s:Envelope xmlns:s="http://ift.tt/12PhL6j;

<s:Header/>

<s:Body>

<GetPendingOrdersResponse xmlns="http://ift.tt/1sPKxz5;

<GetPendingOrdersResult xmlns:i="http://ift.tt/1m4M9U6;

<Orders>

<PartnerOrder>

<SequenceNumber>278</SequenceNumber>

<MessageGuid>6f326364-6e11-4038-a088-0f7db8f26aaf</MessageGuid>

<Hl7Document>MSH|^~\&amp;|PracticeFusion|NorthShor eTest|||20140530162200+0000||OML^O21^OML_O21|6f326 364-6e11-4038-a088-0f7db8f26aaf|T|2.5.1|||AL|NE|||||ELINCS_MT-OML-1_1.0
PID|1||123456^^^^PI~0e0cac6d-015b-413c-8840-b10169be18d1^^^^PT||TestAdult^Maria||19641210|F||| 123 Main St^^Anytown^CA^91000||^^^abcd@abcd.com^^510^555123 4~^^^^^451^5555555|||||||||
PV1|1|U||||||||||||||| |||T||||||||||||||||||||||||
IN1|1|Other|27517|Ame ricaid Community Care (MD)|123 w St.^^San Francisco^CA^94121|||123324||||||||TestAdult^Maria |SEL^Self^HL70063|19641210|123 Main St^^Anytown^CA^91000|||||||||||||||||123234435
GT1 |1||TestAdult^Maria||123 Main St^^Anytown^CA^91000|||||P||||||||||
ORC|NW|1403R7 J9||1403R7J9||||||||1234567890^Byrnes^Sean^^^^^^^^ ^^NPI||^^^^^415^6352891||||||||||70 Taylor St^^San Francisco^CA^94101
OBR|1|1403R7J9||5300225^Bilirub in- Direct^99^^^LN|||20140520092100+0000||||O||||||||| RO||||||||
DG1|1||272.2^Mixed hyperlipidemia^I9C|||F|||||||||
ORC|NW|1403R7J9||1 403R7J9||||||||1234567890^Byrnes^Sean^^^^^^^^^^NPI ||^^^^^415^6352891||||||||||70 Taylor St^^San Francisco^CA^94101
TQ1|1||||||||S
OBR|2|1403R7J9|| 5160000^Molecular CG Chromosome Analysis Oncology Study^99^^^LN|||20140521092100+0000||||O|||||||||R O||||||||
NTE|1||Test note
DG1|1||272.2^Mixed hyperlipidemia^I9C|||F|||||||||
OBX|1|ST|Specimen Type^Specimen Type^99||Genital||||||F
</Hl7Document>

</PartnerOrder>

<PartnerOrder>

<SequenceNumber>279</SequenceNumber>

<MessageGuid>b1038099-e8bc-4f2a-a438-d7e640caa269</MessageGuid>

<Hl7Document>MSH|^~\&amp;|PracticeFusion|NorthShor eTest|||20140530162608+0000||OML^O21^OML_O21|b1038 099-e8bc-4f2a-a438-d7e640caa269|T|2.5.1|||AL|NE|||||ELINCS_MT-OML-1_1.0
PID|1||456789^^^^PI~2fec3472-b074-4ff2-83d8-5dabd241c63f^^^^PT||TestChild^Jessica||20070226|F| ||987 Broadway^^Middletown^CA^92001||^^^abc@abc.com^^888 ^5550001~^^^^^415^5555555|||||||||
PV1|1|U|||||||| ||||||||||T||||||||||||||||||||||||
IN1|2|Other|PF PC96|American Administrators|123Test^^SF^CA^94121|||546||||||||T estChild^Jessica|SEL^Self^HL70063|20070226|987 Broadway^^Middletown^CA^92001|||||||||||||||||9876 54321
GT1|1||TestChild^Jessica||987 Broadway^^Middletown^CA^92001|||||P||||||||||
ORC| NW|1403R7JA||1403R7JA||||||||1234567890^Byrnes^Sea n^^^^^^^^^^NPI||^^^^^415^6352891||||||||||70 Taylor St^^San Francisco^CA^94101
OBR|1|1403R7JA||5160095^SPECTYP E^99^^^LN|||20140521092400+0000||||O|||||||||RO||| |||||
DG1|1||102.3^Hyperkeratosis due to yaws^I9C|||F|||||||||
OBX|1|ST|Specimen Type^Specimen Type^99||Vag||||||F
</Hl7Document>

</PartnerOrder>

<PartnerOrder>

<SequenceNumber>462</SequenceNumber>

<MessageGuid>a31a0c1e-393e-42ea-b622-e87401e6b3bf</MessageGuid>

<Hl7Document>MSH|^~\&amp;|PracticeFusion|NorthShor eTest|||20140708005026+0000||OML^O21^OML_O21|a31a0 c1e-393e-42ea-b622-e87401e6b3bf|T|2.5.1|||AL|NE|||||ELINCS_MT-OML-1_1.0
PID|1||1234^^^^PI~04452a55-7dcf-49f5-b6f2-90a6a5fb2b75^^^^PT||TestAdult^Maria||19701210|F||| 123 Main St^^Anytown^CA^91000||^^^a@b.com^^510^5551234~^^^^ ^415^5555555|||||||||
PV1|1|U||||||||||||||||||T|| ||||||||||||||||||||||
IN1|1|Other|47198|Anthem Blue Cross|21555 OXNARD ST A900^^WOODLAND HILLS^CA^91367|||123||||||||TestAdult^Maria|SEL^Se lf^HL70063|19701210|123 Main St^^Anytown^CA^91000|||||||||||||||||123456789
GT1 |1||TestAdult^Maria||123 Main St^^Anytown^CA^91000|||||P||||||||||
ORC|NW|1403R7 SA||1403R7SA||||||||1234567980^Testing^SeanTest^^^ ^^^^^^^NPI||||||||||||
OBR|1|1403R7SA||5700071^Ant i- dsDNA^99^58465-6^^LN|||20140708005000+0000||||O|||||||||RO||||||| |
NTE|1||Test note
DG1|1||272.2^Mixed hyperlipidemia^I9C|||F|||||||||
SPM|1|||BLDV^Blood Venous^HL70487||||||||||Test SPM Note|||20140708005000+0000|||||||||1
ORC|NW|1403R7 SA||1403R7SA||||||||1234567980^Testing^SeanTest^^^ ^^^^^^^NPI||||||||||||
OBR|2|1403R7SA||5302905^AAU RINE^99^12467-7^^LN|||20140708005000+0000||||O|||||||||RO||||||| |
DG1|1||272.2^Mixed hyperlipidemia^I9C|||F|||||||||
SPM|1|||UR^Urine^H L70487||||||||||Test SPM Note 2|||20140708005000+0000|||||||||1
</Hl7Document>

</PartnerOrder>

<PartnerOrder>

<SequenceNumber>463</SequenceNumber>

<MessageGuid>7b46c65a-aa6a-45c9-b12c-70c06c9b1699</MessageGuid>

<Hl7Document>MSH|^~\&amp;|PracticeFusion|NorthShor eTest|||20140708005542+0000||OML^O21^OML_O21|7b46c 65a-aa6a-45c9-b12c-70c06c9b1699|T|2.5.1|||AL|NE|||||ELINCS_MT-OML-1_1.0
PID|1||1234^^^^PI~04452a55-7dcf-49f5-b6f2-90a6a5fb2b75^^^^PT||TestAdult^Maria||19701210|F||| 123 Main St^^Anytown^CA^91000||^^^a@b.com^^510^5551234~^^^^ ^415^5555555|||||||||
PV1|1|U||||||||||||||||||T|| ||||||||||||||||||||||
IN1|1|Other|47198|Anthem Blue Cross|21555 OXNARD ST A900^^WOODLAND HILLS^CA^91367|||123||||||||TestAdult^Maria|SEL^Se lf^HL70063|19701210|123 Main St^^Anytown^CA^91000|||||||||||||||||123456789
GT1 |1||TestAdult^Maria||123 Main St^^Anytown^CA^91000|||||P||||||||||
ORC|NW|1403R7 SB||1403R7SB||||||||1234567980^Testing^SeanTest^^^ ^^^^^^^NPI||||||||||||
OBR|1|1403R7SB||5300110^Alb umin- Serum^99^2862-1^^LN|||20140708005500+0000||||O|||||||||RO||||||| |
DG1|1||401.1^Benign essential hypertension^I9C|||F|||||||||
SPM|1|||URC^Urine clean catch^HL70487|||||||||||||20140708005500+0000||||| ||||1
ORC|NW|1403R7SB||1403R7SB||||||||1234567980^ Testing^SeanTest^^^^^^^^^^NPI||||||||||||
OBR|2|14 03R7SB||5901716^5 Hydroxyindolacetic Acid^99^1694-9^^LN|||||||O|||||||||RO||||||||
DG1|1||401.1^Beni gn essential hypertension^I9C|||F|||||||||
ORC|NW|1403R7SB||140 3R7SB||||||||1234567980^Testing^SeanTest^^^^^^^^^^ NPI||||||||||||
OBR|3|1403R7SB||6010210^ABID ELU^99^^^LN|||||||O|||||||||RO||||||||
DG1|1||401. 1^Benign essential hypertension^I9C|||F|||||||||
ORC|NW|1403R7SB||140 3R7SB||||||||1234567980^Testing^SeanTest^^^^^^^^^^ NPI||||||||||||
OBR|4|1403R7SB||5550500^Hypercoagu lation Order Set^99^3209-4^^LN|||20140708005500+0000||||O|||||||||RO||||||| |
DG1|1||401.1^Benign essential hypertension^I9C|||F|||||||||
SPM|1|||BBL^Blood bag^HL70487|||||||||||||20140708005500+0000||||||| ||1
</Hl7Document>

</PartnerOrder>

</Orders>

<NextQuerySequence>463</NextQuerySequence>

</GetPendingOrdersResult>

</GetPendingOrdersResponse>

</s:Body>

</s:Envelope>




Attached Files





File Type: xml OR_PRACTICEFUSION_MSG.xml (18.8 KB)







Extracting values from Webservice Response
Publié par skills à 07:39

0 commentaires:

Enregistrer un commentaire

Inscription à : Publier les commentaires (Atom)