The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.

Forum Discussion

Nelly's avatar
Nelly
New Contributor
3 years ago

Change Load method through connector code

Hello everyone! Quick question. Does anybody know how to change the Load Method for a ProcessDataTable through the connector code? We have a dashboard where the user wants to choose the Load Method w...
Data Integration
Workflow
RobbSalzmann's avatar
RobbSalzmann
Valued Contributor II
3 years ago

Your code here is hard-coded to set the load method to TransformLoadMethodTypes.Append on line 42.
Your Radio Button Group is tied to a Bound Parameter.  This is what is being updated by the user's selection.  Base your decision logic on that parameter, set the api.LoadMethod to the appropriate TransformLoadMethodTypes value.

Something like this:

Dim strLoadMethod as String = BRApi.Dashboards.Parameters.GetLiteralParameterValue(si, False, args.PrimaryDashboard.WorkspaceID, "TestParameter")

api.LoadMethod = TransformLoadMethodTypes.Append
If(strLoadMethod.Equals("Replace"))Then
	api.LoadMethod = TransformLoadMethodTypes.Replace
EndIf