Sundog

Call the Infusionsoft API from Salesforce - Part II

terry.luschen@sundoginteractive.com (Terry Luschen) — 2015-02-25T23:43:17+00:00

In the last blog post I described the Infusionsoft API and how to get an access token. In this blog post I will show one example on how to use that access token to make an Infusionsoft API call.

There are a wide variety of API calls that can be made. One cool feature on the Infusionsoft site is this page which allows you to test out their API without having to write any code.

The example API call that I would like to show you involves pulling back the fields from a report. Here is an example report URL from Infusionsoft:
https://vm921.infusionsoft.com/Reports/searchTemplate.jsp?filterId=999&reportClass=ClassName

where 999 is the user who created this report and ClassName is the name of this report. Note that sometimes the filterId is 0, but that means everybody can run it. When you call the API as I describe below send a 1 instead of a 0.

We want to use the ‘SearchService’ options within the API. The getAllReportColumns() call will retrieve all of the columns available in a report. That could be useful in creating some generic reporting routines. The getSavedSearchResultsAllFields() call will return all fields in the report. That call returned too much data for me so I decided to use the getSavedSearchResults() call so I could limit the number of fields returned.

One important item to remember when calling reports is that the report parameters cannot be changed when calling the API. So we cannot dynamically change a report to bring back payments from the last 10 days instead of the last 30 days. Keep that limitation in mind when designing your integration. Also note that in the getSavedSearchResults() api call that a pageNumber must be specified. This start with 0 for the first 1000 records and then 1 will be the next 1000 and so on. So you need to be able to design your calls so that you keep making calls by incrementing this pageNumber parameter until you do not get anymore rows back.

So finally onto the code to make our call:


public static string callWebCart(string accessToken){
		
       string xmlBody = '<?xml version="1.0" encoding="UTF-8"?>' +
			'<methodCall>' +
				'<methodName>SearchService.getSavedSearchResults</methodName>' +
					'<params>' +
						'<param><value><string>myapiKey</string></value></param>' + //apiKey
						'<param><value><int>999</int></value></param>' + //Saved Search ID
						'<param><value><int>1</int></value></param>' + //userID
						'<param><value><int>0</int></value></param>' + //page number, start at 0 for first 1000 records
						'<param><value><array><data>' +
							'<value><string>Id</string></value>' + //Fields for report
							'<value><string>ContactId</string></value>' +
						'</data></array></value></param>' +
					'</params>' +
				'</methodCall>';
		
        Http h = new Http();
        HttpRequest req = new HttpRequest();
        req.setHeader('Content-Type','application/xml'); 
        req.setHeader('Content-Type','text/xml;charset=UTF-8');
        req.setHeader('Content-Length',string.valueOf(xmlBody.length()));     
        req.setEndpoint('https://api.infusionsoft.com/crm/xmlrpc/v1?access_token=' + accessToken);
        req.setMethod('POST');
	req.setTimeout(60000);
	req.setBody(xmlBody);
	      
	string bodyValue = '';
	if(test.isRunningTest()){
	  bodyValue = getExamplePaymentXMLResult();
	}else{
	  HttpResponse res = h.send(req);
	  bodyValue = res.getBody();
	}

	if((bodyValue == '<h1>Developer Inactive</h1>' || bodyValue == '<h1>Not Authorized</h1>')){
	   //Get new Access Token using the refresh token and call the api again
	}

	return bodyValue;
}

The fields to pull back are placed in the XML in a repeated fashion after the page number section. It takes a bit of getting used to in that the order of the parameters drives what they are. We do not get to set a ‘pageNumber’ xml node to define the page number. We have to know that the page number goes into the 4th piece of data after the UserID.

Once you get the bodyValue back you can use various XML parsing methods to get out your data and then save it into Salesforce per your requirements.

Salesforce provides so many integration points and options. Please get in touch with me if you have any questions about how to make Salesforce integrate with other related data within your organization.

