Thursday, 28 January 2021

Oracle Fusion CRM - Custom Object - Get Entity - SOAP Envelop - Request and Response Sample payload

 --CRM Custom Object WSDL Link--

https://servername/crmService/CustomReferenceService?WSDL


---SOAP Request: GetEntity--

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:typ="http://xmlns.oracle.com/apps/custom/extnService/types/">
   <soapenv:Header/>
   <soapenv:Body>
      <typ:getEntity>
         <typ:keyValue>300000012023030</typ:keyValue>
         <typ:objectName>Test_c</typ:objectName>
      </typ:getEntity>
   </soapenv:Body>
</soapenv:Envelope>

--SOAP Response---

<env:Envelope xmlns:env="http://schemas.xmlsoap.org/soap/envelope/" xmlns:wsa="http://www.w3.org/2005/08/addressing" xmlns:typ="http://xmlns.oracle.com/apps/custom/extnService/types/">
   <env:Header>
      <wsa:Action>http://xmlns.oracle.com/apps/custom/extnService//CustomReferenceService/getEntityResponse</wsa:Action>
      <wsa:MessageID>urn:uuid:b99bd5b1-a063-4940-9cfe-d6eaba266779</wsa:MessageID>
   </env:Header>
   <env:Body>
      <ns0:getEntityResponse xmlns:ns0="http://xmlns.oracle.com/apps/custom/extnService/types/">
         <ns2:result xsi:type="ns1:Test_c" xmlns:ns2="http://xmlns.oracle.com/apps/custom/extnService/types/" xmlns:ns1="http://xmlns.oracle.com/apps/custom" xmlns:ns0="http://xmlns.oracle.com/adf/svc/types/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
            <ns1:Id>300000012023030</ns1:Id>
            <ns1:RecordName>754</ns1:RecordName>
            <ns1:CreatedBy>test.scm</ns1:CreatedBy>
            <ns1:CreationDate>2021-01-18T06:33:54.851Z</ns1:CreationDate>
            <ns1:LastUpdatedBy>test.scm</ns1:LastUpdatedBy>
            <ns1:LastUpdateDate>2021-01-18T06:34:09.485Z</ns1:LastUpdateDate>
            <ns1:ObjectVersionNumber>1</ns1:ObjectVersionNumber>
            <ns1:RecordNumber>2005</ns1:RecordNumber>
            <ns1:LastUpdateLogin xsi:nil="true"/>
            <ns1:UserLastUpdateDate xsi:nil="true"/>
            <ns1:CurrencyCode>USD</ns1:CurrencyCode>
            <ns1:CurcyConvRateType>Corporate</ns1:CurcyConvRateType>
            <ns1:CorpCurrencyCode>USD</ns1:CorpCurrencyCode>
            <ns1:OraZcxOwner_Id_c>-1</ns1:OraZcxOwner_Id_c>
            <ns1:OraZcxOwner_c>-1</ns1:OraZcxOwner_c>
            <ns1:Name_c>Test123</ns1:Name_c>
            <ns1:SelectedRow xsi:nil="true"/>
         </ns2:result>
      </ns0:getEntityResponse>
   </env:Body>
</env:Envelope>

Oracle Fusion CRM - Custom Object - Find Entity - SOAP Envelop - Request and Response Sample payload

 --CRM Custom Object WSDL Link--

https://servername/crmService/CustomReferenceService?WSDL


--Find Entity--SOAP Request

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:typ="http://xmlns.oracle.com/apps/custom/extnService/types/" xmlns:typ1="http://xmlns.oracle.com/adf/svc/types/">
   <soapenv:Header/>
   <soapenv:Body>
      <typ:findEntity>
         <typ:findCriteria>
            <typ1:fetchStart>0</typ1:fetchStart>
            <typ1:fetchSize>500</typ1:fetchSize>
         </typ:findCriteria>
         <typ:findControl>
            <typ1:retrieveAllTranslations>false</typ1:retrieveAllTranslations>
         </typ:findControl>
         <typ:objectName>Test_c</typ:objectName>
      </typ:findEntity>
   </soapenv:Body>
</soapenv:Envelope>


--SOAP Response

