Skip to Main Content

E-Business Suite

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

how to use Import Management web service in CX Sales

Alessandro Affinito-OracleMar 19 2020 — edited Mar 19 2020

Hi,

Im' trying to use the new feature of Import Management from remote.

The only way I found right now is an old generic SOAP web service: https://xxxxxx.oraclecloud.com/idcws/GenericSoapPort?wsdl

Here some docs:

- Transition from File-Based Data Import and Export to Import and Export Management [https://docs.oracle.com/en/cloud/saas/sales/20a/oafdi/transition-from-file-based-data-import-and-export-to-import-and-ex… ]

- HCM docs: https://docs.oracle.com/en/solutions/load-data-into-hcm-cloud/use-native-java-apis-upload-hcm-data-loader-zip-files-hcm-…

- HCM blog: https://blogs.oracle.com/fusionhcmcoe/oracle-hcm-cloud-introduction-to-ucm-webcenter-content-server

The problem is I cant' find any documentation on how to populate these fields.

1. UPLOAD

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:ucm="http://www.oracle.com/UCM">
    <soapenv:Header>     
    </soapenv:Header>
    <soapenv:Body>
       <ucm:GenericRequest webKey="cs">
          <ucm:Service IdcService="CHECKIN_UNIVERSAL">
             <ucm:Document>
                <ucm:Field name="dDocTitle">TEST_WS</ucm:Field>
                <ucm:Field name="dDocType">Document</ucm:Field>
                <ucm:Field name="dSecurityGroup">FAFusionImportExport</ucm:Field>
                <ucm:Field name="dDocName">TEST</ucm:Field>
                <ucm:Field name="dDocAccount">????????????????</ucm:Field>
                <ucm:File href="TEST_WS" name="primaryFile">                 
                                 <ucm:Contents>______________base64_______________==</ucm:Contents>
                </ucm:File>
             </ucm:Document>
          </ucm:Service>
       </ucm:GenericRequest>
    </soapenv:Body>
</soapenv:Envelope>
--------------------------------------

Inside dDocAccount I think is needed some value as

crm$/partnerContact$/import$,

crm$/contact$/import$,

.. but I dont' know where to find this mapping between the object sent and this string.


2. JOB START

https://docs.oracle.com/en/cloud/saas/sales/20a/faaps/op-crmrestapi-resources-11.13.18.05-importactivities-post.html

POST /crmRestApi/resources/latest/importActivities
Host: https://xxxxx.oraclecloud.com
{
       "Name": "TEST",
       "ImportMapping": "??????????????",
       "Activate": "YES",
       "DataFiles" : [{
                    "InputFileContentId": "204069"
                     }]
}

Any insight?

Thanks

Comments
Post Details
Added on Mar 19 2020
0 comments
410 views