Call the Infusionsoft API from Salesforce

terry.luschen@sundoginteractive.com (Terry Luschen) — 2015-02-25T23:13:58+00:00

Infusionsoft leverages OAuth2 to provide authentication to the API. The documentation on this page will get you started with descriptions about their API. You can also test out many of their APIs here to see how they can work for you.

With OAuth2 one of the first steps will be to redirect to an authorization endpoint to allow the user to authenticate. Once that is complete the returnback URL will be called, which will include the authorization code included as the ‘code’ query string parameter on the URL. Once that is complete and we have the authorization code we will be able to make the call to request an access token. Here is what that code looks like in Salesforce Apex.


public static void retrieveInfusionsoftAccessToken(string authorizationCode){
	Http h = new Http();
    	HttpRequest req = new HttpRequest();
    	req.setEndpoint('https://api.infusionsoft.com/token');
    	string bodyRequest = '';
        string bodyResponse = '';
    	bodyRequest += 'client_id=' + EncodingUtil.urlEncode('myClientID', 'UTF-8'); 
    	bodyRequest += '&client_secret=' + EncodingUtil.urlEncode('myClientSecret', 'UTF-8');
    	bodyRequest += '&code=' + EncodingUtil.urlEncode('myAuthorizationCode', 'UTF-8');    	
    	bodyRequest += '&redirect_uri=' + EncodingUtil.urlEncode('myRedirectURL', 'UTF-8'); 
    	bodyRequest += '&grant_type=authorization_code';
    	req.setBody(bodyRequest);    	
    	req.setHeader('Content-length', string.ValueOf(bodyRequest.length()));	
    	req.setHeader('Content-Type', 'application/x-www-form-urlencoded');
    	req.setMethod('POST');
    	req.setTimeout(10000);
    	if(test.isRunningTest()){
	      if(doAccessPointError){ //Instance variable to allow testing of error conditions
	      	bodyResponse = '{"error":"failure"}';
      	     }else{
      	  	bodyResponse = '{"access_token":"9uzhtptnfvgq2j96b3m87z6z","token_type":"bearer","expires_in":28800,"refresh_token":"g4xcllhk6qbgngnxve78cj6t","scope":"full|ji877.infusionsoft.com"}';
      	     }	      
	 }else{
	      HttpResponse res = h.send(req);
	      bodyResponse = res.getBody();
	 }
				
	map<string, string> jsonValues = new map<string, string>();		

	//This routine will parse the JSON into a map
	jsonValues = parseJSONToMap(bodyResponse);			
}

The data being posted to Infusionsoft for this ‘token’ method is the same as most other OAuth2 implementations. We need the client_id, client_secret, code, redirect_uri and grant_type.

Within the returned JSON will be the access token and the refresh token. These should be saved into a custom object or custom setting for later use. At some point the life span of the access token will run out and then the refresh token will be needed to make a call to get a new access token.

In my next blog post I will show one call to the Infusionsoft API using the retrieved access token.

Please contact us at Sundog if you need help with integration projects that leverage OAuth2.

Getting an Attribute Value from XML - Salesforce

terry.luschen@sundoginteractive.com (Terry Luschen) — 2015-02-25T22:19:11+00:00

Almost a couple of years ago I posted this blog post about methods to parse XML: Parsing XML in Salesforce APEX

These methods work great when the XML is not very large and when the XML does not contain attributes. If the XML is too large, then the split routines can produce errors like ‘Regex is too complicated’, which basically means that the string is too long to be parsed effectively.

So what if your XML does contain attributes? It might look like this:

<Person age="42"><FirstName>Terry</FirstName><LastName>Luschen</LastName></Person>

So the ‘age’ is our attribute that we want to get out. I would rather have the XML contain a section that looks like the following, but that is not always my choice.

<Person><Age>42</Age><FirstName>Terry</FirstName><LastName>Luschen</LastName></Person>

