DataBase Structure confused to write sync Cron

[Ubunter35]

Hello people,

I'm not great in Sugar core, but I'm writing a small cron to dump and sync data into our existing SugarCrm, running v. 6.3, and a2billing.

A2billing is a VOIP Telecom billing system written in php also.

So, my idea it's to run a cron to sync a2billing accounts as lead in Sugar DB, but I arrive to the point, that in the leads table I don't find a field for email, so no idea where to dump the email field for the leads??

Searching around, I found here, that the mail details is handled by the email_addresses table; but in this case what I should do, dump the mail address directly to that table?? But how related to the specific customer ??

To be concrete, my question is, when I'm dumping details to the lead table, where should I dump the email for that lead, as the lead table don't see to have an email field? and if so, should I run internal sugar sync into leads table and emails to fix this?

Help please to clarify me this...

Regards,

[Angel]

You shouldn't write directly to the database tables for this very reason.

Use the SOAP or REST API to input the data. Through it you will access to the email1 and email2 fields which allow you to insert a primary and a single secondary email address for a Lead entry, without needing to know the database structure.

Check out the developer site for more info on the API:

Sugar Developer Zone - SugarCRM tutorials, SugarCRM Module Builder, SugarCRM documentation