Hello Friends, I am back again with another part of
integration of Oracle CRM. In my previous blog of this topic we have discussed,
how to query/fetch data from Oracle CRM using exposed web services. Now this is
the time to update data back in Oracle CRM using web service.
Let’s take example of forecast/opportunity again. We have
already fetched opportunity data from Oracle CRM and suppose we have processed
it and now we want to update some data (suppose processed reference number –
i.e. URN (unique reference number)) back in Oracle CRM for same forecast/opportunity
record.
Assuming web service references are already added in project
and data fetched from Oracle CRM for forecast/opportunity using opportunity ID.
Data already processed and finally we have generated URN number and associated
Opportunity ID in session and this URN need to be updated in Oracle CRM
As we discussed earlier, there is specific process/flow of
action while calling method of web service to communicate with Oracle CRM. So
the flow/steps will be same here as well as below.
a)
Login and
create session: - We need to call login command of integration service to
login into service and generate session id to be used while calling web service
method to uniquely identify request and avoid unauthorized access to data.
Below is code snippet to call login command and fetch generated session id for
subsequent service calls.
HttpWebRequest request = null;
HttpWebResponse response = null;
//WebHeaderCollection webHeaderCollection = null;
string
sessionID = string.Empty;
string
baseURL = string.Empty;
//Login Credentials
baseURL
= ConfigurationManager.AppSettings["WebServiceURL"];
/* WebServiceURL for stage:-
"https://secure-ausomxhna.crmondemand.com/Services/Integration";
*/
//Creating web request
request
= (HttpWebRequest)HttpWebRequest.Create(new Uri(baseURL + "?command=login"));
request.Method
= "GET";
request.Headers.Set("UserName", ConfigurationManager.AppSettings["username"]);
request.Headers.Set("Password", ConfigurationManager.AppSettings["password"]);
try
{
//Getting the response
response = (HttpWebResponse)request.GetResponse();
Stream
sr = response.GetResponseStream();
//Retrieve
session ID
char[]
separator = { ';' };
String[]
headers = response.Headers["Set-Cookie"].Split(separator);
for (int i = 0; i <= headers.Length - 1; i++)
{
if (headers[i].StartsWith("JSESSIONID"))
{
separator[0]
= '=';
sessionID =
headers[i].Split(separator)[1];
break;
}
}
Session["SessionID"]
= sessionID;
sr.Close();
response.Close();
}
catch (WebException we)
{
// Log exception
}
b)
Call
actual web service method – to update data in Oracle CRM repository: -
During calling to web service we need to pass generated session id (generated
from login step (a)) with every request to Web service URL.
Refer code snippet as below to get better
understanding of web service call to update generated URN number in Oracle CRM
for specific Forecast/Opportunity record using id.
Step 1: - Extract generated session id (for web service
communication) and processed data (URN number) from session object.
string opportunityID = Convert.ToString(Session["opportunityID"]);
string sessionID = Convert.ToString(Session["SessionID"]);
Step 2: - Create an object for Forecast/Opportunity to call method
and update data and assign service URL with generated login session id.
OpportunitySvc.Opportunity
opportunityObj = new OpportunitySvc.Opportunity();
opportunityObj.Url = ConfigurationManager.AppSettings["WebServiceURL"] + ";jsessionid="
+ sessionID;
Step 3: - Create an array of Opportunity Data object for single
element to hold data which we are planning to update in Oracle CRM. Now assign
opportunity ID and generated URN in object properties.
OpportunitySvc.OpportunityData[]
oppupdata = new OpportunitySvc.OpportunityData[1];
oppupdata[0] = new
OpportunitySvc.OpportunityData();
oppupdata[0].Id = opportunityID;
oppupdata[0].stURN_FOR_CREDIT_CARD =
URN.ToString();
Step 4: - Create data object for List of opportunity data and add
your prepared opportunity data object array in it which we need to update in
Oracle CRM.
OpportunitySvc.ListOfOpportunityData
lopd = new OpportunitySvc.ListOfOpportunityData();
lopd.Opportunity = oppupdata;
Step 5: - Create an input object for input data of opportunity
update call to update processed data (URN number) in specific
fields/properties/objects data of specific forecast/opportunity record.
OpportunityUpdate_Input uinput = new
OpportunityUpdate_Input();
uinput.ListOfOpportunity = lopd;
Step 6: - Create an output object to receive output of opportunity
update call after updating processed data (URN number) in specific
fields/properties/objects data of specific forecast/opportunity record.
OpportunityUpdate_Output uoutput =
opportunityObj.OpportunityUpdate(uinput);
Step 7: - Validate returned output object and verify for valid
information in it to decide whether update call was successful or failed and
display/process success or failure code accordingly.
if (uoutput != null
&& uoutput.ListOfOpportunity != null
&& uoutput.ListOfOpportunity.Opportunity != null
&& uoutput.ListOfOpportunity.Opportunity.Length > 0 &&
uoutput.ListOfOpportunity.Opportunity[0] != null)
{
//URN saved successfully.
litMessage.Text = "Thanks for the payment. Please note your URN for
any communication.";
ClearSession();
}
else
{
litMessage.Text = "Sorry!! Your payment processed successfully but
failed to update reference number in repository. Please try by refreshing this
page again.";
}
You can also verify that
data updated in Oracle CRM or not by visiting admin tool of Oracle CRM and
verify specific forecast/opportunity record there for updated value.
c)
Logoff
and finish session: - Logoff command need to be called when we are done
with our communication with Oracle CRM to finish session and to avoid any
unauthorized access to data using earlier generated session. Below is code
snippet to call logoff command to finish session for service calls.
try
{
string baseURL1 = ConfigurationManager.AppSettings["WebServiceURL"]; //"https://secure-ausomxhna.crmondemand.com/Services/Integration";
string
logoffUrlString = baseURL1 + "?command=logoff";
HttpWebRequest
req = (HttpWebRequest)WebRequest.Create(logoffUrlString);
// make the
HTTP call
HttpWebResponse
resp = (HttpWebResponse)req.GetResponse();
string
sessionID = string.Empty;
Session["SessionID"]
= null;
}
catch (Exception ex)
{
//Log exception;
}
Highlight on used
objects for Oracle CRM web service integration to update data.
1.
Data objects are suffixed with “Data”.
2.
Input objects are suffixed with “_Input”.
3.
Output objects are suffixed with “_Output”.
4.
Update Input objects are suffixed with
“Update_Input”.
5.
Update Output objects are suffixed with
“Update_Output”.
6.
Update Methods are suffixed with “Update” to
update associated entity data in Oracle CRM
So, here we have simply updated a value in Oracle CRM using
update object of respective entity (i.e. Forecast/opportunity in this example)
Please do share your thoughts and feed backs to improve. Till
than enjoy integration.
