Applicants endpoint search by email address not returning correct matches

[david-silverink]

On occasion, we have noticed that creating a new applicant then trying to find that applicant using the applicants endpoint and passing the email address returns no matches.

Example for SFG data:

• Contact DNH17008980 created using **@yahoo.co.uk
• New applicant record created using above contact ID as associatedId, associatedType 'contact'
• Correct 201 response is returned from the POST request
• Search for applicant using applicants/?emailAddresses=**@yahoo.co.uk returns no matches

In Agency Cloud, multiple applicant records have been created but nothing is returned from the API request. This works 99% of the time, but it happens now and again.

Thanks

[github-actions[bot]]

Thank you for taking the time to report a bug. We prioritise bugs depending on the severity and implications, so please ensure that you have provided as much information as possible. If you haven’t already, it really helps us to investigate the bug you have reported if you provide ‘Steps to Replicate’ and any associated screenshots. Please ensure any personal information from the production database is obscured when submitting screenshots. This issue will be reviewed in our weekly refinement sessions and assigned to a specific project board. We may also update the ticket to request additional information, if required. For more information on our processes, please click here

[AshDeeming]

migrated to; PBI-5873

NB This ticket will be updated once further updates completed on the above

[AshDeeming]

Hi @david-silverink

Please could you provide a failing example from SAV if possible?

This may relate to the use of special character etc however we would like to test further to confirm