cjhoward18
Employee
Joined 8 years ago
User Profile
User Widgets
Contributions
Re: Can an API policy be applied for a cloud-triggered task?
These APIM policies can be applied to any task running on any plex. However, you must use the snaplex url to invoke the task for these policies to be applied, which would be a call directly to your snaplex vs going to the elastic.snaplogic.com(cloud url) control plane.1.2KViews1like0CommentsRe: JSON Formatting and Merging
Assuming your input is a single document with an array of objects, rather than a stream of individual documents. With that assumption you can use a mapper with the expression: jsonPath($, "$[*].tree") and target path: tree This will collect all tree objects from every element in the array, then write that list to the target path tree1.6KViews0likes0CommentsRe: Extend Object by Dynamically Adding columns based on delimited string
fkhan060: [ { “Customer Super Key”: “CUST-XXX”, “Customer Security Segment”: “BU00172;BU00173;BU00174;BU00176;BU00175” } ] Hi, Using this expression in a Mapper snap: $['Customer Security Segment'].split(";").reduce((accum, curVal, index) => accum.extend({[$['Customer Super Key'] + (index + 1)]: curVal }), {}) You can create the object you are looking for from the input given.3.1KViews0likes1CommentRe: Parsing a string into 2 columns
You can use this expression given above to get the primary email: $email.split(',')[0] And this expression to extract the secondary emails after the primary: $email.substr($email.indexOf(',') + 1) keep in mind if there is no secondary email/comma in the given $email string the primary and secondary emails will be the same email.4.2KViews0likes0CommentsRe: Split String by appending a new value after every 3 characters from the end
Using a mapper and assuming your input text is at the key $text you can use the following expression to achieve your goal: $text.split("").reverse().reduce((accum, cur) => (accum.length - accum.split("+").length +1) % 3 == 0 ? accum + "+" + cur: accum + cur).split("").reverse().join("")3KViews3likes1CommentRe: How to remove columns with null value alone in pipeline?
You can use this expression: { filterEmptyKeys: (value, key) => value != null, cleanupTree: value => value instanceof Object ? value.mapValues(this.cleanupTree).filter(this.filterEmptyKeys) : value }.cleanupTree($) mapped to the target path $ to remove all null values from a nested JSON object3.9KViews1like0CommentsRe: How to remove columns with null value alone in pipeline?
@amardeep2021 Hi, You can achieve this by using a mapper snap with the following expression: $.filter(value => value != null) mapped to the target path $ this will filter all values out that equal null, keeping only the key-value pairs in which the value is not null. Keep in mind this will only work for 1 level of nesting as I noticed your data was. If it does need to work with nested JSON fields it would be a different expression that I can provide you with as well if needed.3.9KViews1like0Comments