Method Community

Now I realize what is happening.  The '%' followed by numbers is being intrepreted as a URL encoded entity.  I need to URL encode the '%' with '%25'.  Now I am retreiving what I expected.

I think I have answered my own question.  When I hard code '%' into the where clause, I get no data.  If I include '%' as part of the search parameter typed into the form, I get data. I am not sure why there is a difference in the results, but at least I can move forward.  

I am using PHP CURL to request data using MethodAPISelect_XMLV2.  I am making successful requests until I try using LIKE in the where clause.  For example, if I use           strWhereClause=RefNumber = '123' data is retrieved. If, however, I ...

 Hi Method_David, The company, user, and password are set.  For the variable returnedXML, I have tried '$returnedXML', '&$returnedXML', an empty string (''), and a literal string ('returnedXML'), all of which give me the same error message. By the way.  I am able to make a connection and ...

I have a situation requiring the deletion of over 38,000 conflicts.  This will be very time consuming if done manually, one-by-one.  So I want to use the MethodAPI to speed up the process.  Since I don't have API access to the conflicts data (I don't, correct?) I will have to resort to clearing the affected Method tables ...

I am using PHP 5 SoapClient class to define a SOAP client pointing to the MethodAPI service. I do this with           $client = new SoapClient("https://www.methodintegration.com/MethodAPI/service.asmx?wsdl"); My first test is attempting to retreive a table list using MethodTableList.  ...

 The input I have received has been helpful.  We are resolving the conflicts, one by one. We have over 38,000 conflicts of the DeleteFromDesktop type.  For example: "The record with the identify of '9EFC7-1240251539' appears to have been deleted in QuickBooks. Click 'Delete' to delete it here too, or ...

I see from searching the forum posts that others have had issues with synchonization completing.  I am trying to help a client resolve synchronization issues.  (They have contacted Ronen directly, as I intend to.  But first a question or two.) I see several conflicts that begin "QuickBooks returned an error when ...

I see that some database fields have a size of '0' and others have a size of '-1'.  Do these sizes have special meaning within the context of the database? 

 We have created a work flow for our account managers where they create an opportunity, but do not fill in an amount.  On the opportunity screen we have added a 'Save & Create Estimate' button, which takes them to the Estimate screen and fills in fields based on the opportunity.  When the account manager saves the ...