So how are we to get that “42” value out? I have found the easiest way is to call the following routine that leverages the Apex XMLStreamReader class.


public static string getAttributeInXML(string xmlToParse, string nodeName, string attributeName) {
		if(xmlToParse.startsWith('<?xml version="1.0" encoding="UTF-8"?>') == false){
			xmlToParse = '<?xml version="1.0" encoding="UTF-8"?><OUTER_TAG>' + xmlToParse + '</OUTER_TAG>';
		}
		XmlStreamReader reader = new XmlStreamReader(xmlToParse);
		reader.setCoalescing(true);

		try {
			while(reader.hasNext()) {			
				if (reader.getEventType() == XmlTag.START_ELEMENT) {
					if(reader.getLocalName() == nodeName){ //Check if the node name matches						
						for (integer i=0; i < reader.getAttributeCount(); i++) { 
							if(reader.getAttributeLocalName(i) == attributeName){  //Check if this attribute matches
								return reader.getAttributeValueAt(i);
							}						
						}		
					}								
					reader.next();					
				} else if (reader.getEventType() == XmlTag.END_ELEMENT) {	
					reader.next();
				} else if (reader.getEventType() == XmlTag.CHARACTERS) {
					reader.next();
				}else{ 
					reader.next(); 
				} 	
			}
		} catch(Exception e) { // ParseError if we get a truncated response, allow it
			system.debug(e);
		}
		return '';
}	

//Call this routine like this and it should return 42
getAttributeInXML('<Person age="42"><FirstName>Terry</FirstName><LastName>Luschen</LastName></Person>', 'Person', 'age');

Notice that in the first lines of the routine that I put the xml version tags around the xml so that the XMLStreamReader is able to load it.

Typically I like to use this routine with small chunks of XML so that the while loop does not have to parse through a ton of XML to get to the desired attribute.

Good luck with your next XML integration.

Please let us know at Sundog if you an integration project! We will get your data where it needs to go!

Upserts with Generic sObjects - Salesforce

terry.luschen@sundoginteractive.com (Terry Luschen) — 2015-02-25T21:41:17+00:00

Have you ever run into this error? “Upsert with a field specification requires a concrete SObject type”

Basically it is saying that you cannot declare a list of type sObject and then try to use the upsert command against that list. That limitation can make coding generic routines difficult which do not know the specific object type up front. For example, I might be building a table driven integration layer where the user will determine, by updating a custom field or custom setting, what the name of the destination custom object will be. With this approach I will need to use the generic sObject data type, but that will stop me from using the upsert database command.

Bummer! What to do?

Here is a link that describes this problem very clearly and jangiz at the bottom describes the correct work-around approach.

Here is some code to implement that work-around that jangiz described:

list<sObject> sObjList = new list<sObject>();

//This routine would get the rows to update/insert from some business logic
sObjList = myClass.getObjectRowsToUpdate(); 
set<string> newExtIDSet = new set<string>();
string myExternalIDField = 'myExternalID__c';

//Loop through and build a set of External IDs that should be used for a query
for(sObject sObjItem : sObjList){
     tempStr = string.ValueOf(sObjItem.get(myExternalIDField));
     if(string.isBlank(tempStr) == false){
	newExtIDSet.add(tempStr);
     }
}

list<sObject> sObjExistingList = new list<sObject>();
//Now use those external IDs for matching
string sQuery = 'Select ID, ' + myExternalIDField +
     ' From myUpdateObj__c' +
     ' Where ' + myExternalIDField + ' IN :newExtIDSet';
sObjExistingList = database.query(sQuery);

//Now loop through the matches and build a map of that external ID to the actual Salesforce ID
map<string, string> extIDToIDMap = new map<string, string>();
for(sObject sObjItem : sObjExistingList){
     extIDToIDMap.put(string.valueOf(sObjItem.get(myExternalIDField)), sObjItem.ID);
}

