Get Value From Connection String
  • 09 Jan 2023
  • 1 Minute to read
  • Dark
    Light

Get Value From Connection String

  • Dark
    Light

Article summary

Step Details

Introduced in Version4.0.0
Last Modified in Version5.12.0
LocationDatabase > Connection String

The Get Value From Connection String step gains access to the connection string thanks to its key, grabs it, and exports the connection string value. When wishing to check a parameter, such as Integrated Security, this step may locate its occurrence or lack thereof within the connection string.



Properties

Inputs

PropertyDescriptionData Type
Connection StringDatabase Connection StringString
KeyThe key to get value from in the Connection StringString

Outputs

PropertyDescriptionData Type
OutputOutputs the value from the Connection StringString

Example Inputs and Outputs

Connection StringKeyOutput
Data Source=(local)\SQLEXPRESS;Port=5464;Integrated Security=False;Username=stan;Password=ketmus8!Passwordketmus8!
Data Source=(local)\SQLEXPRESS;Port=5464;Integrated Security=False;Username=stan;Password=ketmus8!
Port5464
Null ValuePortEXCEPTION MESSAGE
Empty String6EXCEPTION MESSAGE


Common Errors

Value cannot be null

If the Connection String or Key has a null or empty value, an error will occur

To correct this, ensure that the input field is configured correctly.

Exception Message:

Exception Stack Trace: DecisionsFramework.Design.Flow.ErrorRunningFlowStep: Error running step Get Value From Connection String 1[GetValueFromConnectionString] in flow [Flow 10]: Exception invoking method GetValueFromConnectionString on class ConnectionStringSteps
 ---> DecisionsFramework.LoggedException: Exception invoking method GetValueFromConnectionString on class ConnectionStringSteps
 ---> System.ArgumentNullException: Value cannot be null. (Parameter 'Get Value From Connection String: Unable to parse key Password'
 at DecisionsFramework.ServiceLayer.Services.DatabaseIntegration.FlowSteps.ConnectionStringSteps.GetValueFromConnectionString(String connectionString, String key)
   --- End of inner exception stack trace --- at DecisionsFramework.Design.Flow.StepImplementations.InvokeMethodStep.Run(StepStartData data
 at DecisionsFramework.Design.Flow.FlowStep.RunStepInternal(String flowTrackingID, String stepTrackingID, KeyValuePairDataStructure[] stepRunDataValues, AbstractFlowTrackingData trackingData
 at DecisionsFramework.Design.Flow.FlowStep.Start(String flowTrackingID, String stepTrackingID, FlowStateData data, AbstractFlowTrackingData trackingData, RunningStepData currentStepData)
   --- End of inner exception stack trace ---



Was this article helpful?