Salesforce SOQL Query
Support SOQL queries using the query object with Salesforce REST API. e.g. GET https://ap7.salesforce.com/services/data/v20.0/query/?q=SELECT+name+FROM+Contact+WHERE+Account.ID+=+'0012800000jz5j0AAA'
Which will return name of all the contacts of Account.ID='0012800000jz5j0AAA'
I have tested with the existing available Salesforce connectors in NWC, workaround using both the 'Query record' and 'Retrieve record' to achieve the requirement, but it tool about 6 hours to retrieve 600 records of contacts. With the SOQL query, this will be in minutes.