Forum Stats

  • 3,815,220 Users
  • 2,258,979 Discussions
  • 7,893,004 Comments

Discussions

.NET - Need .NET example for invoking the HCMDataloader

3015132
3015132 Member Posts: 6
edited Dec 8, 2015 10:22AM in HCM Cloud Service

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⁄″&gt;

<soap:Body>

<ns1:importAndLoadDataAsync

xmlns:ns1=”http://xmlns.oracle.com/apps/hcm/common/dataLoader/core/dataLoaderIntegrationService/types/”&gt;

<ns1:ContentId>UCMFA001234</ns1:ContentId>

<ns1:Parameters></ns1:Parameters>

</ns1:importAndLoadDataAsync>

</soap:Body>

</soap:Envelope>

This discussion has been closed.