I'm getting a nonsensical error when I try a Case>Solutions relationship query.

Here's my SOQL:

SELECT (SELECT SolutionName FROM Solutions) FROM Case WHERE Id = '50050000008oyOwAAI'

Returned error:

INVALID_FIELD: No such column 'CaseId' on entity 'Solution'. 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.

I am processing some results from the Metadata API, and I see in the ListView filters some undocumented field names. I am guessing they are similar to the date literals (THIS_WEEK etc), but I can't find a listing of them.

I see CONTACT.CREATED_DATE, and I believe I saw CREATEBY_USER elsewhere. Is there a list of these literals somewhere?

I'm posting this on the offchance that someone will find the error before I wake up tomorrow :-)

I get an error when I try to retrieve() ListView via the metadata API. It says "Element {}unpackaged invalid at this location".

Are there any SOAP retrieve() examples which I can use for comparison?

<v:Envelope xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns:d="http://www.w3.org/2001/XMLSchema" xmlns:c="http://schemas.xmlsoap.org/soap/encoding/" xmlns:v="http://schemas.xmlsoap.org/soap/envelope/"><v:Header><n0:SessionHeader xmlns:n0="http://soap.sforce.com/2006/04/metadata"><n0:sessionId>snipsnip</n0:sessionId></n0:SessionHeader></v:Header>
<v:Body>
 <n1:retrieve id="o0" c:root="1" xmlns:n1="http://soap.sforce.com/2006/04/metadata">
  <apiVersion i:type="d:double">21.0</apiVersion>
  <unpackaged i:type="n1:Package">
   <types i:type="n1:PackageTypeMembers">
    <members i:type="d:string">*</members>
    <name i:type="d:string">Contact.AllContacts</name>
   </types>
   <types i:type="n1:PackageTypeMembers">
    <members i:type="d:string">*</members>
    <name i:type="d:string">Contact.BirthdaysThisMonth</name>
   </types>
   <types i:type="n1:PackageTypeMembers">
    <members i:type="d:string">*</members>
    <name i:type="d:string">Contact.MyContacts</name>
   </types>
   <types i:type="n1:PackageTypeMembers">
    <members i:type="d:string">*</members>
    <name i:type="d:string">Contact.NewLastWeek</name>
   </types>
   <types i:type="n1:PackageTypeMembers">
    <members i:type="d:string">*</members>
    <name i:type="d:string">Contact.NewThisWeek</name>
   </types>
   <version i:type="d:string">21.0</version>
  </unpackaged>
 </n1:retrieve>
</v:Body>
</v:Envelope>

An FYI, here's something fixable by moving to the next API.

I was just debugging something and realized that on API 20.0 deleting a NewsFeed record which is a ContentPost fails.

I am implementing OAuth 2.0 User-Agent authentication flow in my Android app and after a test run I realized that I cannot use the token to access chatter photos or web UI.

I see that this limitation is documented here https://na3.salesforce.com/help/doc/en/remoteaccess_oauth_user_agent_flow.htm

"access_token

—Salesforce session ID that can be used with the Web services API. This session ID cannot be used in the Salesforce user interface. Treat this like a user's session and diligently protect it."

My problem is, that is the entire nature of my application.. which is a combining of native code using  Soap API and embedded webviews using the web UI.

So am I stuck using the old username/password+secretkey authentication, or is there some trick to using an OAuth2 token for web UI?

Are there any plans to improve the relationship.Name with query() or retrieve()?  As it is right now, there is no guarantee that an sobject has a .Name, and in fact even if there is a designated "name" field it may not work with the .Name alias.  Case.Name (error) versus Case.CaseNumber for example.

I will explain the impact.  Mobile application, and displaying an sobject.  Very efficiently any sobject *could* be rendered if you mobilize describeSObject/describeLayout for it, issue a retrieve() with relationship.Name for all lookup fields.  However, since there is no guaranteed .Name for all sobjects, one must mobilize the describeSObject for each and every lookup in the root sobject, just so that it can build the retrieve() with the proper relationship.Field to render.  Terrible waste of resources.

The funny thing is that, in fact, there appears to be core code which forces relationship.Name to work with polymorphic lookup fields.  You can see that Event What.Name works fine despite some of the sobjects not supporting relationship.Name in nonpolymorphic lookup fields.  I'm left to wonder why it works there and not in the regular lookup fields.

