Email Address Handling

[yuki-consulting]

Hi there,

Try to import Leads with email address and encounter an issue. The lead records and the email address records are both created. However, they are not linked to each other.

Try using email1 field as well as an email array but both options do not work. Am I missing something?

Thanks in advance.

[ShadMickelberry]

Can you post a sample you are sending? Here is a sample post that seems to be going through just fine.
{ "records": [ { "id": "47fecf72-b195-11e8-a6e1-06cd403c41f6", "first_name": "Test3", "last_name": "Test3", "user_name": "test3", "password": "test123", "email1": "[email protected]" }, { "id": "47fed0f8-b195-11e8-9dde-06cd403c41f6", "first_name": "Test2", "last_name": "Test2", "user_name": "test2", "password": "test123", "email1": "[email protected]" } ] }

In the config_override:
$sugar_config['bulk_import_settings']['modules']['Leads']['sugar_key_field'] = 'id'; $sugar_config['bulk_import_settings']['modules']['Leads']['external_key_field'] = 'id'; // REQUIRED - REST payload variable containing the external system unique key's value $sugar_config['bulk_import_settings']['modules']['Leads']['sql_query'] = 'select id from contacts where id = ?';

[yuki-consulting]

Hi there,

Thank you for getting back to me. I have changed my code now so i don't have a sample handy. For me, i have tried the email1 field like you did as well as using an email array similar to example in https://support.sugarcrm.com/Documentation/Sugar_Developer/Sugar_Developer_Guide_9.2/Cookbook/Web_Services/REST_API/PHP/How_to_Manipulate_Records_CRUD/#Request_Payload
but neither worked

I ended up changing the code to bulkimport them ass EmailAddresses and then use the relationship to link them.

By the way, it is very interesting that you are using the id as the external key. Does that mean we do not have to create another foreign key?

[ShadMickelberry]

Hello.

That id was just for ease so I didn't have to create a field to test with. Generally, that wouldn't be the case but there is certainly nothing preventing from using that as the external key. If you had an external application creating UUIDs that would work just fine.

I'd investigate if there is some other process interfering with the email population. I have used this quite a bit and not run into that. Are you running into the same issue if you just use the regular create endpoint?

[yuki-consulting]

Hello.

I did not have the same problem using the normal endpoint but it is much slower.