Community
Showing results for 
Search instead for 
Do you mean 
Reply

odata filter doesnt work with a plus sign in the value

Highlighted
Copper Contributor
Posts: 205
Country: Netherlands

odata filter doesnt work with a plus sign in the value

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).

Greetings,

ACT Certified Consultants
TendenZ
the Netherlands
Highlighted
Copper Contributor
Posts: 205
Country: Netherlands

Re: odata filter doesnt work with a plus sign in the value

Ah, it does seem to work with the lowercase variant of the encoded + sign: %2b. For anyone else facing this problem.

Greetings,

ACT Certified Consultants
TendenZ
the Netherlands