Re: SOAP Query to Export Data

Date: 09-02-10
From: David Adams <dpadams_at_gmail.com>

On Tue, Feb 9, 2010 at 12:28 PM, Gordon Thompson wrote:
> 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!

"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.
**********************************************************************
The New 4D Partner Program - All the tools you need to be a successful 4D Developer.
Sign up Now: http://www.4d.com/community/partner/registration.html


4D Internet Users Group (4D iNUG)
FAQ: http://lists.4d.com/faqnug.html
Archive: http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub: mailto:4D_Tech-Unsubscribe_at_lists.4D.com
**********************************************************************