//Now loop through the items to be updated/inserted and assign the Salesforce IDs to that items that matches by the External ID
list<sObject> sObjInsertList = new list<sObject>();
list<sObject> sObjUpdateList = new list<sObject>();
for(sObject sObjItem : sObjList){
     if(extIDToIDMap.containsKey(string.ValueOf(sObjItem.get(myExternalIDField)))){
        sObjItem.ID = extIDToIDMap.get(string.ValueOf(sObjItem.get(myExternalIDField)));
        sObjUpdateList.add(sObjItem);
     }else{
        sObjInsertList.add(sObjItem);
     }
}
if(sObjUpdateList.size() > 0){
     update sObjUpdateList;
}
if(sObjInsertList.size() > 0){
     insert sObjInsertList;
}

Wow, what a bunch of work when I really just wanted to write…
upsert sObjList myExternalIDField

But as long as there is a manageable work-around I can at least move forward!

Good luck with your Apex today!

Is Your Content Unique?

dean.froslie@sundog.net (Dean Froslie) — 2015-02-25T20:32:15+00:00

We previously reviewed the importance of developing and documenting your content strategy. With a core strategy statement in place, your content becomes more intentional and aligned.

At the same time, this foundation doesn’t necessarily mean your content is distinctive or unique. Too often, organizations clutter their channels with content that offers the same-old guidance, tips, tools and topics. They fail to capture their brand’s unique value proposition, voice and niche.

Copyblogger challenges us to think about what our organizations bring to the table:

“How do you fit into the market? What do you bring to the table that no one else can? What makes you unique?”

Similarly, in a recent Whiteboard Friday, Rand Fishkin of Moz describes what “unique value” in content really means:

“I mean unique information … even if it were written about thousands of different ways, I couldn’t find it anywhere else on the web. You want your visitor to have experience of ‘Wow, without this site I never would have found the answers I sought.’ It’s not that, ‘Oh, this sentence is unique to all the other sentences that have been written about this topic.’ It’s, ‘Ah-ha this information was never available until now.’”

And a Content Marketing Institute post describes the value of content “shiny objects”:

“the content must be newsworthy, such as an original piece of research, the overarching guide to whatever topic you want to own in your space, or a unique perspective on a topic that represents a fresh approach. In other words, the content provides real information that people find valuable. I mean really valuable.”

Your organization is built around a mission or customer need that’s uniquely yours. It can’t be easily duplicated or imitated. Similarly, we must ensure our content reflects that one-of-a-kind viewpoint.

SUNDOG SPOTLIGHT: AMY

dani.krolak@sundog.net (Dani Krolak) — 2015-02-04T19:59:34+00:00

The spotlights are making a comeback and it’s this Minneapolis gal’s birthday week! What better way to celebrate than throwing Amy Crews in the spotlight:

Position at Sundog:
I’m a Senior Designer. The “Designer” means I can improve the way things look and the “Senior” means I’ve been doing it for many years ;)

Work experience:
I’ve been able to work with a lot of great companies that helped make me who I am today. Most recently JM Cremps, which is a toy store for boys. If you go to the second floor (N240) of Mall of America, my son is even on the 12 ft. sign in the front of the store.

Things that make you go “hmmm”:
After they make Styrofoam, what do they ship it in?

Tell us about your family:
My husband’s name is Wade. He is a Nurse Practitioner working in Sartell and has been putting up with me for 15 years now. We have 3 boys (ages 8 – Ethan, 9 – Matthew and 11 – Gavin). I am usually at some sort of field – whether that’s baseball or football – almost every night of the week.

Most recent purchase:
A hot water heater. We had to wait a week in order to get someone to come and fix it, so I really appreciate a hot shower!

What you’re doing when you’re not at the office:
Besides going to the boys’ events, I like camping, biking and going to the gun range with the boys.

