Enable editing of expression library file
When designing pipelines we have environment specific parameters (Dev, Test, Prod) in expression libraries. This renders our pipeline development independent of having to alter pipeline parameters or tasks between environments and deploys. However, the managing of the expression library files are a bit tedious. The file has to be downloaded, edited and uploaded again. It would be awesome to enable editing of the content of expression library file in the preview window. Example mockup: Of course having environment variables in a more accessible and standardised way would be the ideal solution, such as a new entity in SL manager, there could be an environment variables section in the projects as well as having the possibility to access shared env vars.Dynamically change the Delimiter in CSV parser
I’m designing ah pipeline that will handle multiple delimiters in a single CSV parser. I’m using a expression library that has the delimiter details of the respective files as below. [ { “src_file”: “aab”, “Delimit”: “PIPE”, “tgt_table”: “T_STG_AAB” } }, { “src_file”: “abc”, “Delimit”: “TAB”, “tgt_table”: “T_STG_ABC” } }, { “src_file”: “efg”, “Delimit”: “COMMA”, “tgt_table”: “T_STG_EFG” } } ] On the mapper snap I can write expression to refer this expression library lib.sample.find(x => x.src_file==“incoming_filename”).get(‘Delimit’). But when I try to use the same in CSV parser it doesnt accept. can we really do this.
I am trying to perform a lookup and extend the object using the expression library
I wanted to perform a extend by performing a lookup using the expression library and it is giving me “this.comparator is undefined” error. Below is my expression Library Content: { embedbusinessUnit: x => x.extend({"Demo":this.comparator[0]}), embedbusinessUnit1: x => x.merge(this.comparator[0]), "comparator": [ { "KSCHL": "EPE", "VKORG": "1000", "BusinessType": "E", "KSCHLN": "LPE", "VKORGN": "1000" }, { "KSCHL": "EP0", "VKORG": "RG", "BusinessType": "N", "KSCHLN": "LP0", "VKORGN": "1000" } ] } When I access the lib.businessUnitExpr.embedbusinessUnit($) gives me a comparator undefined error. But when I access lib.businessUnitExpr.embedbusinessUnit1($) then it is able to identify the comparator Any help would be appreciated. BusinessUnitComparator.expr (382 Bytes)
Using expression libraries in JSON Generator
Hello, I need to generate a JSON with a bunch of dynamic keys, which are stored in an expression library. I haven’t found a well rounded solution so far, except pushing it all together in a single mapper field, however i was hoping to find something more graceful and readable. So my idea was to use a JSON Generator and piece together the information, however I run into two issues: How can I access the expression libraries in a JSON Generator? How can I set the values of the expression library as element key? I’ve tried several combinations to achieve the first thing: [ { "test" : $lib.env.jiraSyncDatefield[pipe.plexPath.split('/')[1]] } ] [ { "test" : ${lib.env.jiraSyncDatefield[pipe.plexPath.split('/')[1]]} } ] Once I have this working, the question arises on how i can set these values as element keys, I hope that will be working by enclosing them in square brackets. Did anyone have a similar task in the past? EDIT: Found a simpler approach, i wasn’t aware that the expression evaluation worked in the target path: Still, it would be good to know if the described use case is possible. Best regards Thomas
Referencing snap, pipe variables from within an expression library
I’m trying to create an expression library function that needs access to both the snap and pipe variables. Can these variables be accessed directly from within the expression library function or must they be passed in as parameters? Right now my function looks like this: getHeader: (name) => match(pipe.flags.immediate_mode) { true => snap.original.load().get(name), _ => pipe.get("args",{}).get(name) } When I run this pipeline, I get the following error: {"error":"snap is undefined. Perhaps you meant: isNaN, jsonPath, JSON, String, _personsURL, parseInt","reason":null,"resolution":"Check the spelling of the variable"}
Expression Library - Environment Variable
Hi all, We are looking at building a solution for loading variables into pipelines via the expression library feature. One feature we would like to include is when loading the external library it will select the file based on the environment(ORG) that it is in. we have seen a method of doing this via the pipeline path.plexpath (Expression language) however this would involve a large query to select the path e.g.(…SLDev\Shared\Tools) Just wondering how other customers may have implemented this kind of solution in order to get environment variables. many thanks, Kiran