Email Address Handling about bulkimport HOT 4 OPEN

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 = ?';

from bulkimport.

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?

from bulkimport.

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?

from bulkimport.

Hello.

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

from bulkimport.