|
Hi,
I'm new to VB.net and totally new to XML. I am building a program that receives a response to a XML inquiry from hwresponse.GetResponseStream. So far I have been able to submit the request and receive a response. I now need take that response (in the form of a string) and convert it to a format which will allow me to make decisions based on it. Perhaps by creating dataset/datatable and passing to variables.
I've spent days Googling an can't find anything in VB.net that fits. I know this is down to my lack of knowledge and a tiny brain. I would be eternally grateful to anyone who could help.
Example of response string:
<ew:quote_a2 xmlns:ew="http://www.reifen.net"><documentid>Stock Equiry<variant>5<errorhead><errorcode>915<buyerparty><partyid>4564564<agencycode>91<orderline><lineid>10<orderedarticle><articleidentification><eanuccarticleid>EAN<articledescription><articledescriptiontext><availability>0<requestedquantity><quantityvalue>200<error><errorcode>0<scheduledetails><deliverydate>9999-12-31<availablequantity><quantityvalue>0<orderline><lineid>20<orderedarticle><articleidentification><eanuccarticleid>3188642010025<articledescription><articledescriptiontext><availability>0<requestedquantity><quantityvalue>200<error><errorcode>0<scheduledetails><deliverydate>9999-12-31<availablequantity><quantityvalue>0<orderline><lineid>30<orderedarticle><articleidentification><eanuccarticleid>3188642037114<articledescription><articledescriptiontext><availability>0<requestedquantity><quantityvalue>200<error><errorcode>0<scheduledetails><deliverydate>9999-12-31<availablequantity><quantityvalue>0<orderline><lineid>40<orderedarticle><articleidentification><eanuccarticleid>3188642146762<articledescription><articledescriptiontext><availability>0<requestedquantity><quantityvalue>200<error><errorcode>0<scheduledetails><deliverydate>9999-12-31<availablequantity><quantityvalue>0<orderline><lineid>50<orderedarticle><articleidentification><eanuccarticleid>3188642256645<articledescription><articledescriptiontext><availability>0<requestedquantity><quantityvalue>200<error><errorcode>0<scheduledetails><deliverydate>9999-12-31<availablequantity><quantityvalue>0<orderline><lineid>60<orderedarticle><articleidentification><eanuccarticleid>3188642258182<articledescription><articledescriptiontext><availability>0<requestedquantity><quantityvalue>200<error><errorcode>0<scheduledetails><deliverydate>9999-12-31<availablequantity><quantityvalue>0<orderline><lineid>70<orderedarticle><articleidentification><eanuccarticleid>3188642258199<articledescription><articledescriptiontext><availability>0<requestedquantity><quantityvalue>200<error><errorcode>0<scheduledetails><deliverydate>9999-12-31<availablequantity><quantityvalue>0<orderline><lineid>80<orderedarticle><articleidentification><eanuccarticleid>3188642276841<articledescription><articledescriptiontext><availability>0<requestedquantity><quantityvalue>200<error><errorcode>0<scheduledetails><deliverydate>9999-12-31<availablequantity><quantityvalue>0<orderline><lineid>90<orderedarticle><articleidentification><eanuccarticleid>3188642315786<articledescription><articledescriptiontext><availability>0<requestedquantity><quantityvalue>200<error><errorcode>0<scheduledetails><deliverydate>9999-12-31<availablequantity><quantityvalue>0<orderline><lineid>100<orderedarticle><articleidentification><eanuccarticleid>3188642323231<articledescription><articledescriptiontext><availability>0<requestedquantity><quantityvalue>200<error><errorcode>0<scheduledetails><deliverydate>9999-12-31<availablequantity><quantityvalue>0"
|
|
|
|
|
What does that data represent and what do you want to extract from it? From the repetition pattern it looks as if the query has returned 9 items but you haven't given us much of a clue.
Stock Equiry591545645649110EAN
020009999-12-31 02 03188642010025
020009999-12-31 03 03188642037114
020009999-12-31 04 03188642146762
020009999-12-31 05 03188642256645
020009999-12-31 06 03188642258182
020009999-12-31 07 03188642258199
020009999-12-31 08 03188642276841
020009999-12-31 09 03188642315786
020009999-12-31 010 03188642323231
020009999-12-31 0
|
|
|
|
|
Firstly. Thank you for taking the time to reply.
I receive the response back in a continious string. It's a response to a stock enquiry but in XML format it reads.
The XMl post reads:
Firstly. Thank you for taking the time to reply.
I receive the response back in a continious string. It's a response to a stock enquiry but in XML format it reads.
The XMl post reads:
<pre lang="xml"><?xml version="1.0" encoding="UTF-8"?>
<ew:inquiry_A2 xmlns:ew="http://www.reifen.net">
<DocumentID>A2</DocumentID>
<Variant>5</Variant>
<BuyerParty>
<PartyID>300000</PartyID>
<AgencyCode>91</AgencyCode>
</BuyerParty>
<OrderLine>
<LineID>10</LineID>
<OrderedArticle>
<ArticleIdentification>
<EANUCCArticleID>5452000877154</EANUCCArticleID>
</ArticleIdentification>
<RequestedQuantity>
<QuantityValue>200</QuantityValue>
</RequestedQuantity>
</OrderedArticle>
</OrderLine>
<OrderLine>
<LineID>10</LineID>
<OrderedArticle>
<ArticleIdentification>
<EANUCCArticleID>5452001082922</EANUCCArticleID>
</ArticleIdentification>
<RequestedQuantity>
<QuantityValue>200</QuantityValue>
</RequestedQuantity>
</OrderedArticle>
</OrderLine>
</ew:inquiry_A2></pre>
An example reply would be:
<pre lang="xml"><?xml version="1.0" encoding="UTF-8" ?>
<ew:quote_A2 xmlns:ew="http://www.reifen.net">
<DocumentID>A2</DocumentID>
<Variant>5</Variant>
<ErrorHead>
<ErrorCode>0</ErrorCode>
</ErrorHead>
<BuyerParty>
<PartyID>305026</PartyID>
<AgencyCode>91</AgencyCode>
</BuyerParty>
<OrderLine>
<LineID>10</LineID>
<OrderedArticle>
<ArticleIdentification>
<ManufacturersArticleID>520654</ManufacturersArticleID>
<EANUCCArticleID>5452000877154</EANUCCArticleID>
</ArticleIdentification>
<ArticleDescription>
<ArticleDescriptionText>205/55R16 91H OPTIGRIP FP</ArticleDescriptionText>
</ArticleDescription>
<Availability>3</Availability>
<RequestedQuantity>
<QuantityValue>200</QuantityValue>
</RequestedQuantity>
<Error>
<ErrorCode>0</ErrorCode>
</Error>
<ScheduleDetails>
<DeliveryDate>9999-12-31</DeliveryDate>
<AvailableQuantity>
<QuantityValue>200</QuantityValue>
</AvailableQuantity>
</ScheduleDetails>
</OrderedArticle>
</OrderLine>
<OrderLine>
<LineID>10</LineID>
<OrderedArticle>
<ArticleIdentification>
<ManufacturersArticleID>522794</ManufacturersArticleID>
<EANUCCArticleID>5452001082922</EANUCCArticleID>
</ArticleIdentification>
<ArticleDescription>
<ArticleDescriptionText>205/55R16 91H UG 8 MS FP</ArticleDescriptionText>
</ArticleDescription>
<Availability>2</Availability>
<RequestedQuantity>
<QuantityValue>200</QuantityValue>
</RequestedQuantity>
<Error>
<ErrorCode>0</ErrorCode>
</Error>
<ScheduleDetails>
<DeliveryDate>2013-02-04</DeliveryDate>
<AvailableQuantity>
<QuantityValue>5</QuantityValue>
</AvailableQuantity>
</ScheduleDetails>
<ScheduleDetails>
<DeliveryDate>9999-12-31</DeliveryDate>
<AvailableQuantity>
<QuantityValue>195</QuantityValue>
</AvailableQuantity>
</ScheduleDetails>
</OrderedArticle>
</OrderLine>
</ew:quote_A2></pre>
|
|
|
|