Search results by user ID 4418

Uploading 'Alternate' Contacts into the Contact Table

Palmer — Wed, 28 Apr 2010 20:41:16 GMT

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. Is there a document anywhere that talks about the key tables and the required fields needed for inserting where existing foriegn keys exist, like customers/vendors, etc. The general RecordID just would just create orphans in the Contact table.

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 matched them up manually in Excel. That is were I got the value 767 above. Is it using trying the 'Name' field to automatically index this or something?

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

Re: Inserting/Loading Alternate Contacts

Palmer — Fri, 23 Apr 2010 17:33:54 GMT

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

Inserting/Loading Alternate Contacts

Palmer — Thu, 22 Apr 2010 19:52:57 GMT

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