XML queries to supplier webserver to check stock availability

[DrAlbany]

Hi Guys..,

Can any one point me in the right direction.

I have a couple of suppliers who allow XML queries for obtaining product stock and pricing. Has anyone any pointers for the best / quickest way to achieve this.

I am using VFP8

I have dones some reading about XML in general, but it's way to over the top (hopefully) for simple "give me the price and qty in stock querys.


Many thanks

Steve

Watch ya back, because some times the devil drives a minibus.

 

[bborissov]

If I understood you correctly you receive XML file and want to query that XML? Right?
If this is so, take a look in XMLTOCURSOR() function or XMLAdapter class, convert that XML to VFP cursor and query that cursor.

Borislav Borissov
VFP9 SP1, SQL Server 2000/2005.
MVP VFP

 

[DrAlbany]

Hi Borislav..,

Thank you for your responce, it helped.

I'm stuck with how to create the following xml document

Sample XML: PNA Request
<?xml version="1.0" encoding="utf-8"?>
<PNARequest version="1.0">
<TransactionHeader username="YourUserName" password="YourPassword"/>
<PNAList>
<PNAItem supplierPartId="3C16793"/>
</PNAList>
</PNARequest>

I can't find how to generat it. Or do i have to create my own code to generate it??

regards

Steve

Watch ya back, because some times the devil drives a minibus.

 

[alvechurchdata]

The easiest way might be to build the string in memory then use the StrToFile() function to write it out to a file:

lcXML = [<?xml version="1.0" encoding="utf-8"?>] + ;
        [<PNARequest version="1.0">] + ;
        [<TransactionHeader username="YourUserName"] + ;  
        [password="YourPassword"/>] + ;
        [<PNAList>] + ; 
        [<PNAItem supplierPartId="3C16793"/>] + ;
        [</PNAList>] + ;
        [</PNARequest>]

StrToFile(lcXML, "myQuery.xml")

Note that I've used [ and ] as string delimiters to avoid problems with embedded quotes.

I've also ignored line feeds and the indents. The program receiving the XML should be able to parse the XML without them.

Geoff Franklin

http://www.alvechurchdata.co.uk

 

[DrAlbany]

Thanks everyone.


I really appreciate it.

I will give it a bash.

Regards


Steve

Watch ya back, because some times the devil drives a minibus.