03-06-2020 05:16 AM
We created a sync tool from Hubspot to Act!, but now the problem arises when there are contacts with a '+' sign in their e-mailaddress.
The sync looks for existing contacts in Act! based on emailAddress, to determine if it needs to insert or update.
The following query to the 1.1.30.0 API gives an empty list:
/api/contacts?$filter=emailAddress eq 'one+two@test.com'
If i remove the + it works.
I know that a + is something which doesn't belong in a URL, but also the urlencoded variant doesn't work either, also gives an empty list:
/api/contacts?$filter=emailAddress eq 'one%2Btwo@test.com'
How to deal with this? Can this be fixed soon please (also for v21.1)? Now our client has some contacts which are inserted every time the sync runs (which is every minute).
03-06-2020 05:20 AM
Ah, it does seem to work with the lowercase variant of the encoded + sign: %2b. For anyone else facing this problem.