Method Community

I am using the MethodAPIInsertV2 interface to upload/transfer several hundred QuickBooks matched contacts from an ACT database into Method.

EntityType=’Customer’, EntityRecordID=767, FirstName='Joe' AND LastName='Test' to upload into the 'Contacts' Table.

I get an error of: ‘The field EntityType or EntityRecordID do not support Add’

I queried the Customer table to get the existing Customer RecordID, already and matched them up.  That is were I got the 767 above.

How do insert alternate contacts into Method and tie them to existing QB customers?

Thanks,

Palmer Stevens

Palmer - using the API there is no need to set the EntityType.  If you are inserting into the Customer table, it knows enough to automatically set the EntityType to Customer for you.

Also, if you are importing lots of data, you might be interested in a new built-in Method Import / Export feature we put into beta yesterday.  See the post here: http://www.methodintegration.com/cs/forums/t/721.aspx.  It's pretty slick.

Paul

 The Beta looks nice.  I gave it a try and it had a file not found sort of error on the upload. 

I need know what are the key fields that I need to use with the INSERT API  to add Alternate Contacts to existing QB Customers.

Thanks, Palmer

Palmer,

If you are trying to add info to an existing record in the Customer table, you're going to want to use the UpdateAPI call. The InsertAPI call is for adding a new record. If all you need to do is update existing records in the customer table I have an Excel spreadsheet that should do the trick for you. You can email me at matt@TechInTheField.com if you are interested.

Palmer -  Are you still getting an error when you try the import / export beta?  If so, what's the exact message?  We can look into it for you.

Paul