Salesforce.com Certified Force.com Developer

Finally I have found time to pass developer certification.

In this post I will gather all useful links and docs that helped me in preparation to exam.

Books:

• Force.com Developer Certification Handbook 2012 by Siddhesh Kabe - every person that wants to pass exam definitely needs to read this book. Here you can find answers to almost all questions about certification. Also this book will be useful for those who are starting learning Salesforce.

Materials:

• Force.com Developer Certification
• The Road to Advanced Force.com Developer Certification
• Mock exam for Force.com developer exam

Flashcards:

• Flashcards 401 WI14 Part 1
• Flashcards 401 WI14 Part 1
• Flashcards 401 WI14 Part 3
• Flashcards 401 SU12 Part 1
• Flashcards 401 SU12 Part 2
• Flashcards 401
• Flashcards 401
• Flashcards 401

Exotic SF objects with properties.

This is list of exotic SF objects and their properties. List will be growing, as I will add new after "playing".

API Name	Prefix	Trigger	DML	SOQL	REST	Describe
CurrencyType	01L	No	No DML [1]	+		+
DatedConversionRate	04w	No	No DML [1]	+	POST / DELETE	+
Application	06P	No	No DML	No SOQL		No describe
AppManifes	0Ci	No	No DML	No SOQL		No describe
AccountTerritoryAssignmentRule	-	No	No DML [1]	No SOQL		No describe

References:

1. sObjects That Don’t Support DML Operations;

Enjoy.

How to get today's exchange rate and historical data.

To get today's exchange rate we need to go to yahoo console. Query "yahoo.finance.xchange" object with pairs of currencies we want. Link with query to get today's exchange rate between pairs EUR-USD and GBP-USD from Yahoo:

http://query.yahooapis.com/v1/public/yql?q=select%20*%20from%20yahoo.finance.xchange%20where%20pair%20in%20(%22EURUSD%22%2C%22GBPUSD%22)&diagnostics=true&env=store%3A%2F%2Fdatatables.org%2Falltableswithkeys

URL is easy to parse and to create. It will return JSON with needed rates.

But getting historical data is a little bit harder. Yahoo do not give us historical data of currency. But on Yahoo website exists page Currency Converter, that have exchange rate for any currency for any date. In the end of page there is note that data is taken from another sources: Commodity Systems and Thomson Financial Network. Analyzing network data that is sent to server we found URL:

http://finance.yahoo.com/connection/currency-converter-cache?date=20140102

This link returns us JSON object of exchange rate all currencies to USD. You can change parameter 'date' in URL and get rate for specific date.

Enjoy.