Skip to main content

Writing sign for URL ...write signature for Google Geocoding API

I have chance to work with Google Geocoding API Salesforce of course.

The requirement is to retrieve address from Google Geocoding by passing postal code.When passing postal code through HttpRequest, it should return the response in JSON.But I am not going to write how I call it in this entry.I will save it for future.*cough*
So I will write on how to generate signature...
Note on this limitation between free API and paid one.

Users of the free API:
  • 2,500 requests per 24 hour period.
  • 10 requests per second.
Maps for Business customers:
  • 100,000 requests per 24 hour period.
  • 10 requests per second.
To create API you can go here .Use our own Google account.But I found out without API key also it works.

See!!This is can play around with it.

So I go for Maps for Business customers, what is that mean?
It means , we required to have client and signature.

Google will give us client and private key.But it does not mean that we are on now.We need generate the signature using private key given.Each time when we request for postal code, we need to generate signature.
Example, postal code different so signature also can be different.

Actually it sound like a lot of job to generate signature.It is not fun because only Phyton and Java examples that available.I need to generate signature before calling the webservice.Calling out itself have limitation in Salesforce.*sigh*

But I after done some research, do experiment ,asking around last I managed to generate the signature in Apex class.One of the forum that inspired me is here . But it seem that I need to play around with replace method  before execute urlEncode.

Anyway, here the code.Note for this we need to use hmacSHA1 algorithm.
You can go ahead and run in Apex Execute Anonymous, but make sure that you have the client and private key.Hope it will help you.I could not guarantee it is error free, but it works for me.Let me know if you have better solution.

*Because this is for corporate use, go ahead and ask Google support.

//replace the number with any postal code to test
String baseUrl = '';
URL url = new URL(baseURL);
String path =url.getPath();
String query=url.getQuery();
String input=path+'?'+query;

String privateKey='whateverkeythatyougot';

Blob decodePK = EncodingUtil.base64Decode(privateKey);
String algorithmName = 'hmacSHA1';
Blob hmacData = Crypto.generateMac(algorithmName, Blob.valueOf(input), decodePK);

String encodePK =EncodingUtil.base64Encode(hmacData);
//please make sure to replace.
encodePK = encodePK.replace('+', '-');
encodePK = encodePK.replace('/', '_');
String signature =EncodingUtil.urlEncode(encodePK, 'UTF-8');
signature = signature.replace('+', '-');
signature = signature.replace('/', '_');

baseUrl +='&signature='+signature;

//this is the final URL that  can be pasted to browser
system.debug('@unid baseURL ='+ baseURL);

Google Geocoding API
Digital Signature
Stack Overflow
Salesforce Crypto Class


Popular posts from this blog

Search Solution Basics

When is it a good time to create a customized search solution? You're developing an external knowledge base for user support. You're in the mood for a fun Friday night. The sales reps just started using the Sales Cloud in Lightning Experience. You want to put your company branding in the search bar. What differentiates SOSL from SOQL? Syntax SOSL searches the search index instead of the org database. SOSL searches more efficiently when you don't know in which object the data resides. All of the above. SOSL works with: REST only SOAP only REST, SOAP, and Apex SOQL only What does a search for a single object look like in SOSL? FIND {cloud} RETURNING Account FIND in ACCOUNT RETURNING "cloud" FIND "cloud" in ACCOUNT FIND (cloud) RIGHT NOW! What does a search for multiple objects look like in SOSL? FIND {sneakers} RETURNING ALL ARTICLES FIND {sneakers} in ALL OBJECTS FIND {sneakers} RETURNING Product2, Content

Process Builder is not fired when field update is called from Approval Process

Scenario In Final Approvals section ; in Approval Process we have field update to update Status field. In Process Builder , we have some action that need to be done when Status field is updated in Approval Process.However this process builder is not fired. Solution To handle this, in Field Update in Approval Process , check Re-evaluated Workflow Rules after Field Change as picture below. What happen if field updated from Approval Process. Workflow - does not fires untill Re-evaluate workflow checkbox is ticked on your field update Process Builder - does not fires untill Re-evaluate workflow checkbox is ticked on your field update Trigger - will fire if conditions are matched This is explained in article here  . Field Updates That Re-evaluate Workflow Rules If  Re-evaluate Workflow Rules After Field Change  is enabled for a field update action, Salesforce  re-evaluates all workflow rules on the object if the field update results in a change to the value of the fi

Tips and Tricks : Test class for Invocable method

Issue : I got 100% coverage in my sandbox but when run validation for deployment it returns 0% coverage It turn out that in my sandbox, I am depending on Process Builder to Invocable Apex class, as long I manipulate test data that fire Process Builder it will call Invocable class. This is not useful when deploying it to Production although it gets deployed together with Process Builder. The correct way is to direct call Invocable method inside test class itself. Example of class : 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 global class MyCustomObject_StatusUpdate_Util { @InvocableMethod ( label = ' Update Quote Status ' ) public static void updateQuote ( Request [] requests ) { Set < Id > setOppId = new Set < Id >(); List < SBQQ__Quote__c > listQuoteToUpdate = new List < SBQQ__Quote__c >(); for ( Request request : requests ) {