Secret Power You Wish You Had:
I really do have a secret power, but I can’t tell you because then it won’t be a secret.

Thing That Makes You Cringe:
Blood

#1 Book You Recommend:
Unbroken by Laura Hilenbrand – It makes your day seem “not so bad.”

What email clients should I test on?

susanna.oliver@sundoginteractive.com (Susanna Oliver) — 2015-01-30T15:59:22+00:00

The email landscape has changed dramatically over the last several years. Two years ago, Outlook was still holding on to 20% of the market share despite mobile’s increasing influence. Now, Outlook is down to 9% and Gmail has doubled its popularity to 16% of the market share.

NOTE: These statistics are based on open rates which can only be tracked when images are loaded. Gmail used to block images by default and now allows images to load by default which probably contributed to its apparent growth.

Top Ten…With One Catch

Email Client Market Share keeps a running tally of the top ten email clients and mobile applications. This list is a great place to start your testing, but make sure you also understand your own unique audience. If your audience is young people, most likely you’ll see a higher mobile demographic than if your audience is middle-age, non-technical folks.

Know your audience and understand what they want. You want your emails to look good, but also to be practical and useful for your audience to engage with. No matter how stunning an email looks and regardless of how perfectly cross-client it is, if the content is not relevant and interesting to your audience, they won’t engage with it.

The Life & Legacy of Outlook

susanna.oliver@sundoginteractive.com (Susanna Oliver) — 2015-01-29T14:40:17+00:00

Outlook was born in 1997 to parents Windows and Office. It has lived a long and popular life despite being the object of much debate among those who know him best. His decisions and business choices have left lasting effects on the industry making many friends and enemies.

He reached the pinnacle of his career early in life and enjoyed position, popularity, and affluence. Up until 2003, his business rendering partner was I.E., but in 2007, he made his most controversial decision in which he let his partner go and aligned himself instead with M.S. Word, a decision which proved to be disastrous for the industry at large with ripple effects even today.

Despite the public outcry from developers who were frustrated by his fickle nature and lack of industry standards, Outlook followers appeared to remain loyal to the system. Although his knowledgeable critics suspect that coercion, apathy, or simply habit were the only things keeping them from leaving.

Today, Outlook still has a strong hold on the industry and in January of 2015 was still holding on to 9% of the market share, despite a loosening hold in recent years. No one knows what the future holds for Outlook, but some are still hoping he will recant his early decisions and set things right for the future.

Calling Amazon MWS - Part 4

terry.luschen@sundoginteractive.com (Terry Luschen) — 2015-01-29T01:53:22+00:00

In my last blog post ‘Calling Amazon MWS - Part 3’ we looked at the GetReportRequestList Amazon MWS API call. The GetReportRequestList call asks Amazon if a report is “_DONE_” that we had requested earlier to be generated.

There would be some type of polling mechanism with a scheduled/batch job that would keep calling GetReportRequestList until we get back that “_DONE_” status.

Now that we are “_DONE_” we can finally make the GetReport call to actually get the report data. This report can be extremely long if you have sold a lot of products within the date range you specified when the report was requested.

Here is how the GetReport call can be made in APEX on Salesforce. The myObject__c would be a custom object that would hold the credentials to make the call and also the GeneratedReportID__c value which was returned from the GetReportRequestList call.


