RST-360011 An error has occurred - please contact your administrator. PGS-220000 PostgreSQL error

[CRM_jw]

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/byText?text=test@test.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: "test@test.com"

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?

[CRM_jw]

Note, if we are trying to access production table data without adding the filter, then we are able to retrieve the data using this call: https://mc.adobe.io/hersheys/campaign/profileAndServicesExt/cusStageProfileWebForm

But accessing all table data without adding a filter is not a good way, hence we are using a filter.

[ramon_bisswanger]

Which fields did you enable for the quick search on the custom resource as byText uses that part.

Else did you try adding a custom filter, e.g. byEmail, to use via API then?

[Sukrity_Wadhwa]

Hi @CRM_jw,

Were you able to resolve this query or do you still need more help here? Do let us know.

Thanks!