Trouble using local storage variable in Salesforce Integration soql query

Sat Mar 21, 2015 12:19 am

Hi Pavan,

Please tell us detailed what q parameter you are referring to.
Show screen shot.

Sat Mar 28, 2015 1:32 pm

I am having trouble.

This returns all
code
return 'PIN__c = '+value+'';
/code

This is the statement it generates in the app...
code
q=SELECT+Id%2C+Name%2C+PINc+%0AFROM+Employeec&WHERE=PIN__c+%3D+1234
/code

This is based on your syntax above, but gives an error.
code
return 'PIN__c = '"+value+"'&quot
/code

This is a successful SOQL statement in Salesforce. So I feel like I need the single quotes.
codeSELECT Id,Name,PINc FROM Employeec WHERE PIN__c = '1234'
/code
.

Can you help?

Sat Mar 28, 2015 2:24 pm

I added the " before PIN and I am still getting all of the records, instead of the filter query.

codereturn "PIN__c = '"+value+"'&quot /code

Still need help, something isn't right.

Sat Mar 28, 2015 3:05 pm

It seems to be returning a : after the WHERE statement. That is not right???

Mon Mar 30, 2015 4:52 am

Hi Lee,

Please show us screen shots of your implementations and what is not works.

Thanks.

Mon Mar 30, 2015 10:14 am

I found a solution yesterday. The problem is that you cannot add a parameter to the SOQL statement within Appery.io. It is formatted incorrectly. You have to pass the entire query. I would recommend you at least provide feedback to a developer on this situation.

Tue Mar 31, 2015 12:52 pm

Hello Lee,

Thanks for update.
Just to clarify, could you tell us what do you mean
" cannot add a parameter to the SOQL statement"

As I understood SQL statement it's just a string, and since Appery.io works with JS you can add any parameter to any string,

Tue Mar 31, 2015 1:02 pm

Sure. I was able to pass the entire string via JS. What I wanted to do, was to add a Parameter to the Appery.io database service that is built into Appery.io. I am not a programmer and I made the assumption that your custom integration service would return a WHERE statement within the service. however, it formatted the statement with a ":" and rendered the wrong syntax. I had to go into the testing component of Chrome and determine what the system was doing and then re-create the proper syntax in JS. Again, as a non-programmer this took me a long time to solve. SOQL is the query language used by Salesforce. I think you should make it very clear that your Salesforce integration does not render SOQL statements correctly so that folks will know. Thanks for following up.

Wed Apr 08, 2015 3:07 pm

Appery.io uses pure REST, so it doesn't contain any additional parameters and templates

Wed Apr 08, 2015 3:11 pm

That is why you need to make users aware when using your Salesforce integration. It is limited.