Rest API error converting data type nvarchar to numeric. (HTTP Status Code: 400)

[CapNcook]

Hi 

Has anyone encountered an issue when using GET request? I',m getting status code 400 with json error " Error converting data type nvarchar to numeric.".

I'm not inserting any records nor updating I just want to fetch data.

Here's my query.  rest/v2/tables/Contacts/records?q.select=UserName&q.where=ID%3D411256

[ianGPT]

Hello,

May I know the datatype of your id? If you are using a text(255) or string type data type you can try encapsulating the '411256'

Example:

 

rest/v2/tables/Contacts/records?q.select=UserName&q.where=ID%3D'411256'