SOAP Query to Export Data

Gordon Thompson (2/8/10 5:28PM)
David Adams (2/9/10 5:01PM)

Gordon Thompson (2/8/10 5:28 PM)

Is there a simple example to use SOAP to query a 4D Server (2003)
database and return the result set? We need to export time-series data
on a daily basis. Thanks for your help!

Gordon Thompson

David Adams (2/9/10 5:01 PM)

On Tue, Feb 9, 2010 at 12:28 PM, Gordon Thompson <gordon@...
wrote:
color><param>00000,08CF,D8CC/param>IIs there a simple example to use
SOAP to query a 4D Server (2003) database and return the result set?
We need to export time-series data on a daily basis. Thanks for your
help!
/color>
"The 4D Web Services Companion" (out of print) included a pair of
databases you might find helpful. "SDBC Server" and "SDBC Client". The
server uses SOAP to satisfy ad-hoc requests for data. The client has a
GUI that lets you:

-- Specify a server to connect to.
-- Download the table structure. (Well, the tables/fields you've
chosen to publish.)
-- Select the fields to include in the output (and in what order).
-- Specify an output style (attributes, SOAP arrays, or structs).
-- Define an ad-hoc query (and/or allowed).
-- View the results.

I don't remember how complicated the code is - I didn't actually
remember how many features the database has. [Later] Yeah, there's a
bunch of code. Well, it's kind of nice proof-of-concept, at the least.

I'd offer to send the database along but I don't actually own the
rights. 4D used to have it hosted up on their site and perhaps still
does somewhere. I'm not sure where to look after the current redesign
(which looks good, by the way.)

Note: This database was written in 2003 and the interface seems a bit
ugly. Still, the UI was hardly the point.

Reply to this message

Summary created 2/9/10 at 2:05AM by Intellex Corporation

Comments welcome at: feedback@intellexcorp.com