| Web 2.0/XML/SOAP - XML to dynamic SQL ?

Web 2.0/XML/SOAP - XML to dynamic SQL ?

D Shah asked:


In my new business needs, I have fixed message types and message formats (depending on message type, message will have fixed set of parameters and values). These messages are stored in SQL for further processing by my engine.
For Example, my general purpose message format will be like this:
MSG_ID=NUMBER, USEREMAIL=STRING, MSG_TYPE=STRING, SUB_CATEGORY=STRING,MODE=CHAR, PARAMETER1=value1, parameter2=value2,…, ADDITIONAL DATA (document in form of attachment).
SUB_CATEGORY,MODE, PARAMETERS/VALUES change based on MESSAGE_TYPE.

The issues I am trying to resolve -
(a) Is there a way I can plug-in new message types (and hence new parameters/values) with the help of XML as extension to currently thought possibilities? Without needing to change the code.
(b) If I want these messages to originate from any website (my site or partner site), what kind of API I should think of ?

SOAP/XML/Web 2.0 - I am sure something here can help me resolve both problems.

Thanks in advance
In clarification of point (a), I am asking in context of future expansion of business where I may have to consider new message types and associated parameters (incl. their names).

Related posts:

  1. How can I dynamically add/remove tag in web.config in asp.net 2.0 from a code-behind file of an aspx page? Pebble asked: I am developing a website where it is...
  2. How do I get remote error details in ASP.NET 2.0 (I think)? I’m just getting the Runtime Error screen? blue_prince_of_dallas asked: I downloaded the Express (free) version of Visual...
  3. Pointers for starting up a Web 2.0 business? delmontebanana asked: The question might be a bit abiguous, but...
  4. Web development with web 2.0? Its more than design, but how much is the coding work? ? Ncarolina K asked: I have passionately studied the art of...
  5. How would I go about making a contact form more Web 2.0ish? Webman asked: There is a contact form on a Website...

Filed Under Programming & Design |

Tagged With , ,

Comments

One Response to “Web 2.0/XML/SOAP - XML to dynamic SQL ?”

  1. dhvrm on May 15th, 2009 3:08 am

    >> (a) Is there a way I can plug-in new message types (and hence new parameters/values) with the help of XML as extension to currently thought possibilities? Without needing to change the code.

    Sure. It depends on your design. Since it’s just a string literal, I don’t see why you can’t have any number of types and parameters.

    >> (b) If I want these messages to originate from any website (my site or partner site), what kind of API I should think of ?

    You already have your answer: Deliver them as XML.