This is also an active ticket with support, but I figured I would look to the community for insight too.

We use sendgrid as an external email provider.  I wanted to send an email with unique record id in the header from zoho to sendgrid's web api (which then sends the email).  The results from that send attempt would then be posted from sendgrid's event api back to zoho (to record bounces, unsubscribes etc).

I was able to do all this successfully.  But I hit a snag.  

One of the fields that sendgrid's event api posts back is "smtp-id".  I have no way to remove that field from being posted by sendgrid.  

The problem is that if zoho does not have a field that corresponds to the posted field, it throws an error " 2900 Invalid column name "smtp-id"specified".

But, zoho will not allow me to create a field called "smtp-id".  It allows that as a label name, but it changes the field name to "smtp_id"  I assume hyphen's are not allowed, so it silently converts them to underscore.

Ideally I would like zoho to just * ignore* any fields that don't have a corresponding fieldname in the form.

Any ideas my friends?

Thanks,

~david