Request would be like below:
Salesforce connector not retuning any data with above request but when i try to query through developer console it is returning data,
Request profile in below,
I see parameters are set to Connector and accordingly filter might be applied.
Hence I would point you to look for the parameter value that is being passed to SFDC connector is as expected and then using the SOQL statement that is shown in operation, use that same against developer console.
Retrieving data ...