Anyhow, I wanted to go on record and request that relationship.Name should always work in query() and retrieve().  It would save a tremendous amount of CPU cycles and traffic on the wireless.  Good for the environment and all that.

 I am implementing a soap client in java utilizing jaxb and spring webservices so I don't have to build out the various stub files for the wsdl. I have been successful with login() and getServerTimestamp(). I am now looking at the upsert(). The request body for the upsert() is as follows (retrieved this using soapUI). I understand the sessionHeader and the resetting of the service endpoint after login, however I am not clear on how to insert the sObjects based on this request outline. Currently I would only be using the wsdl to upsert personAccounts. Could someone provide me an example of a raw xml request that would upsert personAccounts or any sObject?

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:urn="urn:enterprise.soap.sforce.com" xmlns:urn1="urn:sobject.enterprise.soap.sforce.com">
   <soapenv:Header>
      <urn:EmailHeader>
         <urn:triggerAutoResponseEmail>?</urn:triggerAutoResponseEmail>
         <urn:triggerOtherEmail>?</urn:triggerOtherEmail>
         <urn:triggerUserEmail>?</urn:triggerUserEmail>
      </urn:EmailHeader>
      <urn:PackageVersionHeader>
         <!--Zero or more repetitions:-->
         <urn:packageVersions>
            <urn:majorNumber>?</urn:majorNumber>
            <urn:minorNumber>?</urn:minorNumber>
            <urn:namespace>?</urn:namespace>
         </urn:packageVersions>
      </urn:PackageVersionHeader>
      <urn:DebuggingHeader>
         <urn:debugLevel>?</urn:debugLevel>
      </urn:DebuggingHeader>
      <urn:AllOrNoneHeader>
         <urn:allOrNone>?</urn:allOrNone>
      </urn:AllOrNoneHeader>
      <urn:DisableFeedTrackingHeader>
         <urn:disableFeedTracking>?</urn:disableFeedTracking>
      </urn:DisableFeedTrackingHeader>
      <urn:AllowFieldTruncationHeader>
         <urn:allowFieldTruncation>?</urn:allowFieldTruncation>
      </urn:AllowFieldTruncationHeader>
      <urn:MruHeader>
         <urn:updateMru>?</urn:updateMru>
      </urn:MruHeader>
      <urn:AssignmentRuleHeader>
         <urn:assignmentRuleId>?</urn:assignmentRuleId>
         <urn:useDefaultRule>?</urn:useDefaultRule>
      </urn:AssignmentRuleHeader>
      <urn:SessionHeader>
         <urn:sessionId>?</urn:sessionId>
      </urn:SessionHeader>
   </soapenv:Header>
   <soapenv:Body>
      <urn:upsert>
         <urn:externalIDFieldName>?</urn:externalIDFieldName>
         <!--Zero or more repetitions:-->
         <urn:sObjects>
            <!--Zero or more repetitions:-->
            <urn1:fieldsToNull>?</urn1:fieldsToNull>
            <urn1:Id>?</urn1:Id>
         </urn:sObjects>
      </urn:upsert>
   </soapenv:Body>
</soapenv:Envelope>

I am processing some results from the Metadata API, and I see in the ListView filters some undocumented field names. I am guessing they are similar to the date literals (THIS_WEEK etc), but I can't find a listing of them.

I see CONTACT.CREATED_DATE, and I believe I saw CREATEBY_USER elsewhere. Is there a list of these literals somewhere?

I'm posting this on the offchance that someone will find the error before I wake up tomorrow :-)

I get an error when I try to retrieve() ListView via the metadata API. It says "Element {}unpackaged invalid at this location".

Are there any SOAP retrieve() examples which I can use for comparison?

