You need to sign in to do that
Don't have an account?
Shradheya Tiwari
Pass field name in SOOQL query
Hi,
I am trying to get data using query - query?q=Select+id+from+Account+where+ABI_ID__c+=+12345
Using api and below is the code-
call = self.sf_api_call("query?q=Select+id+from+Account+where+"+field+"+=+12345", method="get")
When I am executing the script I am getting below error-
ERROR at Row:1:Column:30\\nvalue of filter criterion for field \'ABI_ID__c\' must be of type string and should be enclosed in quotes","errorCode":"INVALID_FIELD"}]'
I have tried many things but got no luck.
Can someone please help me in this?
I am trying to get data using query - query?q=Select+id+from+Account+where+ABI_ID__c+=+12345
Using api and below is the code-
call = self.sf_api_call("query?q=Select+id+from+Account+where+"+field+"+=+12345", method="get")
When I am executing the script I am getting below error-
ERROR at Row:1:Column:30\\nvalue of filter criterion for field \'ABI_ID__c\' must be of type string and should be enclosed in quotes","errorCode":"INVALID_FIELD"}]'
I have tried many things but got no luck.
Can someone please help me in this?
Can you try the following way
ToolingAPI.CustomObject customObject = customObjects[0];
Id customObjectId = customObject.Id;
List<ToolingAPI.CustomField> customFields = (List<ToolingAPI.CustomField>)
toolingAPI.query('Select Id, DeveloperName, NamespacePrefix, TableEnumOrId From CustomField Where TableEnumOrId = \'' + customObjectId + '\'').records;
Please let me know if it helps you and mark the problem as solved
thanks
Thanks for the reply mate, one thing I forgot to mention that my abve code is in Python.
Also the solution which you provided I don't think will work for me as my error is something different.
Thanks,
Shradheya Tiwari