WebApi.retrieveMultipleRecords with like operator for Integer field

(0) Share

Report

Posted on by Neom

Hi,

Is it possible to write query in client side that contains 'like' operator for Integer field.

I'm trying to write in WebApi.retrieveMultipleRecords, and to send fetchXml parameter:

</filter></entity>

</fetch>

The field new_auto_id is integer type.

The response is:

{"error":{"code":"0x80040203","message":"An exception System.FormatException was thrown while trying to convert input value '%\\1231\\%' to attribute 'lead.new_auto_id'. 
Expected type of attribute value: System.Int32. Exception raised: Input string was not in a correct format."}}

Any idea?
Thanks

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

Guido Preite 54,086 Moderator on at

Like (1)

Report
Copy link

Link copied!

afaik you can't apply the like operator to an integer value, if you need to execute queries with a like, you need to create another field where you copy the value from integer to string.

Was this reply helpful? Yes No