How do i get corresponding values from XML response

HI All,

I am using LR 11.04, my script contains soap requests, I need to build a custom request based on few values from response i get from sever.

My XML retures some 1000 data rows in that there are sub-rows like ID, Date, Value1, Type.

I have to use ID, Type, Date in my new custom request only if value1 is "C" (for example), but all rows will not have date fields in those 1000 rows.

So how can i get Date value corresponding to its ID. 

Thanks for help in advance.