I am trying to access Salesforce.com using its published webservices.
I have developed the entire code at my home internet connection and it workes fine there (as I didn't have any firewall blokcing there). Now when I am trying to run the same code here on my company's LAN I am getting the following error: - javax.net.ssl.SSLException: Unrecognized SSL message, plaintext connection?
I have set the Proxy settings : - System.getProperties().put("proxySet", true); System.setProperty("http.proxyHost", <company-proxy>); System.setProperty("http.proxyPort", "8080"); System.setProperty("https.proxyHost", <company-proxy>); System.setProperty("https.proxyPort", "8080"); System.setProperty("java.protocol.handler.pkgs","com.sun.net.ssl.internal.www.protocol"); Security.addProvider(new com.sun.net.ssl.internal.ssl.Provider());
I have gone through the previously posted threads regarding the same problem but couldn't get any solution regarding this.
Probably this has something to do with the ssl certificates. But I am not so familier with them and their installation. I am using Axis1.3's jar files in my project, But I am not running axis server.
I am also able to access other https sites from my program. But not able to login in salesforce.
As my program is running perfect on my home's internet connection I am quite sure that there is something wrong with the proxy setting of my company, please guide me where am I going worng.
I am running a python program which creates a SOQL query (join/relationship query). I am using APIs provided by "beatbox".
The simple one table queries works without any problem but when I try to execute a relationship query it says "SoapFaultError: 'MALFORMED_QUERY' "MALFORMED_QUERY: SOQL statements can't query related data"
Can anyone suggest me how to execute these relationship queires through python program?
Allocation table : - EMPLOYEE_ALLOCATION (Reference to EMPLOYEE's EMPLOYEE_NUMBER field) : 196990 PROJECT_ALLOCATION (Reference to PROJECT's PROJECT_NUMBER field) : 101201 ROLE : Researcher
And the relationship query I want to execute through my python program is : -
select ALLOCATION__C.ROLE__C from ALLOCATION__C where ALLOCATION__C.employee_allocation__r.EMPLOYEE_NAME__C='Joe' and ALLOCATION__C.project_allocation__r.PROJECT_NAME__C='Database Crawling'
This query is working fine with Apex Explorer 8.0. And I am using API Version 14.0
Allocation: - EMPLOYEE_ALLOCATION (Reference to EMPLOYEE's EMPLOYEE_NUMBER field) : 196990 PROJECT_ALLOCATION (Reference to PROJECT's PROJECT_NUMBER field) : 101201 ROLE : Researcher
(All the above objects are custom, ignoring '__c' for simplicity of reading) Now I want to execute a query which gives me the "ROLE OF JOE IN DATABASE CRAWLING PROJECT". The simple SQL equivalent is as follows: -
select A.ROLE from EMPLOYEE E, PROJECT P, ALLOCATION A where A.EMPLOYEE_ALLOCATION= E.EMPLOYEE_NUMBER and E.EMPLOYEE_NAME='Joe' and A.PROJECT_ALLOCATION=P.PROJECT_NUMBER and P.PROJECT_NAME='Database Crawling'
Can somebody Explain me how to write same query in SOQL using custom relationships?? I have tried but couldn't get the correct answer.
I am trying to access Salesforce.com using its published webservices.
I have developed the entire code at my home internet connection and it workes fine there (as I didn't have any firewall blokcing there). Now when I am trying to run the same code here on my company's LAN I am getting the following error: - javax.net.ssl.SSLException: Unrecognized SSL message, plaintext connection?
I have set the Proxy settings : - System.getProperties().put("proxySet", true); System.setProperty("http.proxyHost", <company-proxy>); System.setProperty("http.proxyPort", "8080"); System.setProperty("https.proxyHost", <company-proxy>); System.setProperty("https.proxyPort", "8080"); System.setProperty("java.protocol.handler.pkgs","com.sun.net.ssl.internal.www.protocol"); Security.addProvider(new com.sun.net.ssl.internal.ssl.Provider());
I have gone through the previously posted threads regarding the same problem but couldn't get any solution regarding this.
Probably this has something to do with the ssl certificates. But I am not so familier with them and their installation. I am using Axis1.3's jar files in my project, But I am not running axis server.
I am also able to access other https sites from my program. But not able to login in salesforce.
As my program is running perfect on my home's internet connection I am quite sure that there is something wrong with the proxy setting of my company, please guide me where am I going worng.
I am running a python program which creates a SOQL query (join/relationship query). I am using APIs provided by "beatbox".
The simple one table queries works without any problem but when I try to execute a relationship query it says "SoapFaultError: 'MALFORMED_QUERY' "MALFORMED_QUERY: SOQL statements can't query related data"
Can anyone suggest me how to execute these relationship queires through python program?
Allocation table : - EMPLOYEE_ALLOCATION (Reference to EMPLOYEE's EMPLOYEE_NUMBER field) : 196990 PROJECT_ALLOCATION (Reference to PROJECT's PROJECT_NUMBER field) : 101201 ROLE : Researcher
And the relationship query I want to execute through my python program is : -
select ALLOCATION__C.ROLE__C from ALLOCATION__C where ALLOCATION__C.employee_allocation__r.EMPLOYEE_NAME__C='Joe' and ALLOCATION__C.project_allocation__r.PROJECT_NAME__C='Database Crawling'
This query is working fine with Apex Explorer 8.0. And I am using API Version 14.0
Allocation: - EMPLOYEE_ALLOCATION (Reference to EMPLOYEE's EMPLOYEE_NUMBER field) : 196990 PROJECT_ALLOCATION (Reference to PROJECT's PROJECT_NUMBER field) : 101201 ROLE : Researcher
(All the above objects are custom, ignoring '__c' for simplicity of reading) Now I want to execute a query which gives me the "ROLE OF JOE IN DATABASE CRAWLING PROJECT". The simple SQL equivalent is as follows: -
select A.ROLE from EMPLOYEE E, PROJECT P, ALLOCATION A where A.EMPLOYEE_ALLOCATION= E.EMPLOYEE_NUMBER and E.EMPLOYEE_NAME='Joe' and A.PROJECT_ALLOCATION=P.PROJECT_NUMBER and P.PROJECT_NAME='Database Crawling'
Can somebody Explain me how to write same query in SOQL using custom relationships?? I have tried but couldn't get the correct answer.
Im trying to run a test SOQL relationships for thte first time and have encountered some problems.
I am running the query
SELECT a.Id, a.Name, (SELECT c.Id, c.firstname, c.lastname FROM a.Contacts c) FROM Account a
agsinst standard SalesForce objects however every time the query is executed against our account I am returned the error message
MALFORMED_QUERY: SOQL statements can't query related data
Has anyone got any ideas as to why this is occuring. As far as I can tell the syntax of the query is correct and I can run standard queries without any problem
