SOQL in Outsystems

SOQL in Outsystems

  
Hi,

What is the correct way of using SOQL in outsystems using "QueryString" actions?

I have an app called vicinity in my salesforce which gives me the nearby locations.
I am trying to do similar functionality using outsystems and connecting to salesforce.
Below soql query works in salesforce to get the required fields

SELECT Name, Email, Phone, MailingAddress, MailingStreet, MailingCity, MailingState, MailingCountry, MailingLatitude, MailingLongitude FROM Contact 
WHERE distance(MailingAddress, geolocation(42.565368, -71.129824), 'mi') < 50 
ORDER BY distance(MailingAddress, geolocation(42.565368, -71.129824), 'mi')
LIMIT 20 

But to use such query in outsystems I could not find fields like MailingAddress, MailingLongitude and distance function etc. to serve the need because the query in outssytems holds good for the fields only available from the structure (such as Contact structure here)

Is there a flexibility to use SOQL queries such as above in outsystems that would give me the values by querying the salesforce.

Help in this regard is appreciated!! Thanks!!

First, I'll assume you meant SQL instead of SOQL.  Second, in order to interface with any external component or API you'll need a component or extension.  Fortunately, there is already a component in the Forge to connect to Sales Force.  The component can be downloaded from here - http://www.outsystems.com/forge/component/109/salesforce-connector/ 

Once you incorporate this into your application you should be able to process requests like you want though it will likely be done using REST or Web Services, not direct SQL.  I have not used this component myself so have no additional knowledge about its use.

Hope this helps,
Curt
Thanks Curt!! I actually meant SOQL which is Salesforce Object Query language. I am looking to get the coordinates based on the address of a contact from salesforce. This is easy to query and get when using SOQL in salesforce but I am looking for similar functionality in outsystems integrated with salesforce
Thanks for enlightening me on what SOQL is (never saw that term before) but your best bet is to try that component in the Forge I mentioned.  

Curt


Thanks Curt..Yes I am using this component and looking for the possibilities based on my requirement as mentioned above using this component. Appreciate for your help and time.