Method Community

Beginning 9/15, we started seeing errors in our logs when trying to update classes through the API indicating that the table doesn't support edit. Was there a change to the API to disallow edit of that table? It looks like it used to be supported.

Hi rgatton,

Sorry for the late response. The Class table does indeed support adds and edits both via Method UI and the API. It could be that you're attempting to modify a locked field on the table. Can you post back with the fields that you're attempting to update?

--Audisho

The list of fields I'm updating is: Name,IsActive,TenantID

The strange thing is, I have a personal Method account and when I perform a MethodAPITableListV2 operation on that account, it has [SupportsEdit]=true for the Class table. But when I do that operation for one of the accounts where the update is failing, it's showing [SupportsEdit]=false.

Is there a setting somewhere in Method where the admin could have overridden the Class table not to allow edit? Could the fact that it's multi-tenant accounts be the reason?

Hi rgatton,

I believe the issue you're having is that the TenantID field is locked. This is standard for all accounting tables (tables that sync with QuickBooks), as changing this will certainly cause issues with your sync.

If you want to add data to a specific tenant, you should be specifying that tenant name in the strCompanyAccount field. I hope this helps.

--Audisho

I tried submitting the same update requests without the TenantID field (just passing the Name & IsActive fields), and getting the same error about the table not supporting edit.

Is there anything else I can try?

I don't understand why if the table is supposed to support edit, it is reporting that it doesn't when I run MethodAPITableListV2.

Hi rgatton,

Can you email me your company account name so that I can take a look?

--Audisho

Hi rgatton,

I just sent you an email with more details, but I've had to create a ticket with our development team for this. I'll keep you posted on the status here.

--Audisho

Hi rgatton,

Thanks for your patience. Our development team has corrected the flag on your Class table and you should now be able to edit classes via the API. Please give this a try and post back with the result.

Thank you.

--Audisho

Excellent! It's working now. Thank you so much for your help.