› Forums › MxLoader NextGen Beta › SQL condition error This topic has 2 replies, 2 voices, and was last updated 1 week, 6 days ago by user. Viewing 3 posts - 1 through 3 (of 3 total) Author Posts 2020-09-24 at 6:14 PM #20061 Nader GaradaParticipant Hi: The Query works fine, but when add the condition like siteid=’BEDFORD’ I get error 500, Source DoHttpCall Internal Server Error {“Error”:{“reasonCode”:null,”message”:”Lexical error at line 1, column 8. Encountered: \”\\’\” (39), after : \”\””,”statusCode”:”500″}} Please advise This is Version Beta4 2020-09-24 at 7:08 PM #20062 Nader GaradaParticipant I got it now, using ” instead of ‘ Thx for your time 2021-01-10 at 11:50 PM #20200 userKeymaster When using REST service, you have to use oslc.where syntax. See here: https://developer.ibm.com/static/site-id/155/maximodev/restguide/Maximo_Nextgen_REST_API.html#_filtering_data_using_where_clause Author Posts Viewing 3 posts - 1 through 3 (of 3 total) The topic ‘SQL condition error’ is closed to new replies.