Some example:
To access the data for all accounts from external system, that match would be:
https://cxz.my.salesforce.com/services/data/v59.0/query/q?=SELECT +Company_Mailing_City__c+ Name + FROM +Account
By directly passing an SoQL query into the url.
whenever the internal salesforce API would changes(specially the version number) then it would be dependent from the SF internal data model.
The alternative would be to directly implement this query into the SF instance and offer an extra endpoint that can be used to query it.
We would need a more specific endpoint in the ''/Account' API that provides us with the following Data in a JSON Format.
The bold values in brackets represent the Salesforce internal field naming, while the first represents the naming we would like to have them mapped to.
Company:**Account** {
string name (**Name**)
string city (**Company_Mailing_City__c**)
string country (**Company_Mailing_Country__c**)
}
Can anyone help like how can we directly implement the above mentioned query into the SF instance and offer an extra endpoint that can be used to query it.