NAV 2013 Web Services & automatic Dataset refresh problem

Dear all,

I am halfway a project requiring the integration of NAV 2013 with a third party MYSQL-PHP application. This is happening through NAV Page Web Services which run OK.

However, there is a complication: during the first step of the integration, I INSERT and UPDATE data from our official NAV 2009 SP1 to NAV 2013 through SQLS Stored Procedures. When the SPs run, the NAV 2013 tables are updated but this is not happening on the NAV 2013 page. When I manually refresh (F5) the data appear on the page and it only when I proceed to a OnValidate action on the page (e.g. edit a record) that the new data are added to the Web Service dataset.

Consequently, I have realized that the dataset is properly refreshed only when OnValidate runs on the Page. I had a second failure when I tried the Codeunit Web Service. After applying an OnValidate function on a Codeunit and exposing it as a Web Service through an XML port, I run it through a Job Queue: it goes OK but when I INSERT/UPDATE new data to NAV2013 DB the Function comes to an error stopping the Job Queue.

Is there any way to automatically bring the new data without applying an OnValidate function (e.g. through a button on the page). Thank you very much for your time and attention.