public static string doGetReportCall(myObject__c rl){
	string returnXML = '';		
	    	
	String request = 'AWSAccessKeyId='+urlencode(rl.Access_Key_ID__c) +	
				'&Action='+urlencode('GetReport') +
	            '&Merchant='+urlencode(rl.Seller_ID__c) +
	            '&ReportId='+urlencode(rl.GeneratedReportID__c) + 
	            '&SignatureMethod='+urlencode('HmacSHA256') +
	            '&SignatureVersion='+urlencode('2') +
	            '&Timestamp='+urlencode(getTimeStampNow()) +                                                                           
	            '&Version='+urlencode('2009-01-01');
	 	 
	String canonical =  'POST'+'\n'+
	                      rl.Service_URL__c + '\n'+
	                      '/\n'+
	                      request;
	String key = rl.Secret_Key__c;     
        String signature = getSignature(canonical, key);
        String body = request + '&Signature=' + urlEncode(signature);

        Http h = new Http();
        HttpRequest req = new HttpRequest();
        req.setCompressed(true);
        req.setHeader('Host', rl.Service_URL__c);
        req.setHeader('Content-Type','text/xml');
        req.setHeader('x-amazon-user-agent','Salesforce');
        req.setEndpoint(rl.End_Point__c + '/?'+body);
        req.setMethod('POST');
	 req.setTimeout(60000);
	    
	 // Send the request, and return a response    
	 string bodyValue = '';
	 if(test.isRunningTest()){
	      bodyValue = '<?xml version="1.0"?>' +
			'' +
			'' +
			'1.00' + 
			'' + 
			'AllOrdersReport' +
			'' +
				'' +
					'204-9999999-811144' +
					'204-9999999-811144' +
					'2015-01-22T15:38:29+00:00' +
					'2015-01-24T03:17:51+00:00' +
					'Shipped' +
					'Amazon.co.uk' +
					'' +
						'Amazon' +
						'Standard' +
						'' +
							'EastSide' +
							'UB99 1SY' +
							'GB' +
						'' +
					'' +
					'' +
						'B045EN4KJI' +
						'uk-effq-cat-leash' +
						'Shipped' +
						'Cat Leash' +
						'1' +
						'' +
							'' +
								'Principal' +
								'76.95' +
							'' +
						'' +
					'' +
				'' +
			'' +
			'' +
				'' +
					'202-9124543-8311135' +
					'202-9124543-8311135' +
					'2015-01-21T22:57:20+00:00' +
					'2015-01-22T11:03:24+00:00' +
					'Shipped' +
					'Amazon.co.uk' +
					'' +
					'Amazon' +
					'Expedited' +
					'' +
					'LONDON' +
					'StateValue' +
					'AA1 6NA' +
					'GB' +
					'' +
					'' +
					'' +
					'B00NTY4KJI' +
					'uk-wigzi-rabbit-leash' +
					'Shipped' +
					'Rabbit Leash' +
					'2' +
					'' +
					'' +
					'Principal' +
					'41.23' +
					'' +
					'' +
					'' +
				'' +
			'' +
			'';
	    }else{
	      HttpResponse res = h.send(req);
	      bodyValue = res.getBody();
	    }
	    
	    System.debug(bodyValue);

	    returnXML = bodyValue;
	    return returnXML;
	}

Yeah! We have back our orders in our report!

Now once you get your XML you just need to parse it. Here is an ‘oldie but a goodie’ blog post that can help you get started with that XML parsing: Parsing XML in Salesforce APEX

