Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 194
  • Last Modified:

Save to an xml file every 5mins and check for value

I have a url that seems to return me a XML file. I need to save it to a file so I can process it.

Then I need to check for a certain value for a element node every 5mins (quantity). Sometimes the node will be there, sometimes it will not. Is it possible to be done?
I need the item to be sold by amazon.com only not 3rd party merchants

http://webservices.amazon.com/onca/xml?Service=AWSECommerceService&AWSAccessKeyId=1VZB58STNG3MCXSMS8G2&Operation=ItemLookup&ItemId=B000UA0LXQ&ResponseGroup=OfferFull&Version=2007-10-29&DeliveryMethod=Ship&Condition=New&IdType=ASIN
 
For some reason it returns -1

Open in new window

0
Sharalynn
Asked:
Sharalynn
  • 2
1 Solution
 
PaulHewsCommented:
Using a timer...  I'm not sure it's necessary to save to a file, but I show how.  Also, how to extract a single node.
Imports System.Xml
Public Class Form1
 
   
 
    Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
        Timer1.Interval = 300000 ' 5min
        Timer1.Enabled = True
    End Sub
 
    Private Sub Timer1_Tick(ByVal sender As Object, ByVal e As System.EventArgs) Handles Timer1.Tick
        Dim doc As New XmlDocument
        doc.Load("http://webservices.amazon.com/onca/xml?Service=AWSECommerceService&AWSAccessKeyId=1VZB58STNG3MCXSMS8G2&Operation=ItemLookup&ItemId=B000UA0LXQ&ResponseGroup=OfferFull&Version=2007-10-29&DeliveryMethod=Ship&Condition=New&IdType=ASIN")
        Dim nsMgr As New XmlNamespaceManager(doc.NameTable)
        nsMgr.AddNamespace("ns", "http://webservices.amazon.com/AWSECommerceService/2007-10-29")
        doc.Save("C:\items.xml")  'Save file?
 
        Dim node As XmlNode = doc.DocumentElement.SelectSingleNode("//ns:Amount", nsMgr)
        If Not node Is Nothing Then
            Debug.WriteLine(node.InnerText)
        End If
 
    End Sub
 
  
End Class

Open in new window

0
 
SharalynnAuthor Commented:
This is almost perfect! Thank you! But you said that there is no need to save it to a file and I see why... it kind of auto save the stuff into a object already upon retrieving from the link. But still, useful, thank you.
0
 
SharalynnAuthor Commented:
save http link to xml file
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now