Use webservice to search in 2 tables

elwin68 · 2009-02-26

I want to search in NAV2009 through a webservice in 2 tables.
For Example: I set a filter at the field email in the customer table. Then I want to show the sales order from the found customer(s).

There are more possibilities to do this:
- Usage of 2 webservices so I can first search for the customer(s). With the outcome I search for the sales orders.
- Add the field email in the sales header table so I have 1 table to search in.

Is it possible to leave the tables as they are and use 1 webservice to do the trick?
Can a codeunit be used to extend the functionality of the page webservice? And how is this done?

Thanks in advance.

freddy.dk · 2009-02-26

If you write a codeunit with a method, which takes the customer record as the first parameter - and you expose this codeunit as a webservice with the same name as the Customer page - and NO check in published.

Then you will have this method available on the customer page.

but.... - you might not want to go with a page here - you might just want to expose a codeunit with a method, which returns a XMLPort returning the sales orders you are searching for - Pages might look like the easy way to go, but I think you often should consider whether the WS contract really is for CRUD purposes before just exposing the page.

elwin68 · 2009-02-26

Thanks Freddy for your answer.
What do you mean by returning the sales orders with a xmlport?
Just export the sales orders with an xmlport to a xml file and then read the contents of xml file?

kine · 2009-02-26

It means that you use XMLPort for creating the "Response" of the WebService... just search for weservice and xmlport...

elwin68 · 2009-02-27

thanks for the explanation.
I have found the website and will look at it.

Howdy, Stranger!

Quick Links

Categories

Use webservice to search in 2 tables

Answers