Hello, we are able to access data on our Staging instance via an API using this filter (in bold)in the URL: https://INSTANCEURL/profileAndServicesExt/cusTABLENAME/byTextemail@example.com&filterType=email
We are now trying the same in Production and are getting this error: RST-360011 An error has occurred - please contact your administrator.
PGS-220000 PostgreSQL error: ERROR: invalid input syntax for integer: "firstname.lastname@example.org"
There are no differences in the table configurations between Staging instance and Production instance. I have also republished Production.
The field is set to Text for both instances. Any thoughts on why we are getting this integer syntax error in Production?