Consume XML from a WEB service

[barrymavin]

Yes, just to explain.

When DEBUG is ON it lets us (and you) see how lianja is introspecting the ActiveX.

Lianja looks into the ActiveX and determines the method and property signatures and maps them from VFP to the correct case sensitive ones, and also marshals the parameters that you pass to them.

Thats what all that mumbo-jumbo is.

[HankFay]

I'd also like to point out that we do in fact support loading tables from XML in our SQL but the format of that XML has to be in Microsoft ADO format. There are also built-in functions that will map XML to and from an object.

When using Copy to create them xml

use mytable
copy to "myfile.xml" xml

is the xml that is produced in the Microsoft ADO format?

tia,

Hank

[lianjasupport]

Yes it is if you:

SET XMLFORMAT TO ADO

Which I believe is the default.

[HankFay]

Yes it is if you:

SET XMLFORMAT TO ADO

Which I believe is the default.

The Docs indicate that the SET XMLFORMAT command applies only to the Select ... SAVE AS XML

Question: does SET XMLFORMAT work with any of the other commands for importing/exporting data as XML?

tia,

Hank

[barrymavin]

SET XMLFORMAT TO ADO is the default in Lianja.

So the COPY command produces XML in Microsoft ADO format. If you execute the following commands in the console workspace you can see the xml output.

open database southwind
use example
copy to export xml
type export.xml

[barrymavin]

Please look at this link which explains how to parse big data in JSON or XML.