Adding leads via REST API with additional fields

Hi Peter Storey,

You can use the Sugar metadata API to fetch all the available fields in the Leads module and then send it accordingly through the POST endpoint.

Follow this wonderful article to know more about the metadata API - 3 Tips for using the Sugar Metadata API 

Let us know if this helps.

Regards.

That's got all but 3 things: the website field, the email field, and the custom field.

Both the custom field and the website appear as strings in the export, I've no idea why they won't import.

The email seems to be more complicated, it comes out as a load of json. When I try to import similar json, once again an empty field. I wish there was some logging per-field of what went wrong.

Turns out I needed to be posting to /Leads rather than /Leads/Register and using email1 instead of email.

Peter Storey, 

You should not use email1, it is a deprecated field and will be removed.

https://community.sugarcrm.com/community/developer/blog/2017/08/01/using-e-mail-fields-correctly-in-sugar

When creating a Lead with an email address via API you should use the following for the email. 

{
   "first_name":"Rob",
   "last_name":"Robertson",
   "email":[
      {
         "email_address":"rob.robertson@sugar.crm",
         "primary_address":"1",
         "invalid_email":"0",
         "opt_out":"0"
      },
      {
         "email_address":"rob@sugar.crm",
         "primary_address":"0",
         "invalid_email":"0",
         "opt_out":"1"
      }
   ]
}

See:

https://support.sugarcrm.com/Documentation/Sugar_Developer/Sugar_Developer_Guide_8.3/Architecture/Email_Addresses/#Creating_Email_Addresses_Using_the_REST_API

HTH,
FrancescaS

Thanks for that, I've switched to using email and also switched to using the request body for all the parameters (I falsely thought I had to use the query string since I was originally using /Leads/Register)