request.GetValueAt Syntax to subfields
I have a vendor that is sending me an Abbreviation in FT1:16.4.2 that I need to look up against a table to find the correct ID for.
FT1|1|||20180523161501|20180523161503|CG|1906551^Lipid Profile|||1||||||^^^ LAB&06CL|||Z00.00||00410^Knerr^Joel||721410||30100001^Lipid Profile|
But in my Business Process when I refer to request.GetValueAt("FT1:16.4.2") its not recognizing that this field contains information. Is my syntax wrong?
Comments
Assuming your separators are |~^&
and if I counted correctly than FT1:16.... is empty but FT1:17.4.2 is 06CL
When I look at the message in Message viewer it is showing 06CL as FT1:16.4.2
I was unsure if I counted all separators right.
but if you got it from Message Viewer it should be correct.
did you verify you really got the message in hands? eg, by a TRACE or similar ?
Could you verify the MSH:5 = PROBIL condition?
After many TRACE statements found I was missing (1) after the FT1 in my syntax. So it should be... request.GetValueAt("FT1(1):16.4.2")