Re: Is there any db schema documentation?

aaronglamb — Thu, 26 Dec 2013 22:20:27 GMT

So, that's *slightly* helpful, thank you.

Really, a little documentation would go a long way here; or are you determined to be one of the most diffcult APIs to integrate with on the market?

Here's where I'm stuck now: inserting new contacts for existing customers.

Here's my workflow:

IF Contact does not exists in Method for a given Email

IF Customer does not exist in Method for given Name

INSERT new Customer in Method

ELSE

SELECT RecordID of Customer from Method

INSERT new Contact in Method with Entity_RecordID = CustomerRecordID

UPDATE Contact (to populate all those read only fields)

ELSE Update Contact

If I end up creating a Customer record, there is no problem. However, if I create a Contact, I don't see anything new show up in the Method UI, although I do have a db insert id for the Contact record.

My confusion stems from the Contact / Customer / Entity relationship: I understand that the Customer table is a view on the Entity table with EntityType = Customer. I understand that the records in the Contacts table use the RecordID of the Entity table as a foreign key, either on the field EntityRecordID or the field Entity_RecordID (see where some documentation might be helpful - what fields are PK, FK, and to what do the FK reference?). Why then, when I insert a new Contact do I not see a result in the UI? What am I missing?

Thanks again,

Aaron

Is there any db schema documentation?

aaronglamb — Thu, 19 Dec 2013 18:26:18 GMT

I'm having a very difficult time understanding how the db is organized. Quite simply, I'm trying to add Contacts via the MethodAPIInsertV2 call, and running into multiple issues.

It seems to me that data is duplicated between Customer, Contact and Entity records, and I'm not sure where the data should go. Furthermore, I understand that a Customer supposedly references one to many Contacts, but I'm finding strange behavior when adding Contacts where the CustomerName seems to be a random Customer in the db, not the one passed. Finally, I'm frustrated that so many fields on the Contact table do not support Insert, but do support Edit.

What is the proper path forward here? A little documentation would, I feel, go a long way here.

Thanks for any help or light you can shed.

Aaron.

Search results by user ID 6221

Re: Is there any db schema documentation?

Is there any db schema documentation?