Convert .xls file to .dat file and upload to HCM cloud
SummaryI am new to OIC and I have a requirement to get the .xls file from third party and convert it to .dat file format and zip the file as per HDL standard format and upload to HCM cloud.
I would need the starting point that how to import the .xls file into OIC and then convert to .dat file.
As per my understanding below approach I need to use:
- Need to create a FTP connection to download the file and then convert it to .csv file.
- using web services I need to invoke HDL process to upload the file into HCM cloud application