Method:API Q&A

Re: Table does not support add.

Method_David — Sat, 15 Dec 2012 18:31:26 GMT

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

Re: Table does not support add.

CF_Pro — Fri, 14 Dec 2012 22:34:12 GMT

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

Re: Table does not support add.

Method_David — Fri, 14 Dec 2012 19:08:04 GMT

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

Re: Table does not support add.

CF_Pro — Thu, 13 Dec 2012 16:06:12 GMT

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.

Re: Table does not support add.

Method_David — Thu, 13 Dec 2012 15:22:56 GMT

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

Re: Table does not support add.

CF_Pro — Thu, 13 Dec 2012 05:15:00 GMT

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

Re: Table does not support add.

CF_Pro — Sat, 08 Dec 2012 19:47:02 GMT

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

Re: Table does not support add.

CF_Pro — Thu, 06 Dec 2012 17:46:29 GMT

The quickbook version I am using Quickbooks Pro 2012.

Thanks Ashur for posting that info.

Re: Table does not support add.

Method_Ashur — Thu, 06 Dec 2012 17:31:22 GMT

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

Re: Table does not support add.

Matt — Thu, 06 Dec 2012 17:19:20 GMT

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.

Re: Table does not support add.

Method_David — Thu, 06 Dec 2012 17:03:22 GMT

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

Re: Table does not support add.

Matt — Tue, 04 Dec 2012 17:17:00 GMT

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

Table does not support add.

CF_Pro — Mon, 03 Dec 2012 00:51:52 GMT

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

TIA