How do I XML insert Parent and related Child data

[Edwin Hannan]

Hello

I have set up a NT9 web service

I have lead providers posting xml and the data inserts into a single lead table fine.

I now want to explore inserting xml data into the parent table AND some of that data into a related child table, how would I do this?

Many thanks

Edwin
C10 ABC and NT 9.01
Windows 10 pro

[Bruce]

Hi Edwin,

you can have multiple incoming parameters, then what you do with them is up to you.
In this case you would add a bit of hand-code to write the vhild records away;
see
http://www.capesoft.com/docs/NetTalk9/NetTalkWebServices.htm#YourCode

Cheers
Bruce

[Edwin Hannan]

Hi Bruce

Thanks for explaining

BUT not registering with my brain just yet :-) but I get the fact that if data is sent I can manipulate that data and insert certain data into related tables but I cant see where / how to add in those extra data items for the related table.

If I want  to populate a child record how do I get the paramters to be used to show in the service documentation / wsdl file?

I feel I am missing something fundamental here,

Are there any examples of this anywhere?

Cheers

Edwin

[kevin plummer]

Check out the xfiles docs as there are examples of creating and consuming these types of xml structures.

[Bruce]

Hi Edwin,

Probably best to come to the User Group webinar today (Thursday) so I can work through this with you.
It should be simple, but if you mis some basic concept then it will look harder than it is.

cheers
Bruce

[Edwin Hannan]

Hi

Joining webinar's is a little difficult for me at present,

Currently working as a UK Mortgage Adviser (one of my other hats :-) ) 12 noon to 8pm then travelling home, back in my home my office around 8:45pm.

I gather that at the moment the NT9 templates do not cater for ralated tables and all auto documentation is for the table specified and I will need to look at constructing some embed source code to parse the xml received.

I will study the xfiles example that Kevin has mentioned and hope that you do include this topic in tonights webinar so I may catch up with it in a recording :-)


Much Appreciated

Edwin

[Edwin Hannan]

Hi Bruce

>you can have multiple incoming parameters, then what you do with them is up to you.
>In this case you would add a bit of hand-code to write the vhild records away;

yes this is what I have now done :-)

Thanks for your help

Cheers

Ed