Passing Complex Expressions via Data Flow Parameters

%3CLINGO-SUB%20id%3D%22lingo-sub-1819532%22%20slang%3D%22en-US%22%3EPassing%20Complex%20Expressions%20via%20Data%20Flow%20Parameters%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1819532%22%20slang%3D%22en-US%22%3E%3CP%3EFollowing%20the%20patterns%20set%20by%20%22%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fdata-factory%2Fformat-json%23entering-the-json-structure-manually%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3EEntering%20the%20JSON%20structure%20manually%3C%2FA%3E%22%20and%20%22%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fdata-factory%2Fparameters-data-flow%23assign-parameter-values-from-a-pipeline%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EAssign%20parameter%20values%20from%20a%20pipeline%3C%2FA%3E%22%2C%20I'm%20trying%20to%20combine%20the%20two%20without%20success.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20I%20create%20a%20parameter%2C%20and%20attempt%20to%20pass%20in%20the%20value%26nbsp%3B%3CSTRONG%3E%40(field1%3D0%3C%2FSTRONG%3E%3CSPAN%3E%3CSTRONG%3E)%3C%2FSTRONG%3E%2C%20the%20expression%20editor%20shows%20successful%20evaluation%2C%20but%20the%20parameter%20tab%20gives%20an%20error%3A%26nbsp%3B%3CSPAN%3E%3CFONT%20color%3D%22%23FF0000%22%3E%3CSTRONG%3EInvalid%20type%2C%20expected%20string%20and%20provided%20complex%3C%2FSTRONG%3E%3C%2FFONT%3E.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3E%3CSPAN%3EHowever%2C%20complex%20is%20not%20a%20valid%20type%20to%20select.%26nbsp%3B%20Any%20thoughts%20on%20a%20better%20approach%3F%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3E%3CSPAN%3EThe%20base%20data%20flow%20will%20be%20responsible%20for%20performing%20the%20%22standard%22%20mapping%20activities.%26nbsp%3B%20However%2C%20want%20to%20allow%26nbsp%3B%3C%2FSPAN%3E%3C%2FSPAN%3E%3CSPAN%3E%3CSPAN%3Ethe%20option%20to%20perform%20a%20custom%20data%20mapping%20that%20doesn't%20require%20an%20update%20to%20the%20base%20data%20flow.%26nbsp%3B%20I'm%20looking%20for%20extensibility%20via%20config%20to%20support%20the%20one-offs.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1819532%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAzure%20Data%20Factory%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMapping%20Data%20Flows%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Contributor

Following the patterns set by "Entering the JSON structure manually" and "Assign parameter values from a pipeline", I'm trying to combine the two without success.

 

If I create a parameter, and attempt to pass in the value @(field1=0), the expression editor shows successful evaluation, but the parameter tab gives an error: Invalid type, expected string and provided complex.

 

However, complex is not a valid type to select.  Any thoughts on a better approach?

 

The base data flow will be responsible for performing the "standard" mapping activities.  However, want to allow the option to perform a custom data mapping that doesn't require an update to the base data flow.  I'm looking for extensibility via config to support the one-offs.

 

 

 

 

 

0 Replies