I have had great success in using .net and the associated API Enterprise generated WSDL and Web Reference for about a year. I've also used the API in the Sandbox. I hadn't made a change to the Sandbox or the Production for a couple of months. Today I did the following in Firefox (I have had more success generating and downloading the WSDL in Firefox)
- Went to Settings/Develop/API/Generate Enterprise WSDL and clicked the GENERATE button to the right of "Generate Enterprise WSDL" - The result in Firefox was not the normal formatted XML that I had seen in the past (perhaps the update to Firefox did this) What appeared was what looked like one big paragraph of sentences (no xml tags) - I right clicked in the white area of the page and "saved as" test.wsdl - When I opened test.wsdl, it looked like it alwas does...properly formed XML
Next in VS, I changed the Web Reference property to the Test.wsdl file name and Updated my Web Reference
====================================== Now the issue (finaly) ======================================
When I try to create an instance of SforceService like the code below:
SforceService sfService = new SforceService();
I get the following exception:
2014-09-11 16:35:30.000 Warning SalesforceClient.Connect Exception.Exception.Name InvalidOperationException 2014-09-11 16:35:30.000 Warning SalesforceClient.Connect Exception.Exception.Message Unable to generate a temporary class (result=1). 2014-09-11 16:35:30.000 Warning SalesforceClient.Connect Exception.Exception.Message error CS0030: Cannot convert type 'Mozenda.Business.Salesforce.ListViewRecordColumn[]' to 'Mozenda.Business.Salesforce.ListViewRecordColumn' 2014-09-11 16:35:30.000 Warning SalesforceClient.Connect Exception.Exception.Message error CS0030: Cannot convert type 'Mozenda.Business.Salesforce.ListViewRecordColumn[]' to 'Mozenda.Business.Salesforce.ListViewRecordColumn' 2014-09-11 16:35:30.000 Warning SalesforceClient.Connect Exception.Exception.Message error CS0029: Cannot implicitly convert type 'Mozenda.Business.Salesforce.ListViewRecordColumn' to 'Mozenda.Business.Salesforce.ListViewRecordColumn[]' 2014-09-11 16:35:30.000 Warning SalesforceClient.Connect Exception.Exception.Message error CS0029: Cannot implicitly convert type 'Mozenda.Business.Salesforce.ListViewRecordColumn' to 'Mozenda.Business.Salesforce.ListViewRecordColumn[]' 2014-09-11 16:35:30.000 Warning SalesforceClient.Connect Exception.Exception.Source System.Xml 2014-09-11 16:35:30.000 Warning SalesforceClient.Connect Exception.Exception.StackTrace at System.Xml.Serialization.Compiler.Compile(Assembly parent, String ns, XmlSerializerCompilerParameters xmlParameters, Evidence evidence) 2014-09-11 16:35:30.000 Warning SalesforceClient.Connect Exception.Exception.StackTrace at System.Xml.Serialization.TempAssembly.GenerateAssembly(XmlMapping[] xmlMappings, Type[] types, String defaultNamespace, Evidence evidence, XmlSerializerCompilerParameters parameters, Assembly assembly, Hashtable assemblies) 2014-09-11 16:35:30.000 Warning SalesforceClient.Connect Exception.Exception.StackTrace at System.Xml.Serialization.TempAssembly..ctor(XmlMapping[] xmlMappings, Type[] types, String defaultNamespace, String location, Evidence evidence) 2014-09-11 16:35:30.000 Warning SalesforceClient.Connect Exception.Exception.StackTrace at System.Xml.Serialization.XmlSerializer.GetSerializersFromCache(XmlMapping[] mappings, Type type) 2014-09-11 16:35:30.000 Warning SalesforceClient.Connect Exception.Exception.StackTrace at System.Xml.Serialization.XmlSerializer.FromMappings(XmlMapping[] mappings, Type type) 2014-09-11 16:35:30.000 Warning SalesforceClient.Connect Exception.Exception.StackTrace at System.Web.Services.Protocols.SoapClientType..ctor(Type type) 2014-09-11 16:35:30.000 Warning SalesforceClient.Connect Exception.Exception.StackTrace at System.Web.Services.Protocols.SoapHttpClientProtocol..ctor() 2014-09-11 16:35:30.000 Warning SalesforceClient.Connect Exception.Exception.StackTrace at Mozenda.Business.Salesforce.SforceService..ctor() 2014-09-11 16:35:30.000 Warning SalesforceClient.Connect Exception.Exception.StackTrace at Mozenda.Business.SalesforceClient.SalesForceClient.Connect()
There is alot if information about "Unable to generate a temporary class (result=1)" doing a Google search, but nothing seems to apply.
- Has Salesforce changed how the Enterprise WSDL is created?
How come I can't dynamically cast a QueryResult to an sObject and view the values without have to cast the result to a difinitive sObject? I've been able to view returned values from a query within Microsoft Access, loop through the queryresult and then insert record values into the appropriate tables without having to specifiy whether it is an Account or Contact, or Lead, etc.
Instead of having to do something like: sObject s = new Account(); Account a = Account(s).
Why can't I just loop through the sObject records and retrieve the values?
I'm working on an integration piece and the sObject type has to be dynamic. I cannot cast it to a specific sobject every single time I need to retrieve records.
try { QueryResult qResult = sfProd.query(strSelectStatement); sObject[] s = qResult.records;
Boolean done = false;
if (qResult.size > 0) { while (!done) { // foreach statement cannot operate on variables of type QueryResult because QueryResult does not contain a public definition for GetEnumerator //foreach (QueryResult q in qResult) //{ //}
