02-21-2023
09:44 AM
- last edited
a month ago
by
JackLacava
Hello Everyone,
We have been using ExecuteFileHarvestBatch to automate our Data Loads. However I could not make it work for Direct Load profiles.
Is anyone aware if we have api support to automate Direct Loads?
Solved! Go to Solution.
02-22-2023 10:04 AM
Apologies.
BRApi.Utilities.ExecuteFileHarvestBatch works for Direct Load as well. The issue was due to a different piece of code that tried to clear stage data for Direct Load Workflow Profile.
Thanks!
02-21-2023 01:33 PM
I always try not to use the batch harvester. I've always used the import process API calls to do it. Look at https://community.onestreamsoftware.com/t5/Workflow-and-Data-Integration/Automating-WF-Execution/m-p...
02-21-2023 02:37 PM
Any specific reason to stay away from the batch harvester?
02-21-2023 02:39 PM
Earlier, the files and folders created by the batch harvester cannot be deleted. I guess there is some utility I saw during Wave that can do it. Then there is an issue with file locks and it will not work when there are file locks.
02-21-2023 02:39 PM
Oh, and the other one, only someone with old FDM knowledge can understand what the file even means.
02-22-2023 12:07 AM - edited 02-22-2023 12:13 AM
Thanks for taking the time to respond.
I am indeed searching for Direct Load process API but could not see anything around Direct Load WFP within api viewer,
Do let me know if I am missing something.
Thanks,
Hiren
02-22-2023 03:24 PM
If you look in the link to the other post, this call:
Dim ImportInfo As LoadTransformProcessInfo = BRApi.Import.Process.ExecuteParseAndTransform(si, wFClusterPk, "", Nothing, TransformLoadMethodTypes.Replace, SourceDataOriginTypes.FromDirectConnection, False)
references to use the ".FromDirectConnection" which I believe is the one you're looking for
02-22-2023 11:37 PM
Thanks Frank, let me try that one!
02-22-2023 10:04 AM
Apologies.
BRApi.Utilities.ExecuteFileHarvestBatch works for Direct Load as well. The issue was due to a different piece of code that tried to clear stage data for Direct Load Workflow Profile.
Thanks!