Create web services for publishing data, this is not a component and therefore menuitems are not created for it.
Note: For development servers use the full url https://servername.softadmin.se/...
To enable Web services in your system you must perform the following configuration steps:
The steps 1 through 6 needs to be performed after first deploy as well.
The system setting "WebServiceURLBaseSoftadminServices" is most likely wrong, make sure the url is reachable.
CREATE PROCEDURE dbo.GetPersonInfo @PersonId int AS BEGIN SELECT P.PersonId, P.PersonName FROM Registry.Person P WHERE P.PersonId = @PersonId; SELECT A.AddressId, A.PersonId, A.Street FROM Registry.Address A WHERE A.PersonId = @PersonId; END;
The best way to handle errors that should be sent to the caller is to create an error entity which contains information about the error and potentially a success bit.
RAISERROR can be used for internal errors as these errors are logged but only displayed to the caller in the development environment.