There is a new way to handle the ‘if(test.isRunningTest()){’ code above by using the HttpMock and WebserviceMock interfaces. The reason for the work-around is because you cannot make the actual call-out while a test is running. The actual call-out line is HttpResponse res = h.req.send(req); The one thing about using HttpMock with tests is that you can still run into the problem where you need to insert test data before making your fake callout. This will result in an error since you cannot do DML statements before a callout. So in the end you may end up using the Test.isRunningTest() option anyway.

Good luck with your Amazon MWS integrations! I hope these blog posts have helped to get you started.

If you ever need any help with your integrations please reach out to us at Sundog. We will help you get your data to the proper destination.

Calling Amazon MWS - Part 3

terry.luschen@sundoginteractive.com (Terry Luschen) — 2015-01-29T01:14:59+00:00

In my last blog post ‘Calling Amazon MWS - Part 2’ we looked at the RequestReport Amazon MWS API call. The RequestReport call asks Amazon to run a report for us. It does not return the report right away as this is just a request to do a report.

Now we basically need to poll the Amazon MSW to keep asking it: ‘Is my report done yet?’ This can be done by having a scheduled APEX job in Salesforce call an APEX batch job.

The call we need to make is called GetReportRequestList. I do encourage you to use the Amazon MWS Scratchpad site to get a sense as to the request parameters and response values involved with this call.

Here is the code needed to make this call work. The myObject__c would be a custom object that would hold the credentials to make the call and also the Report_Request_ID value which was returned from the RequestReport call.


public static string doGetReportRequestListCall(myObject__c rl){
		string returnXML = '';
			
		String request = 'AWSAccessKeyId='+urlencode(rl.Access_Key_ID__c) +	
				'&Action='+urlencode('GetReportRequestList') +
	            '&Merchant='+urlencode(rl.Seller_ID__c) +
	            '&ReportRequestIdList.Id.1='+urlencode(rl.Report_Request_ID__c) + 
	            '&SignatureMethod='+urlencode('HmacSHA256') +
	            '&SignatureVersion='+urlencode('2') +
	            '&Timestamp='+urlencode(getTimeStampNow()) +                                                                           
	            '&Version='+urlencode('2009-01-01');
	 	 
		String canonical =  'POST'+'\n'+
	                      rl.Service_URL__c + '\n'+
	                      '/\n'+
	                      request;
	    String key = rl.Secret_Key__c;     
            String signature = getSignature(canonical, key);
	    String body = request + '&Signature=' + urlEncode(signature);

            Http h = new Http();
            HttpRequest req = new HttpRequest();
            req.setCompressed(true);
            req.setHeader('Host', rl.Service_URL__c);
            req.setHeader('Content-Type','text/xml');
            req.setHeader('x-amazon-user-agent','Salesforce');
            req.setEndpoint(rl.Credential__r.End_Point__c + '/?'+body);
            req.setMethod('POST');
	    req.setTimeout(60000);
	    
	    // Send the request, and return a response    
	    string bodyValue = '';
	    if(test.isRunningTest()){
	      bodyValue = '<?xml version="1.0"?>' +
			'' +
			'' +
			  '' +
			  'false' +
			  '' +
			    '59999916457' +
			    '_GET_XML_ALL_ORDERS_DATA_BY_ORDER_DATE_' +
			    '2015-01-22T04:22:20+00:00' +
			    '2015-01-22T04:22:20+00:00' +
			    'false' +
			    '2015-01-22T04:22:20+00:00' +
			    '_DONE_' +
			    '23654732683' +
			    '2015-01-22T04:22:31+00:00' +
			    '2015-01-22T04:22:32+00:00' +
			  '' +
			'' +
			'' +
			  '4116eb8a-e22c-4bb9-81e0-1ee4fb8c9fb7' +
			'' +
			'';
	    }else{
	      HttpResponse res = h.send(req);
	      bodyValue = res.getBody();
	    }
	    
	    System.debug(bodyValue);

	    returnXML = bodyValue;
	    return returnXML;
	}

public static string getTimeStampNow(){
	    Datetime now = Datetime.now().addDays(1);
	    String timestamp = now.formatGmt('yyyy-MM-dd')+'T'+now.formatGmt('HH:mm:ss')+'Z';
	    return timestamp;
}

public static string getSignature(string canonical, string key){
	String signature;
        Blob bsig = Crypto.generateMac('HmacSHA256', Blob.valueOf(canonical), Blob.valueOf(key));
	signature = EncodingUtil.base64Encode(bsig);
	return signature;
}

Calling GetReportRequestList ends up being very similar to called RequestReport. Even the XML returned in the response is nearly identical.

One of the most important lines in the response is the “<ReportProcessingStatus>_DONE_</ReportProcessingStatus>” section. If it is “_DONE_” then the report is ready to be retrieved.

In the next blog post we will actually get the report data itself with the GetReport call.