Hi Everyone,

Does salesforce provide any .net sample project/code for the Salesforce Bulk API? If anyone have any sample, Please share it.

Thanks,

NK

When calling other service using apex callout, I am trying to pass the lookup field like "Commodity__r.Name" and it is returning old Name "Car" whereas its that same commodity is rename to "Cars". 

Looks like the caching issue within the service method where I am making Apex callouts.

If I run a query against my object and used the same "Commodity__r.Name" field I get right value "Cars", so its the problem with Salesforce APEX Callout service area.

Any ideas on how to clear the cache with this Salesforce APEX CAllout service????

~NK

I am getting this error after calling the Salesforce SOAP WSDL Based service:

No such column 'Jigsaw' on entity 'Account'. If you are attempting to use a custom field, be sure to append the '__c' after the custom field name. Please reference your WSDL or the describe call for the appropriate names."

Looks like the WSDL schema provided the Account with Jigsaw fields like sample shown below, but when the service calls the salesforce this fields are not recognized, I tried to run the SOSQL generated by service directly within the salesforce SQL Tool and there also I get the same no such column 'Jigsaw' is message, Any ideas? Any setting needed to be set in salesforce to allow these fields to be accessible???:

<

complexTypename="Account">

<

complexContent>

<

extensionbase="ens:sObject">

<

sequence>

<

elementname="Jigsaw"nillable="true"minOccurs="0"type="xsd:string"/>

<

elementname="JigsawCompanyId"nillable="true"minOccurs="0"type="xsd:string"/>

Hi Salesforce Gurus,

When I am opening the System Log (or Developer Console) in Sandbox and I am getting this error message:

Error: Open request failed

Requested entity 07LT000000DMX7L was not found.

~NK

I have a visualforce page which is embedded in the parent page, which displays summary info. This page is working in production salesforce (salesforce11) and its not working in the sandboxes where the (salesforce 12) version is running. Looks like some feature/functionality is broken in the new release.

Here is the message I am getting in place of the visualforce container.

=====================================

