Mailjet puts only ":" in lead_donotcontact.comment (after softbounces)

[beetofly]

Mautic Version

4.4.x series

PHP version

7.4.3

What browsers are you seeing the problem on?

Not relevant

What happened?

Problem in Mautic instances with mailjet:

Mautic process the callback response of mailjet for softbounced emails currently so, that in the database field comment in the table lead_donotcontact only a colon appears / is persisted.

How can we reproduce this issue?

Step 1:

In a Mautic instance with mailjet send an email, for example, to a "softbounce simulator" or an email account, which you configured as "full".

Step 2:

Wait until the response of mailjet for the softbounced email is back [Important: That can take up to three days (see also mailjet api documentation), because mailjet retries to send a softbounced email several times until the email will set to the status "softbounced" in mailjet and the callback to mautic will happen]

Step 3:

Open the table lead_donotcontact in the mautic database and you will see, that there is only a colon in the comment field of the softbounced email.

Relevant log output

No response

Code of Conduct

• I confirm that I have read and agree to follow this project's Code of Conduct

---

Want to back this issue? Post a bounty on it! We accept bounties via Bountysource.

[beetofly]

I have already analysed the problem and will soon make a proposal to solve this problem via a pull request for this issue.

Reason of this problem:

So far Mautic uses the mailjet data fields error_related_to : error.
The JSON mailjet response for these both data fields are currently empty for softbounced emails.
But in the JSON mailjet response are the additional fields "hard_bounce" (bool) and "comment" (text) included, which are currently ignored by mautic.

So a possible solution for this problem:

I will include all relevant mailjet fields, so the "comment" field in "lead_donotcontact" will be
HARD : error_related_to : error : comment (if value of hard_bounce in JSON-Response of mailjet is true)
and
SOFT : error_related_to : error : comment (if value of hard_bounce in JSON-Response of mailjet is false)

My pull request with the code changes that implements this solution proposal in mautic will appear shortly.

[Moongazer]

I think @Leuchtfeuer is already working on this

[stale]

This issue or PR has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. If you would like to keep it open please let us know by replying and confirming that this is still relevant to the latest version of Mautic and we will try to get to it as soon as we can. Thank you for your contributions.

[RCheesley]

@ekkeguembel are your team working on this?

[beetofly]

@RCheesley PR for that issue is merged in 4.4.10

[beetofly]

Fixed for mautic 4 via PR Fixes #11888 for mailjet puts only : in lead_donotcontact.comment #11912 (in release 4.4.10)

[github-actions]

⚠️COMMENT VISIBILITY WARNING⚠️

Comments on closed issues are hard for our team to see.
If this issue is continuing with the lastest stable version of Mautic, please open a new issue that references this one.