Method Community

Hi Matt,   What function are you using.? I've tried to update the tenantid field of the users table from 1 to 1 like you are doing and the message I get back is "The field TenantID does not support edit". Which is different than the message you are getting. Dave

Hi Matt, I would not recommend editing it. Did you use MethodAPISelect_XML or MethodAPISelect_XMLV2 to retrieve the RecurrenceInfo field your are trying to copy? RecurrenceInfo is xml that is saved in a varchar field. But the api is also returning xml. So in order to transmit the data in the field, it gets encoded. Before sending the data back ...

Hi Matt, At this time it does not exist. I have put a ticket in with the dev team about adding a new function to allow this. I cannot offer a timeframe at this point for when it will be done, but it is definitely something we want to add in the future   Dave 

Hi nick_warren, Rather than wait for the sync to happen, you can invoke either of the following functions MethodAPIActionSendToDesktop or MethodAPIActionSendToDesktopV2. This should initiate a sync. Can you elaborate on the rearranging address fields problem? Dave

Hi Dominic Riccetti, This is actually pretty standard for passing xml, if there is no data why does the node need to be there? Your code shouid be able to check whether the node exists. Dave

Hi LaCrews Good suggestion...unfortunately it is not going to be done at this time. For the select XML methods you will need to check whether the MethodIntegration node has children. For the select dataset methods need need to check the row count of the first datatatable of the dataset Dave  

Hi SmileJV and LaCrews, Some fields are not meant to be populated by users. An example of this is the RecordID field of the contacts table. This field is an identity field that is automatically populated when a new record is added. This is probably where your insert is failing. Following up on LaCrew's point. Some fields are ...

Hi Dominic Riccetti, We don't allow table join queries via the API. I'll put in a suggestion about allowing this in the future. To accomplish what you are trying to do you need to link the tables first and then query the resulting table via the API. I'm gonna point you at the following ...

Hi nick_warren, You mentioned you have a conflict. Until that conflict is resolved the change will not occur in QB in this case. When a conflict occurs the sync engine does not know how to proceed, so to protect your data from being corrupted it waits for you to tell it how to resolve the conflict. Here's a scenario, You change an ...

Hi nick_warren, The api is not the synchronization engine. The api manipulates data in your method account. The synchronization engine is what moves data between your method account and QB. First question, have you followed the steps from Paul above? I have and the ship address fields clears just fine. Second question, adter syncing if ...