The purpose of this request is to ask the community if anyone has invoked the "/hcmCommonDataLoader/HCMDataLoader" service from .NET. (any framework; prefer c#)
I have been tasked by my company to set up an automated process for data integration between our ADP HR system and the HCM application tables.
The integration will consist of two steps:
Step 1
Load data file from ADP to WCC; will use the "WebCenter Content Document Transfer Utility for Oracle Fusion Applications" so that this can be done from the command line and hence automated.
Step 2 (using the web service)
Load from WCC to HCM tables
It is in Step 2 that I need to invoke the web service.
The SOAP message is very basic (see below):
As you can see I only need to pass in the Content ID and we are good to go ...
My concern however, is that I also need to pass in the user name and password. Has anyone done this in .NET and if so do you have an example?
SOAP Message Example
http://{Host}/hcmCommonDataLoader/HCMDataLoader
<soap:Envelope xmlns:soap=”http://schemas.xmlsoap.org/soap/envelope⁄″>
<soap:Body>
<ns1:importAndLoadDataAsync
xmlns:ns1=”http://xmlns.oracle.com/apps/hcm/common/dataLoader/core/dataLoaderIntegrationService/types/”>
<ns1:ContentId>UCMFA001234</ns1:ContentId>
<ns1:Parameters></ns1:Parameters>
</ns1:importAndLoadDataAsync>
</soap:Body>
</soap:Envelope>