Please be aware that the content in SAP SQL Anywhere Forum will be migrated to the SAP Community in June and this forum will be retired.

I have a table
"xtable"(
  x-id int not null default autoincrement primary key,
  x-type char(16) not null,
  x-data xml
  )

where "x-type" {'x-type-1', 'x-type_2', ...} defines type of xml data and structure of "x-data" depends on "x_type"- Each "x-type" in <dose_rows> consists of diferent "x-data" structure.

I need a response from SOAP web service for example:
<SOAP-ENV:Body>
  <dose>
    <dose-header>
      <dose-id>1</dose-id>
      <dose-time>2014-05-19 14:50:01.243</dose-time>
    </dose-header>
    <dose-rows>
      <x-type-1><code>my-code</code><name>abc</name><active>0</active></x-type-1>
      <x-type-2><id>14</id><code>abc</code><catalogue>xxx</catalogue>...</x-type-2>
      <x-type-2><id>24</id><code>abxx</code><catalogue>ttt</catalogue>...</x-type-2>
      ...
    </dose-rows>
  </dose>
</SOAP-ENV:Body>

How can I achieve this custom response via the SOAP web service of SQL Anywhere 12?

Thanks
Jan

asked 19 May '14, 09:57

Jan24's gravatar image

Jan24
75348
accept rate: 0%

Be the first one to answer this question!
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×24

question asked: 19 May '14, 09:57

question was seen: 4,685 times

last updated: 19 May '14, 09:57