<v:Envelope xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns:d="http://www.w3.org/2001/XMLSchema" xmlns:c="http://schemas.xmlsoap.org/soap/encoding/" xmlns:v="http://schemas.xmlsoap.org/soap/envelope/"><v:Header><n0:SessionHeader xmlns:n0="http://soap.sforce.com/2006/04/metadata"><n0:sessionId>snipsnip</n0:sessionId></n0:SessionHeader></v:Header>
<v:Body>
 <n1:retrieve id="o0" c:root="1" xmlns:n1="http://soap.sforce.com/2006/04/metadata">
  <apiVersion i:type="d:double">21.0</apiVersion>
  <unpackaged i:type="n1:Package">
   <types i:type="n1:PackageTypeMembers">
    <members i:type="d:string">*</members>
    <name i:type="d:string">Contact.AllContacts</name>
   </types>
   <types i:type="n1:PackageTypeMembers">
    <members i:type="d:string">*</members>
    <name i:type="d:string">Contact.BirthdaysThisMonth</name>
   </types>
   <types i:type="n1:PackageTypeMembers">
    <members i:type="d:string">*</members>
    <name i:type="d:string">Contact.MyContacts</name>
   </types>
   <types i:type="n1:PackageTypeMembers">
    <members i:type="d:string">*</members>
    <name i:type="d:string">Contact.NewLastWeek</name>
   </types>
   <types i:type="n1:PackageTypeMembers">
    <members i:type="d:string">*</members>
    <name i:type="d:string">Contact.NewThisWeek</name>
   </types>
   <version i:type="d:string">21.0</version>
  </unpackaged>
 </n1:retrieve>
</v:Body>
</v:Envelope>

An FYI, here's something fixable by moving to the next API.

I was just debugging something and realized that on API 20.0 deleting a NewsFeed record which is a ContentPost fails.

Folks,

I am using Chatter web services API to get the smallphotourl from the user table. But how can I actually download this photo? I want to use this photo in an ASP.net website. If I try a httpwebrequest to this smallphotourl, I get a html with JavaScript back, not the actual image! Can anyone help?

I am implementing OAuth 2.0 User-Agent authentication flow in my Android app and after a test run I realized that I cannot use the token to access chatter photos or web UI.

I see that this limitation is documented here https://na3.salesforce.com/help/doc/en/remoteaccess_oauth_user_agent_flow.htm

"access_token

—Salesforce session ID that can be used with the Web services API. This session ID cannot be used in the Salesforce user interface. Treat this like a user's session and diligently protect it."

My problem is, that is the entire nature of my application.. which is a combining of native code using  Soap API and embedded webviews using the web UI.

So am I stuck using the old username/password+secretkey authentication, or is there some trick to using an OAuth2 token for web UI?

I understand that the Blackberry and Android app for Chatter is coming out soon (i think), but I have checked the Android Market for apps and I noticed a couple of apps that support Chatter.

One of them is Seesimic by Seesmic that mentions it supports Chatter along with Twitter and Google Buzz and the other is called Chatter by Moe Khan.

Has anyone had any experience with either one of these apps?

Hello everyone,

Is there any way to have in Contact Layout the number of activities that I've had with him? Because we would like to know which clients require more attention and resources.

Are there any plans to improve the relationship.Name with query() or retrieve()?  As it is right now, there is no guarantee that an sobject has a .Name, and in fact even if there is a designated "name" field it may not work with the .Name alias.  Case.Name (error) versus Case.CaseNumber for example.

I will explain the impact.  Mobile application, and displaying an sobject.  Very efficiently any sobject *could* be rendered if you mobilize describeSObject/describeLayout for it, issue a retrieve() with relationship.Name for all lookup fields.  However, since there is no guaranteed .Name for all sobjects, one must mobilize the describeSObject for each and every lookup in the root sobject, just so that it can build the retrieve() with the proper relationship.Field to render.  Terrible waste of resources.

The funny thing is that, in fact, there appears to be core code which forces relationship.Name to work with polymorphic lookup fields.  You can see that Event What.Name works fine despite some of the sobjects not supporting relationship.Name in nonpolymorphic lookup fields.  I'm left to wonder why it works there and not in the regular lookup fields.

Anyhow, I wanted to go on record and request that relationship.Name should always work in query() and retrieve().  It would save a tremendous amount of CPU cycles and traffic on the wireless.  Good for the environment and all that.

I am accessing the chatter object feedtrackedchange and presenting them in our own custom ui. We want to present all of an object's feed change records grouped by the changed date. Is it possible to group them all together using the date or is there a better idea?

For example, we have chatter turned on for 2 fields on the Account object. When both fields are changed we want to present the tracked changes together rather than each each seen as a separate feed changes. Should I use the date to relate these two changes together or is there another field I should be using?

James

BasicGov.com

With the new API 20.0 version, seems like we get access to photos using SmallPhotoUrl and FullPhotoUrl, but seems like i need to have my salesforce session while accessing these images.

I have 2 requirements:

1. Way to download the image (get Image method)

2. Or an external shared image which can be accessed without salesforce session,

Is it possible with new API 20?