Create New Record - Through INFOPATH - Using Web Service

Ravi_ThakkarRavi_Thakkar Member Posts: 392
edited 2010-03-01 in NAV Three Tier
Hello All,

According to Microsoft Document, I am able to Read, Update and Delete the records from MS Infopath.
But, I am still not able to create a new record for the same. Also, not able to find any proper documentation.

Please, help me if anybody is having any idea.
Also, suggest the documents if any.

Thanks.
Ravi_Thakkar
Ahmedabad, Gujarat, India
E Mail : ravi.thakkar@hotmail.com

Answers

  • DenSterDenSter Member Posts: 8,304
    The C/SIDE Development training material has an exercise that walks you through all the steps.
  • Ravi_ThakkarRavi_Thakkar Member Posts: 392
    Hello,
    DenSter wrote:
    The C/SIDE Development training material has an exercise that walks you through all the steps.
    Thanks for your reply.
    If I am not wrong, microsoft training manual specifies only about reading the NAV data through MS Infopath.
    Not about how to modify/creat/delete the records.

    Please, suggest any document or provide anykind of help.
    Ravi_Thakkar
    Ahmedabad, Gujarat, India
    E Mail : ravi.thakkar@hotmail.com
  • DenSterDenSter Member Posts: 8,304
    The example shows you how to select an operation from the webservice. Have you looked at the other available operations? Did you notice that in the same list that has the "ReadMultiple" it also has a selection for "Delete"? Have you tried selecting that and see if you can make that work? There are other exercises in that chapter that show you how to create and delete records. Read the whole chapter, and combine what you learn. Figure it out.
  • Ravi_ThakkarRavi_Thakkar Member Posts: 392
    Hello Denial,
    I really appreciate your quick response.
    DenSter wrote:
    The example shows you how to select an operation from the webservice. Have you looked at the other available operations? Did you notice that in the same list that has the "ReadMultiple" it also has a selection for "Delete"? Have you tried selecting that and see if you can make that work? There are other exercises in that chapter that show you how to create and delete records. Read the whole chapter, and combine what you learn. Figure it out.
    Actually I am aware with the WebService Functions of NAV 2009 SP1.
    I have also implemented one project for integration of .NET and NAV 2009 SP1 using WebServices.
    But, with Infopath, case is different. Inserting the record is not cleared in MS Document which I m refering.
    Suggest me the partnersource link for related document which you are suggesting.

    Thanks.
    Ravi_Thakkar
    Ahmedabad, Gujarat, India
    E Mail : ravi.thakkar@hotmail.com
  • Ravi_ThakkarRavi_Thakkar Member Posts: 392
    Hello,

    On trying to Insert the Customer Record, I am getting an ERROR:


    The form contains the following errors:


    Field or group: tns:Balance_LCY
    Error: Only numbers allowed

    Field or group: tns:Credit_Limit_LCY
    Error: Only numbers allowed

    Field or group: tns:Blocked
    Error: Only certain values allowed

    Field or group: tns:Invoice_Copies
    Error: Only integers allowed

    Field or group: tns:Copy_Sell_to_Addr_to_Qte_From
    Error: Only certain values allowed

    Field or group: tns:Prepayment_Percent
    Error: Only numbers allowed

    Field or group: tns:Application_Method
    Error: Only certain values allowed

    Field or group: tns:Last_Statement_No
    Error: Only integers allowed

    Field or group: tns:Reserve
    Error: Only certain values allowed

    Field or group: tns:Shipping_Advice
    Error: Only certain values allowed

    Field or group: tns:P_A_N_Status
    Error: Only certain values allowed

    Field or group: tns:Nature_of_Services
    Error: Only certain values allowed


    Also have attached the ERROR Diagram.
    Ravi_Thakkar
    Ahmedabad, Gujarat, India
    E Mail : ravi.thakkar@hotmail.com
  • Ravi_ThakkarRavi_Thakkar Member Posts: 392
    Hello All,

    My problem has been resolved. Now, I am able to create the Record through Infopath.

    Thanks.
    Ravi_Thakkar
    Ahmedabad, Gujarat, India
    E Mail : ravi.thakkar@hotmail.com
  • knightknight Member Posts: 45
    how did you get it to work in the end? Any reference material?
  • clayfoxclayfox Member Posts: 23
    I am editing output and consumption via journals successfully via InfoPath.

    One thing is that InfoPath only seems to work with page webservices, not code units. And some pages do not have all of the actions available.

    It is very simple to connect and use them, don't try to overcomplicate it.
Sign In or Register to comment.