How to Publish Tables (50000) series as Web Service

Answers

• Options

  Scarecrow Member Posts: 5

  2009-01-22

  Hi ChessExpert,
  
  You cannot expose tables directly as a web service. You can only expose Codeunits and Pages.
  
  The answer is to create a page in the 50000 range using the Table as its source.
  
  You can then expose the page as a web service which will give you access to insert, read, delete or update the table.
  
  Regards,
  
  Scarecrow

  0
• Options

  ChessExpert Member Posts: 103

  2009-01-22

  Hello there, thank you for your reply.

  0
• Options

  ChessExpert Member Posts: 103

  2009-01-22

  I am able to get this working.
  
  Note: ThatI have to refresh my web reference from time to time and also restart the "NAV Business Web Service".
  
  Thanks.

  0
• Options

  Scarecrow Member Posts: 5

  2009-01-22

  Hi ChessMaster,
  
  The error you are seeing indicates that you need to flush the object cache. I see this in the RTC also if you make changes to tables and don't restart the services.
  
  I would suggest restarting both the web service and service tier services and try again.
  
  The code snippet you supplied looks right.
  
  I whipped up a test Page of type "Card" and built a quick Vb console app which works fine with a custom page in the 50000 range.

  Module Module1
      Sub Main()
          Dim ws As New WebRef1.Test_Service
          ws.UseDefaultCredentials = True
          ws.Url = "http://localhost:7047/DynamicsNav/WS/GreatFoods/Page/Test"
          Dim flt(0) As WebRef1.Test_Filter
          Dim objRet(5) As WebRef1.Test
          objRet = ws.ReadMultiple(flt, "", 6)
          Dim i As Integer
          For i = 0 To 5
              Console.WriteLine("Category Number: " + objRet(i).Category)
          Next
          System.Threading.Thread.Sleep(2000)
      End Sub
  End Module
  

  
  Regards,
  
  Scarecrow

  0