Charles
New Contributor II
Joined 4 years ago
User Profile
User Widgets
Contributions
Re: Null Safe access option for object value reference in JSON Generator snap?
@del, really appreciate the working example, thank you! Like you mention, I don’t think VTL outweighs putting in a mapper snap, but really glad to learn about VTL as a tool for potential future solutions. I guess I’ll have to read up on that a bit. Thank you for the start!732Views0likes0CommentsRe: Null Safe access option for object value reference in JSON Generator snap?
Hi @viktor_n, I’m now pretty certain that expressions don’t work in the JSON Generator snap at all (regardless of square brackets or colons). Posting to see if anyone can confirm, but I think the snap only takes pure JSON and a direct variable reference. It’s just a shame that it’s not null safe, so it requires another mapper snap before it. The basic pipeline below highlights the issue, that no expressions, like “$.get()” are allowed in the snap. JSON Generator Expression Test_2021_12_06.slp (4.7 KB) Thanks, Charles3.8KViews0likes0CommentsRe: Null Safe access option for object value reference in JSON Generator snap?
Thanks for the reply @bojanvelevski. I think the issue may be that expressions are not allowed in the JSON Generator snap? The solution to my problem is easy enough, I’ll just put a mapper snap before my JSON Generator snap and use the “null-safe access” option to fill in the blanks where needed, but I am surprised this isn’t an option in the JSON Generator snap, and I’m also not sure if any expressions are allowed. See the very basic chain-JSON Generator pipeline that demonstrates the problem. I can’t reference the input object with an $.get(“num”) expression. JSON Generator Expression Test_2021_12_06.slp (4.7 KB)4.3KViews0likes5CommentsNull Safe access option for object value reference in JSON Generator snap?
Hi, I’m trying to reference a value from the input object in the JSON Generator snap. The property is optional in the upstream snaps. If I straight reference it, I’ll get an “Invalid JSON-Path field not found” error. Is there a similar way to the use “null-safe access” option like in the mapper snap in the JSON Generator snap? Is there a way to use the $.get() method in the JSON Generator snap? I keep getting syntax errors. Below is my property reference: $['wd:Project_Data']['wd:End_Date'] This fails: $['wd:Project_Data'].get("wd:End_Date") $['wd:Project_Data'].get(['wd:End_Date']) $.get(['wd:Project_Data']['wd:End_Date'])Solved9.6KViews0likes10CommentsRe: Extract transaction sets from text data
Hi @aaronb , I’m not sure how this is coming in or what downstream processing you’re doing, but could you utilize the $string.split() function if the input will always be this standard? For example, if your text is the $content of a JSON response, you could use the mapper to go from $content.split(‘ST810’) to $data And then you would have an array in $data that you could iterate through/process together downstream. Charles2.5KViews0likes2Comments