Introduction:
This blog has the SOAP Webservice details that can be used to update the customer contact email address as inactive in Oracle Cloud application.
Cause of the issue:
Business wants to inactive incorrect customer contact email addresses for multiple customer accounts in Oracle Cloud Application.
How do we solve:
We have created payload to update the customer contact email address as inactive and payload will read the data from csv file and update the same.
Service WSDL URL: https:/crmService/FoundationPartiesPersonService?WSDL
Method: POST
Sample Request Body:
<soapenv:Envelope xmlns:soapenv=”http://schemas.xmlsoap.org/soap/envelope/” xmlns:typ=”http://xmlns.oracle.com/apps/cdm/foundation/parties/personService/applicationModule/types/” xmlns:per=”http://xmlns.oracle.com/apps/cdm/foundation/parties/personService/” xmlns:par=”http://xmlns.oracle.com/apps/cdm/foundation/parties/partyService/” xmlns:sour=”http://xmlns.oracle.com/apps/cdm/foundation/parties/flex/sourceSystemRef/” xmlns:con=”http://xmlns.oracle.com/apps/cdm/foundation/parties/contactPointService/” xmlns:con1=”http://xmlns.oracle.com/apps/cdm/foundation/parties/flex/contactPoint/” xmlns:par1=”http://xmlns.oracle.com/apps/cdm/foundation/parties/flex/partySite/” xmlns:per1=”http://xmlns.oracle.com/apps/cdm/foundation/parties/flex/person/” xmlns:rel=”http://xmlns.oracle.com/apps/cdm/foundation/parties/relationshipService/” xmlns:org=”http://xmlns.oracle.com/apps/cdm/foundation/parties/flex/orgContact/” xmlns:rel1=”http://xmlns.oracle.com/apps/cdm/foundation/parties/flex/relationship/”>
<soapenv:Header/>
<soapenv:Body>
<typ:updatePerson>
<typ:personParty>
<per:PartyId>{{CONT_PARTY_ID}}</per:PartyId>
<per:Email>
<con:ContactPointId>{{CONTACT_POINT_ID}}</con:ContactPointId>
<con:ContactPointType>{{CONTACT_POINT_TYPE}}</con:ContactPointType>
<con:OwnerTableName>{{OWNER_TABLE_NAME}}</con:OwnerTableName>
<con:Status>{{STATUS}}</con:Status>
</per:Email>
</typ:personParty>
</typ:updatePerson>
</soapenv:Body>
</soapenv:Envelope>
SOAP Response:
The response will have the status code.
- Success code – “200 OK”
- Error code – anything other than 200 OK