Forum Discussion

hiren's avatar
hiren
New Contributor III
3 years ago
Solved

Direct Load Automation

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 autom...
Admin
  • hiren's avatar
    hiren
    3 years ago

    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!

hiren's avatar
hiren
New Contributor III
3 years ago

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

  • FrankDK's avatar
    FrankDK
    Contributor
    3 years ago

    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

    • hiren's avatar
      hiren
      New Contributor III
      3 years ago

      Thanks Frank, let me try that one!