Content cannot be displayed: java.io.NotSerializableException: common.apex.runtime.bytecode.BytecodeExecutionContext$DynamicContext Path to non-serializable object: ***VF Page Requested: 'pashaquotecharges' Object;@625bcadb[{}] Object;@7863224f[{, , 'j_id0', 'j_id0', 'javax.faces.Button', , , 'j_id0:j_id2', 'j_id2', 'javax.faces.Form', , 'j_id0:j_id2:block', 'block', 'javax.faces.Button', , , 'j_id0:j_id2:block:resultsBlock', 'resultsBlock', 'javax.faces.Button', , , , 'dataCell ', 2, 'totalRow ', 'headerRow ', 'if (window.hiOff){hiOff(this);} ', 'if (window.hiOn){hiOn(this);} ', 'dataRow even , dataRow odd ', 'list ',, 'value', , 'j_id0:j_id2:block:resultsBlock:j_id3:j_id4', 'j_id4', 'org.richfaces.renderkit.CellRenderer', , -2147483648, -2147483648, 'j_id0:j_id2:block:resultsBlock:j_id3:j_id10', 'j_id10', 'javax.faces.Text', 'Terminal Handling', , , 'value', , 'j_id0:j_id2:block:resultsBlock:j_id3:j_id5', 'j_id5', 'org.richfaces.renderkit.CellRenderer', , -2147483648, -2147483648, 'rightalign', 'j_id0:j_id2:block:resultsBlock:j_id3:j_id11', 'j_id11', 'javax.faces.Text', '$203.50', , , 'j_id0:j_id2:block:resultsBlock:j_id6', 'j_id6', 'javax.faces.Button', , , 'j_id0:j_id2:block:resultsBlock:j_id6:j_id7', 'j_id7', 'javax.faces.Label', , 'grandTotalText', 'rightalign', , , 'value', , 'j_id0:j_id2:block:resultsBlock:j_id6:grandTotalText', 'grandTotalText', 'javax.faces.Format', 'width:300px', 'rightalign', , 'j_id0:j_id2:j_id9', 'j_id9', 'javax.faces.Button', , }] Object;@17307a99[{}] Object;@6fc0deb3[{, , 'j_id0:j_id2', 'j_id2', 'javax.faces.Form', , 'j_id0:j_id2:block', 'block', 'javax.faces.Button', , , 'j_id0:j_id2:block:resultsBlock', 'resultsBlock', 'javax.faces.Button', , , , 'dataCell ', 2, 'totalRow ', 'headerRow ', 'if (window.hiOff){hiOff(this);} ', 'if (window.hiOn){hiOn(this);} ', 'dataRow even , dataRow odd ', 'list ', , 'value', , 'j_id0:j_id2:block:resultsBlock:j_id3:j_id4', 'j_id4', 'org.richfaces.renderkit.CellRenderer', , -2147483648, -2147483648, 'j_id0:j_id2:block:resultsBlock:j_id3:j_id10', 'j_id10', 'javax.faces.Text', 'Terminal Handling', , , 'value', , 

Hello,

I'm trying to add a batch to an existing job using the Bulk API from C#.  I've created the job and can get info on it, but am running into a problem when attempting to add a batch of data to it.

Here's the code.  The problem is that at run time the call to this line never returns:

Stream datastream = request.GetRequestStream();

This only happens when the url on the request includes the "batch" at the end (see first line of code).  The JobID parameter is valid, is an open job, and works in a separate call to get info.

Does anyone know what the problem might be?

            HttpWebRequest request = (HttpWebRequest)HttpWebRequest.Create("https://na12-api.salesforce.com/services/async/23.0/job/" + JobID + "/batch");
            request.Method = WebRequestMethods.Http.Post;
            request.ContentType = "application/xml; charset=UTF-8";
            request.Headers.Add("X-SFDC-Session", _SessionID);
            request.KeepAlive = false;
            request.Host = "na12.salesforce.com";
            request.UserAgent = ".NET Framework Test Client";
            request.Accept = "application/xml";

            string body = "<?xml version=\"1.0\" encoding=\"UTF-8\"?> ";
            body += "<sObjects xmlns=\"http://www.force.com/2009/06/asyncapi/dataload\">";
            body += "  <sObject>";
            body += "    <description>Created from Bulk API on Wed Jan 4 2012</description>";
            body += "    <name>[Bulk API] Account 0 (batch 0)</name>";
            body += "  </sObject>";
            body += "  <sObject>";
            body += "    <description>Created from Bulk API on Wed Jan 4 2012</description>";
            body += "    <name>[Bulk API] Account 1 (batch 0)</name>";
            body += "  </sObject>";
            body += "</sObjects>";

            //Convert the body of request into a byte array
            byte[] byteArray = Encoding.UTF8.GetBytes(body);

            //Set the length
            request.ContentLength = byteArray.Length;

            //Write the body to the request by using a datastream
            //This line never returns....
            Stream datastream = request.GetRequestStream();
            datastream.Write(byteArray, 0, byteArray.Length);
            datastream.Close();

            //Call the service and get the response as a data stream
            WebResponse response = request.GetResponse();
            datastream = response.GetResponseStream();
            StreamReader reader = new StreamReader(datastream);
            string responseFromServer = reader.ReadToEnd();

            response.Close();

I am getting this error after calling the Salesforce SOAP WSDL Based service:

No such column 'Jigsaw' on entity 'Account'. If you are attempting to use a custom field, be sure to append the '__c' after the custom field name. Please reference your WSDL or the describe call for the appropriate names."

Looks like the WSDL schema provided the Account with Jigsaw fields like sample shown below, but when the service calls the salesforce this fields are not recognized, I tried to run the SOSQL generated by service directly within the salesforce SQL Tool and there also I get the same no such column 'Jigsaw' is message, Any ideas? Any setting needed to be set in salesforce to allow these fields to be accessible???:

<

complexTypename="Account">

<

complexContent>

<

extensionbase="ens:sObject">

<

sequence>

<

elementname="Jigsaw"nillable="true"minOccurs="0"type="xsd:string"/>

<

elementname="JigsawCompanyId"nillable="true"minOccurs="0"type="xsd:string"/>

Hi Salesforce Gurus,

When I am opening the System Log (or Developer Console) in Sandbox and I am getting this error message:

Error: Open request failed

Requested entity 07LT000000DMX7L was not found.

~NK

I am trying to perform an upsert via the Bulk API with C#.net http posts.

The upsert works fine if I use external id = "ID"

However, when I change to use a custom external id, I receive this error:

Got an unexpected error while processing BULK-API. Contact support with error ID: 375837484-3025 (-1477247585)

Is there a configuration option I need to check?

I am writing a series of articles to illustrate ways to integrate Salesforce with .Net.  Below are links to the first two articles.  The third artcile on Callouts will be publish in the next couple of weeks.  Please let me know your thoughts.

http://www.developer.com/net/net/salesforce-integration-with-.net-web-services-soap-api-.html?comment=53310-5710

http://www.developer.com/net/net/salesforce-integration-with-.net-custom-web-services.html

(the link to the .Net code for this should be uploaded on the site soon.  If you would like a copy, then please let me know and I can email it to you).

Thanks,
Darren

Does anyone know how to use Bulk API in C#?

the Web Service API can only update max 200 records at once.

Bulk API can update 10,000 records at once.

I only find sample code using Java.

Thanks.

We create csv file by reading the data from database into it.

csv format is as below:

FirstName,LastName,Description

ABC,XYZ,DEFGH

We load the data using SFDC bulk load api.

In response we get the result as below which contains SFDC generated IDs of the records for which upload is successful

"Id","Success","Created","Error"

"0032000000ZlGn1AAF","true","true",""

The result doesn't contain anything from the records in the csv used to upload the data, so we can't map the csv records with the results. How to update the database records which were uploaded in to salesforce based on the result received?

Thanks.