<env:Envelope xmlns:env="http://schemas.xmlsoap.org/soap/envelope/" xmlns:wsa="http://www.w3.org/2005/08/addressing" xmlns:typ="http://xmlns.oracle.com/apps/custom/extnService/types/">
   <env:Header>
      <wsa:Action>http://xmlns.oracle.com/apps/custom/extnService//CustomReferenceService/findEntityResponse</wsa:Action>
      <wsa:MessageID>urn:uuid:0607830a-c1b5-42a4-aa70-e849b2860957</wsa:MessageID>
   </env:Header>
   <env:Body>
      <ns0:findEntityResponse xmlns:ns0="http://xmlns.oracle.com/apps/custom/extnService/types/">
         <ns2:result xsi:type="ns1:Test_c" xmlns:ns2="http://xmlns.oracle.com/apps/custom/extnService/types/" xmlns:ns1="http://xmlns.oracle.com/apps/custom" xmlns:ns0="http://xmlns.oracle.com/adf/svc/types/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
            <ns1:Id>300000012023030</ns1:Id>
            <ns1:RecordName>754</ns1:RecordName>
            <ns1:CreatedBy>test.scm</ns1:CreatedBy>
            <ns1:CreationDate>2021-01-18T06:33:54.851Z</ns1:CreationDate>
            <ns1:LastUpdatedBy>test.scm</ns1:LastUpdatedBy>
            <ns1:LastUpdateDate>2021-01-18T06:34:09.485Z</ns1:LastUpdateDate>
            <ns1:ObjectVersionNumber>1</ns1:ObjectVersionNumber>
            <ns1:RecordNumber>2005</ns1:RecordNumber>
            <ns1:LastUpdateLogin xsi:nil="true"/>
            <ns1:UserLastUpdateDate xsi:nil="true"/>
            <ns1:CurrencyCode>USD</ns1:CurrencyCode>
            <ns1:CurcyConvRateType>Corporate</ns1:CurcyConvRateType>
            <ns1:CorpCurrencyCode>USD</ns1:CorpCurrencyCode>
            <ns1:OraZcxOwner_Id_c>-1</ns1:OraZcxOwner_Id_c>
            <ns1:OraZcxOwner_c>-1</ns1:OraZcxOwner_c>
            <ns1:Name_c>Test123</ns1:Name_c>
            <ns1:SelectedRow xsi:nil="true"/>
         </ns2:result>
      </ns0:findEntityResponse>
   </env:Body>
</env:Envelope>



Oracle Fusion CRM - Custom Object - Create Entity - SOAP Envelop - Request and Response Sample payload

 --CRM Custom Object WSDL Link--

https://servername/crmService/CustomReferenceService?WSDL


--CreateEntity: SOAP Request--

<env:Envelope xmlns:env="http://schemas.xmlsoap.org/soap/envelope/" xmlns:ns2="http://xmlns.oracle.com/apps/custom/extnService/types/" xmlns:ns1="http://xmlns.oracle.com/apps/custom">
   <env:Body>
      <ns2:createEntity>
         <ns2:object xsi:type="ns1:Test_c" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
            <ns1:RecordName>Test3</ns1:RecordName>
            <ns1:Name_c>Test3</ns1:Name_c>
         </ns2:object>
         <ns2:objectName>Test_c</ns2:objectName>
      </ns2:createEntity>
   </env:Body>
</env:Envelope>


--SOAP Response---

<env:Envelope xmlns:env="http://schemas.xmlsoap.org/soap/envelope/" xmlns:wsa="http://www.w3.org/2005/08/addressing" xmlns:typ="http://xmlns.oracle.com/apps/custom/extnService/types/">
   <env:Header>
      <wsa:Action>http://xmlns.oracle.com/apps/custom/extnService//CustomReferenceService/createEntityResponse</wsa:Action>
      <wsa:MessageID>urn:uuid:e6cec740-6908-4619-8e62-2a1093887970</wsa:MessageID>
   </env:Header>
   <env:Body>
      <ns0:createEntityResponse xmlns:ns0="http://xmlns.oracle.com/apps/custom/extnService/types/">
         <ns2:result xsi:type="ns1:Test_c" xmlns:ns2="http://xmlns.oracle.com/apps/custom/extnService/types/" xmlns:ns1="http://xmlns.oracle.com/apps/custom" xmlns:ns0="http://xmlns.oracle.com/adf/svc/types/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
            <ns1:Id>300000012171956</ns1:Id>
            <ns1:RecordName>Test3</ns1:RecordName>
            <ns1:CreatedBy>test.scm</ns1:CreatedBy>
            <ns1:CreationDate>2021-01-28T09:34:30.0Z</ns1:CreationDate>
            <ns1:LastUpdatedBy>test.scm</ns1:LastUpdatedBy>
            <ns1:LastUpdateDate>2021-01-28T09:34:32.827Z</ns1:LastUpdateDate>
            <ns1:ObjectVersionNumber>1</ns1:ObjectVersionNumber>
            <ns1:RecordNumber>3013</ns1:RecordNumber>
            <ns1:LastUpdateLogin xsi:nil="true"/>
            <ns1:UserLastUpdateDate xsi:nil="true"/>
            <ns1:CurrencyCode>USD</ns1:CurrencyCode>
            <ns1:CurcyConvRateType>Corporate</ns1:CurcyConvRateType>
            <ns1:CorpCurrencyCode>USD</ns1:CorpCurrencyCode>
            <ns1:OraZcxOwner_Id_c>-1</ns1:OraZcxOwner_Id_c>
            <ns1:OraZcxOwner_c>-1</ns1:OraZcxOwner_c>
            <ns1:Name_c>Test3</ns1:Name_c>
            <ns1:SelectedRow xsi:nil="true"/>
         </ns2:result>
      </ns0:createEntityResponse>
   </env:Body>
</env:Envelope>