function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
GMASJGMASJ 

INVALID_QUERY_FILTER_OPERATOR

Hi,

  I am using below ID to extract data using SOQL query I keep getting below error. Not sure what is issue is please suggest me. 
  
Error running Query: INVALID_QUERY_FILTER_OPERATOR: 
select id,name from account where id in ( '0013400001VHnhM', '0013400001VHnhq'
                                  ^
ERROR at Row:1:Column:35
invalid ID field: 0013400001VrBc
​
  
select id,name from account where id in ( '0013400001VHnhM',
'0013400001VHnhq',
'0013400001VrBVL',
'0013400001VHnjN',
'0013400001VrBVQ',
'0013400001VrBVV',
'0013400001MRoeD',
'0013400001VrBVa',
'0013400001NO0uf',
'0013400001VHnsj',
'0013400001VrBVf',
'0013400001VHntD',
'0013400001VrBVk',
'0013400001VHnw2',
'0013400001VrBVp',
'0013400001VHnxy',
'0013400001VrBVu',
'0013400001VHo1g',
'0013400001VHo3S',
'0013400001VrBW4',
'0013400001VH6QP',
'0013400001VHo9V',
'0013400001VHoAJ',
'0013400001VrBW9',
'0013400001VrBWE',
'0013400001VHoLR',
'0013400001VrBWJ',
'0013400001VrBWO',
'0013400001VHoP9AAL',
'0013400001VrBWT',
'0013400001VHoRe',
'0013400001VHoT6',
'0013400001VrBWd',
'0013400001VrBWi',
'0013400001VHoXN',
'0013400001VrBWs',
'0013400001VrJRz',
'0013400001VrJS4',
'0013400001VrBWx',
'0013400001VrBX2',
'0013400001VrBX7',
'0013400001VrBXC',
'0013400001VrBXH',
'0013400001VrBXM',
'0013400001VrBXR',
'0013400001VrBXW',
'0013400001VrBXg',
'0013400001VrBXl',
'0013400001VrBXq',
'0018000001AFZTH',
'0013400001VrBXv',
'0013400001VrBY0',
'0013400001VrBY5',
'0013400001VrBYA',
'0013400001VrBYF',
'0018000001DwmE4',
'0013400001VrBYK',
'0013400001VrBYP',
'0013400001VrBYZ',
'0013400001VrBYe',
'0013400001VrBYj',
'0013400001VrBYt',
'0013400001VrBYy',
'0013400001VrBZ3',
'0013400001VrBZD',
'0013400001VrBZI',
'0013400001Qkeeo',
'0013400001Ri6eF',
'0013400001VrBZN',
'0013400001VrBZX',
'0013400001VrBZc',
'0013400001VrBZh',
'0013400001VrBZm',
'0013400001VrBZr',
'0013400001VrBZw',
'0013400001VrBa1',
'0013400001VrBa6',
'0013400001VrBaB',
'0013400001VrBaG',
'0013400001VrBaV',
'0013400001VrBaa',
'0013400001VrBaf',
'0013400001VrBak',
'0013400001VrBap',
'0013400001VrBaz',
'0013400001VrBb9',
'0013400001VrBbE',
'0013400001VrBbJ',
'0013400001VrBbO',
'0013400001VrBbY',
'0013400001VrBbd',
'0013400001VrBbi',
'0013400001VrBbn',
'0013400001VrBbs',
'0013400001VrBbx',
'0013400001VrBc2',
'0013400001VrBc',
'0013400001LH411',
'0013400001LHqTY')

 
Best Answer chosen by GMASJ
devedeve
This error is because '0013400001VrBc' id is of 14 character that is not a valid salesforce id. Salesforce id should be of 15 character.

All Answers

devedeve
This error is because '0013400001VrBc' id is of 14 character that is not a valid salesforce id. Salesforce id should be of 15 character.
This was selected as the best answer
Ajay K DubediAjay K Dubedi
Hi GMASJ,

select id,name from account where id in ( '0013400001VrBc',......)

ERROR at Row : 1:Column:36 invalid ID field: 0013400001VrBc

In This Query, this Account Id '0013400001VrBc' is not Valid ID. Please, change the account id, after change the Account id query will working properly.

Please mark as best answer if it helps you.

Thank You 
Ajay Dubedi