I've tried this query several ways and I can't get it to work unless I use a number for the Accountid. I would like to use a name instead of a number. According to the documentaiotn on Contact filelds found here (http://na24.salesforce.com/help/pdfs/en/salesforce_field_names_reference.pdf) (page 30), Account Name is an ID instead of a name. Anyway, this is confusing.

Here is the query that works.

Select Id, FirstName, LastName, MailingStreet, MailingCity, MailingState, MailingPostalCode, MailingCountry, MobilePhone, Email, PhotoUrl, CreatedDate, Accountid from Contact where Accountid = 'SOMEID'

Here is how I would like to filter the results.

I would like to retreive all Contacts where the Account Name = "ABC Company'.

Thanks

I am getting an invalid token message when making a JSON request. I found this article on refresing tokens.

https://www.salesforce.com/us/developer/docs/api_rest/Content/intro_understanding_refresh_token_oauth.htm

In order to refresh the token, it appears that I have to make a POST request with the current token.

https://login.salesforce.com/services/oauth2/token?grant_type=refresh_token&client_id=MYCLIENTID&client_secret=MYCLIENTSECRET&refresh_token=????

I have searched and searched and searched, but I can not find an article or blog post that explains how to retreive the access token or how to view it.

Any help anyone can provide would be much appreciated.

Thanks,

Brian
 

I've tried this query several ways and I can't get it to work unless I use a number for the Accountid. I would like to use a name instead of a number. According to the documentaiotn on Contact filelds found here (http://na24.salesforce.com/help/pdfs/en/salesforce_field_names_reference.pdf) (page 30), Account Name is an ID instead of a name. Anyway, this is confusing.

Here is the query that works.

Select Id, FirstName, LastName, MailingStreet, MailingCity, MailingState, MailingPostalCode, MailingCountry, MobilePhone, Email, PhotoUrl, CreatedDate, Accountid from Contact where Accountid = 'SOMEID'

Here is how I would like to filter the results.

I would like to retreive all Contacts where the Account Name = "ABC Company'.

Thanks

I am getting an invalid token message when making a JSON request. I found this article on refresing tokens.

https://www.salesforce.com/us/developer/docs/api_rest/Content/intro_understanding_refresh_token_oauth.htm

In order to refresh the token, it appears that I have to make a POST request with the current token.

https://login.salesforce.com/services/oauth2/token?grant_type=refresh_token&client_id=MYCLIENTID&client_secret=MYCLIENTSECRET&refresh_token=????

I have searched and searched and searched, but I can not find an article or blog post that explains how to retreive the access token or how to view it.

Any help anyone can provide would be much appreciated.

Thanks,

Brian
 

Is it possible to add a day to a Datetime variable, for example myDate contains 31/08/2008, how can I add one day to it, which will make it become 01/09/2008?

Cheers