Search results by user ID 4461

Re: Is there any db schema documentation?

Method_David — Fri, 20 Dec 2013 18:46:02 GMT

Hi aaronglamb,

Gonna point you at the knowledge base article http://www.methodintegration.com/method/kb.aspx?folder=methodcrm&article=Contacts&id=299 about contacts and a forum post about the entity table http://method.me/cs/forums/t/454.aspx

The customers table is pretty much a view on the entity table....where the entitytype field is equal to customer. Hence the duplication you mentioned... refer to http://method.me/cs/forums/t/5328.aspx

In the contacts table you have the field entity_recordid (think foreign key) of the customer that the contact belongs to. So you need to have an existing customer(entity), before you can assign it to a contact.

As for supports add/edit refer to http://method.me/cs/forums/t/3622.aspx

Dave

Re: Inset

Method_David — Wed, 18 Dec 2013 15:55:58 GMT

Hi v.cameron,

For a discussion of supportsadd/seupports edit I'm gonna point you to an older foum post. http://method.me/cs/forums/t/3622.aspx

Contacts do not exist in Quickbooks. Customers as you know are entities and do exist in QB. They are related via the entityref field of the contacts table. A customer can have many contacts.

Dave

Re: SendToDesktop not working

Method_David — Thu, 28 Nov 2013 16:18:53 GMT

Hi furrywombat,

Ok....that was a fun one to track down....there was a buried configuration setting on the server you were hitting...and it was not set to the right value. Try now and let me know if it works.

Dave

Re: SendToDesktop not working

Method_David — Mon, 25 Nov 2013 19:35:48 GMT

Hi furrywombat,

I can't seem to recreate your issue here. Can you send me an email with examples of your calls...oh and your account name.....so I can investigate further.

Dave

Re: MethodAPISelect_XMLV2 returns non-array for multiple results

Method_David — Tue, 19 Nov 2013 14:46:49 GMT

Hi furrywombat,

MethodAPISelect_XMLV2 does not return a string array. It returns a string of xml. Look closer at the raw response you should see something like

<?xml version="1.0" encoding="windows-1252" ?><MethodAPI response = "Success" MaxRecords= "False"><MethodIntegration Table='Customer'><CompanyName>MyCompany</CompanyName> <RecordID>64</RecordID> </Record> <Record> <CompanyName>MyOtherCompany</CompanyName> <RecordID>66</RecordID> </Record></MethodIntegration></MethodAPI>

Dave

Re: Proposal Request for On-line Calendar integrated with Method API

Method_David — Fri, 15 Nov 2013 18:08:26 GMT

Hi Dan A.,

Have you looked into what's available via the fieldservices app (located under customize-->myaccount)....I'm not sure if it will meet all your needs but it may help get you started.

I'm also gonna suggest you contact one of our Method Solution Providers at the following url http://www.methodintegration.com/Consultants.aspx (filter the list by Method API)....they will be more than happy to go over this with you.

Dave

Re: QuoteRoller Integration

Method_David — Mon, 11 Nov 2013 18:24:11 GMT

Hi urbanhaze,

Sadly, Method does not integrate with QuoteRoller out of the box, you will have to build an application that does.

It should be possible using our API to retrieve/update all the data in your method account that would be used by QuoteRoller, and vice versa.

In terms of pricing I suggest you contact one of our Method Solution Providers at the following url http://www.methodintegration.com/Consultants.aspx (filter the list by Method API)....they will be more than happy to go over this with you.

Dave

Re: Error Message while trying to use API

Method_David — Fri, 08 Nov 2013 14:11:10 GMT

Hi chowrentoys.com,

Have you granted the user access to the api in step 8 of the create user wizard?

Dave

Re: GetScreenURLV2 when not synced to QB

Method_David — Thu, 07 Nov 2013 14:22:02 GMT

Hi Matt,

That is actually the expected behaviour....It has been specifically designed to take them to that page (if they have access) and have not synced before. Even if they come off a screen url. This is not going to be changed unfortunately in this version of method.

Dave

Re: MethodAPISelect_DataSetV2 returning inconsistent results

Method_David — Wed, 06 Nov 2013 17:13:18 GMT

Hi BrianPoole,

There is a limit of 1million cells of data being retrieved via the api. So if for example you specify the fields something like, RecordID, Name, BillAddress1, BillAddress2, and BillAddress3....that's 5 fields. 1 million/5 = 200.000 records at most being returned.

It sounds like in your case you will need to specify a range of records using the where clause.

In the return xml there is an atribute on the MethodAPI element, MaxRecords. When this is true it means there were potentially more records that could have been returned but were not, due to the million cell limit being reached

e.g. <MethodAPI response = "Success" MaxRecords= "True">

Dave