Integrating with Salesforce (Part 2)

10 Comments

1. Completed Assignment for Day 9

2. Completed Assignment for Day 9

   All the fields that are mentioned(Name, Organizer etc.,) are not available on my developer org on standard Event object and hence could not get them. Was able to get the fields that are available on the Event object in the dev org.

3. assignment done.
   Not all fields were available on my org. .Could not find Attendees field in Field and Relationship settings.
   I tried to access Name as WhoId.Name, but it gave me error.

4. Name and Organizer fields are similar as WhoId.Name and OwnerId. So can we just use WhoId and OwnerId instead of Name and Organizer. Also, AttendeesField is available in page Layout to me. But not in Field and Relationship. Can you please guide me, Why does?

   Thanks!
   Arjinder Kaur

5. Hello,
   thanks for the detailed explanation

   I have a query here like – Do we use Remote site setting and Connected App while we are doing integration using SOAP Web service ?
   I have seen in your videos that while integrating Salesforce with some other app using REST web service, we use Remote site setting (if it is an outbound) and Connected app (if is an inbound).
   But while integrating using SOAP we havent used Remote site setting and Connected app.

   Please can you explain this ?

6. Chinmaya, Remote Site Settings are leveraged to whitelist an external url and make Salesforce aware. This is used when calls need to be made from Salesforce to an external app or a service.

   Connected Apps are used when external or third party services or apps intend to communicate with Salesforce. Connected Apps are used for authentication wheres Remote Site Settings are purely for whitelisting.

7. Code for Assignment Day 9
   ——————————–

   @RestResource(urlMapping = ‘/Event/*’)
   global with sharing class EventRestManager {
   @HttpGet
   global static String getEventDetailsById(){
   RestRequest request = RestContext.request;
   Integer attendees = 0;
   Map eventDetail = new Map();

   try{
   String eventId = request.requestURI.substring(request.requestURI.lastIndexOf(‘/’) + 1);
   System.debug(‘EventId:’ + eventId);

   Event event = [SELECT Id,What.Name,Owner.Name,StartDateTime,EndDate,Location,Event_Number__c,
   Account.BillingStreet,Account.BillingCity,Account.BillingState,
   Account.BillingPostalCode,Account.BillingCountry,
   (SELECT Id FROM EventRelations where IsInvitee=TRUE)
   FROM Event where id=:eventId];

   for(EventRelation relation : event.EventRelations) {
   attendees = attendees + 1;
   }

   Date dt = (Date)event.EndDate;
   String endDate = DateTime.newInstance(dt.year(),dt.month(),dt.day()).format(‘d-MM-YYYY’);

   String location = ”;
   System.debug(‘Locaion’ + String.isNotEmpty(location));
   if(String.isNotBlank(event.Account.BillingStreet) && String.isNotEmpty(event.Account.BillingStreet) && event.Account.BillingStreet != null){
   location = event.Account.BillingStreet;
   }
   if(String.isNotBlank(event.Account.BillingCity) && String.isNotEmpty(event.Account.BillingCity) && event.Account.BillingCity != null){
   location = location + ‘,’ + event.Account.BillingCity;
   }
   if(String.isNotBlank(event.Account.BillingState) && String.isNotEmpty(event.Account.BillingState) && event.Account.BillingState != null){
   location = location + ‘,’ + event.Account.BillingState;
   }
   if(String.isNotBlank(event.Account.BillingPostalCode) && String.isNotEmpty(event.Account.BillingPostalCode) && event.Account.BillingPostalCode != null){
   location = location + ‘,’ + event.Account.BillingPostalCode;
   }
   if(String.isNotBlank(event.Account.BillingCountry) && String.isNotEmpty(event.Account.BillingCountry) && event.Account.BillingCountry != null){
   location = location + ‘,’ + event.Account.BillingCountry;
   }
   System.debug(‘Locaion’ + location);
   eventDetail.put(‘Name’,event.What.Name);
   eventDetail.put(‘Organizer’,event.Owner.Name);
   eventDetail.put(‘Start Date’,event.StartDateTime.format(‘d-MM-YYYY’));
   eventDetail.put(‘End Date’,endDate);
   eventDetail.put(‘Location’,location);
   eventDetail.put(‘Attendees’,attendees);
   eventDetail.put(‘Event Number’,event.Event_Number__c);
   } catch(System.QueryException e){
   eventDetail.put(‘Error Message’,’Please Enter valid EventId’);
   }
   return System.JSON.serialize(eventDetail);
   }

   }

8. Solution: Apex Class as follow –>
   ————————————————————————————————————————————–

   @RestResource( urlMapping = ‘/Event/*’ )
   global with sharing class EventManager {
   @HttpPost
   global static ID createEvent ( String name, String subject, String loc, String stdate, String enddate ) {
   Event newEvent = new Event (
   Subject = subject,
   Location = loc,
   StartDateTime = DateTime.valueof(stdate),
   EndDateTime = datetime.valueof(enddate)

   );

   insert newEvent;
   return newEvent.Id;
   }

   @HttpGet
   global static Event getEventById() {
   RestRequest request = RestContext.request;
   String eventId = request.requestURI.substring ( request.requestURI.lastIndexof(‘/’)+1 );
   Event result = [SELECT Subject, Location, StartDateTime, EndDateTime FROM Event WHERE Id =:eventId];
   return result;

   }

   @HttpPut
   global static ID updateEventField ( ) {
   RestRequest request = RestContext.request;
   String eventId = request.requestURI.substring ( request.requestURI.lastIndexof(‘/’)+1 );
   Event thisEvent = [SELECT Id FROM Event WHERE Id =:eventId];

   //Deserilize the JSON string into name-value pairs
   Map params = (Map) JSON.deserializeUntyped ( request.requestBody.tostring() );
   // *********** Please Add String,Object within angular brackets after Map on above line of code******************

   for(String fieldName : params.keySet()){
   thisevent.put(fieldName, params.get(fieldName));
   }
   update thisEvent;
   return thisEvent.Id;

   }
   }

9. i am learning from your youtube channel…i also have completed this assignment…rather i have completed all the assignments…
   code
   @RestResource(urlMapping=’/Events__c/*’)
   global with sharing class ApexRestAssignment {

   @HttpGet
   global static Event__c getEventDetailsById()
   {
   RestRequest request=RestContext.request;
   String eveid=request.requestURI.substring(request.requestURI.lastIndexOf(‘/’)+1);
   Event__c obj=[select Name__c,organizer__c,start_date__c,End_Date__c,location__c,attendees__c,Name from Event__c where id=:eveid];
   return obj;
   }
   @HttpPost
   global static Id createEvent(String name,String organizer)
   {
   Event__c opp=new Event__c(
   Name__c=name,
   Organizer__c=organizer

   );
   insert opp;
   return opp.Id;
   }

   }

10. how do I create multiple records of an sObject (say 20 account records) in one api call to salesforce using SOAP.(inboud basically). So I need to understand 2 things here.

    1. What parameter should my apex webservice accept?
    2. how do I modify the WSDL in SOAP UI tool to send multiple records in one api call ?