Method Community

 

Table does not support add.

Last post 12-15-2012 12:31 PM by Method_David. 12 replies.
Page 1 of 1 (13 items)
Sort Posts: Previous Next
  • 12-02-2012 6:51 PM

    Table does not support add.

    Try to add a new customer record using MethodAPIInsertV2, what do I change to allow adding new records to the my customer table?

    TIA 

  • 12-04-2012 11:17 AM In reply to

    • Matt
    • Top 10 Contributor
    • Joined on 11-04-2008
    • Posts 877

    Re: Table does not support add.

    I am now getting the "Table does not support add" response on the InvoiceLine table. The call was working yesterday morning.


    Matt Raiser

    Founder,



    www.techinthefield.com

    matt@techinthefield.com

    219-221-9500



    ~ Method user / partner since 2008

    ~ Over 15 years field service experience

    ~ 2013 Method Partner of the Year

    ~ Degree in Computer Science





    Creator of:


        


  • 12-06-2012 11:03 AM In reply to

    Re: Table does not support add.


    Hi CF_Pro and Matt,

    I need a little more information since my account is working as expected.

    Are the accounts you are having problems with Multitenant?

    Have you done a full sync with the accounts yet?

    What version of quickbooks are you using?

    Dave

  • 12-06-2012 11:19 AM In reply to

    • Matt
    • Top 10 Contributor
    • Joined on 11-04-2008
    • Posts 877

    Re: Table does not support add.

    Dave,

    This is happening on my own account. It is not multi-tenant, it has been synced multiple times and I am using QB 2012.

    I think the problem may be the table itself in the account. If I edit the InvoiceLine table in method and then click the finished editing fields button, I get the error message An error has occurred. An email has been sent to Method staff. If this problem persists, please contact the Method Team at method@methodintegration.com. 

    I had a similar situation in the past http://www.methodintegration.com/cs/forums/t/3672.aspx though that was with multi-tenancy and this one is not multi-tenant.



    Matt Raiser

    Founder,



    www.techinthefield.com

    matt@techinthefield.com

    219-221-9500



    ~ Method user / partner since 2008

    ~ Over 15 years field service experience

    ~ 2013 Method Partner of the Year

    ~ Degree in Computer Science





    Creator of:


        


  • 12-06-2012 11:31 AM In reply to

    Re: Table does not support add.

    Hey Dave,

    I just got off the phone with CF_Pro who asked me to post this on his behalf since he was on the road. I accessed his account to confirm the information and also regenerated his Customer table to be on the safe side. He's setup with a standard Method Pro for QBD account, the last full sync and changes-only sync were performed on May 8 2012, and we don't know the current QuickBooks version so he'll respond with that when he gets to his work station.

    - Ashur

    Need more help? Ask us about Method consulting services

    Ashur Shamon
    Lead Solutions Specialist, Professional Services
    Method Integration Inc.
    www.method.me
    Toll Free: 1.888.925.6238
    Local and overseas: 416.847.0400
    Fax: 416.640.6027
    E-mail: a.shamon@method.me
  • 12-06-2012 11:46 AM In reply to

    Re: Table does not support add.

    The quickbook version I am using Quickbooks Pro 2012.

    Thanks Ashur for posting that info.

  • 12-08-2012 1:47 PM In reply to

    Re: Table does not support add.

    I performed a full sync, and I am still getting the same error.

  • 12-12-2012 11:15 PM In reply to

    Re: Table does not support add.

    Any thoughts on what might be the problem.  It been more than a week.

  • 12-13-2012 9:22 AM In reply to

    Re: Table does not support add.


    CF_Pro,

    After doing a full sync does the problem still happen?

    Does the following simple C# example work for you?

    string[ arrInsertFieldsArray = new string[ { "Name", "Contact" };       

    string[ arrInsertValueArray = new string[ { "SomeCustomer", "SomeContact" };

    MethodAPI.Service _MethodAPI = new MethodAPI.Service();       

    lblMethodAPIInsertV2.Text = _MethodAPI.MethodAPIInsertV2(CompanyAccount, Login, Password, "", "Customer", arrInsertFieldsArray, arrInsertValueArray);

    Dave

  • 12-13-2012 10:06 AM In reply to

    Re: Table does not support add.

    The problem still exists after a full sync. I do not develop in c#, I can send you my credentials and you can run the example.

  • 12-14-2012 1:08 PM In reply to

    Re: Table does not support add.


    Hi CF_Pro

    We are unable to reproduce this issue on our end.

    Also our error logs do not indicate any errors fromt he API.

    If you're still receiving errors when attempting to use MethodAPIInsertV2 please enable methodsupport. Then send me an email with your account name,  the fields, and the data you are trying to insert into the customer table.

    Dave

  • 12-14-2012 4:34 PM In reply to

    Re: Table does not support add.

    I just tried it again and the same error using MethodAPIInsertV2.. I am also receive this error when I try to update the customer table (MethodAPIUpdateV2)

    Failure. The Table does not support edit.

    This problem is holding up my entire project, please fix asap.

    I also enabled methodsupport.


    Thank you

  • 12-15-2012 12:31 PM In reply to

    Re: Table does not support add.

    CF_Pro,

    I have not yet recieved an email from you with your accountname, the fields you are trying to insert, and an example of the data you are trying to insert.....I cannot attempt to diagnose further without the information I have requested from you.

    According to our logs both MethodAPIUpdateV2 and MethodAPIInsertV2 have had no problems recently.

     

    Dave


Page 1 of 1 (13 items)