The PipeDrive API does not provide the complete body of a message by default - poor design on PipeDrive's behalf.

On this API call to get an email:

https://developers.pipedrive.com/docs/api/v1/Mailbox#getMailMessage

This entity gets deposited into the database into a table called mail_message.

There is an optional API parameter `include_body` that defaults to 0.  When `include_body` parameter is missing or 0, a field called `snippet` nvarchar(512) is returned.  This is a plain text truncated snippet of the body.  When the API parameter `include_body` is 1, `snippet` is not returned and instead `body` is returned.  The `body` field has the full html of the email body.

I think it would be better to have your pipedrive connector return the full body of the email.  In this case the `body` field in the database should be nvarchar(max).