I am unable to create an External Service, my aim is to download the Swagger.json for the REST API/ Enpoints for the CRUD operation on the custom objects that I have created on Salesforce.

 

I tried executing the following Rest API on the Salesforce workbench -
in REST Explorer

/services/data/v48.0/query/?q=SELECT+Total_Cost__c+from+DBA_Invoice__c+where+Name="I-525"

I get the following response-

MALFORMED_QUERY
message: from DBA_Invoice__c where Name="I-525" ^ ERROR at Row:1:Column:52 line 1:52 no viable alternative at character '"'
errorCode: MALFORMED_QUERY

However, it works without the where clause. 

Could you please tell me how do specify the value in the where clause?

I need the swagger documentation for the rest APIs for the custom objects that I have created.

Hi,

I tried using /services/data/v48.0/sobjects/DBA_Invoice__c?Invoice_No__c=I-52555
But this retrieves all records.

I tried executing the following Rest API on the Salesforce workbench -
in REST Explorer

/services/data/v48.0/query/?q=SELECT+Total_Cost__c+from+DBA_Invoice__c+where+Name="I-525"

I get the following response-

MALFORMED_QUERY
message: from DBA_Invoice__c where Name="I-525" ^ ERROR at Row:1:Column:52 line 1:52 no viable alternative at character '"'
errorCode: MALFORMED_QUERY

However, it works without the where clause. 

Could you please tell me how do specify the value in the where clause?

I need the swagger documentation for the rest APIs for the custom objects that I have created.

Hi,

I tried using /services/data/v48.0/sobjects/DBA_Invoice__c?Invoice_No__c=I-52555
But this retrieves all records.