Options

Call Navision web service in .NET C#

usha2009usha2009 Member Posts: 11
edited 2011-06-20 in NAV Three Tier
Hi

I am new to Navision. Can you please let me know the steps how I can call Navision webservice and its methods in .Net C# code and get the data. Please also let me know how to add reference of this web service to C# project. Thanks in advance.

Best regards,
Usha.

Comments

  • Options
    ara3nara3n Member Posts: 9,255
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • Options
    usha2009usha2009 Member Posts: 11
    Hi Rashed,

    Thank you for your reply. I had gone through the link and got a basic understanding. I do would like to request you to suggest me regarding a requirement.

    Requirement:
    I need to connect to Navision webservice and the data I get from it I need to insert into one table in SQL Server 2008. From Navision web service all the data I get is inserted into one table only in SQL Server 2008. This Sql server 2008 is used as database to one Web application.

    So what is the approach I need to follow to insert data into SQL Server table. Is it by using SSIS packages or by calling the Navision web service in .Net CSharp code and in the code write insert into SQ Server.
    Thanks in advance.
    Best regards,
    Usha.
  • Options
    ara3nara3n Member Posts: 9,255
    Let me understand this correctly. You have a NAV db and another non NAV db on sql 2008?

    If you need to insert into another Non NAV DB, use ADO.

    http://mibuso.com/blogs/ara3n/2011/01/1 ... tc-in-nav/
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • Options
    usha2009usha2009 Member Posts: 11
    Hi Rashed,

    You are correct. We have a NAV db and another non NAV db on sql 2008(in one web application developed in C# .net)?

    Client will give me a Navision webservice. I need to call this Nav web service and the data I get from it need to insert into a table in sql 2008 of my web application.

    What is the approach i need to follow. Do i need to do using SSIS or need to call ADO.net in Csharp web application and insert data into SQL? Any links I can check for this requirement.
    Thanks in advance.

    Best regards,
    Usha.
  • Options
    ara3nara3n Member Posts: 9,255
    Yes follow my previous post. Publish NAV Codeunit as webservice and inside the codeunit create a function in which you will need to access the other db using ADO.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
Sign In or Register to comment.