dimitri_hristov
Contributor
Joined 6 years ago
User Profile
User Widgets
Contributions
Re: CSV to XML with repetitive xml nodes
Hi @deepak.shaw Could you please provide the elements’ structure of the XML file, so that we may be able to gain better insight as to which transformations and actions should be undertaken to resolve your particular use-case. Thanks, Dimitri3.4KViews1like5CommentsRe: How to stop snap execution
Hi @kokimura, Perhaps you could use the object.hasPath(field) function to check for the existence of a field in a Filter Snap, in order to stop the invalid documents from propagating further down the pipeline and cause errors in the downstream snaps. BR, Dimitri2.6KViews3likes0CommentsRe: Dynamic DB Account Use Cases
Hi @CKARKHANIS, One approach would be to create an expression library, and then include that expr. lib. in the pipelines where you’d want to use it. In the expr. lib. you’d need to define, say, the name and location of the account for the Oracle Snaps. Then you can use that in the Account reference property of the Snaps. The setting up and usage of expression libraries is covered here. BR, Dimitri2KViews3likes0CommentsRe: How to append filename with element from json?
Hi @2020, To be fair, I tested the solution in my previous response by writing to sldb. So I see now that the path in the File Name property in my response won’t work, because the format differs from the one in the example in the File Writer documentation. I don’t have access to the Groundplex of the organization I used to test my answer. So I can’t test by writing the file that way. As for the SMB protocol, I do use it in my work, but the path I use has a valid URL of a company server. My guess is, when you are trying to write to the file system on the Groundplex, perhaps you lack permissions, or you maybe even have a stray quote sign in your path. I’m sorry I can’t be of more help. BR, Dimitri2.3KViews3likes1CommentRe: Array functions
Hi @rajendraj, If you’re having trouble writing the $content.uris array, posted in the original question, then you could try one of two things. First, try and join the array elements in a string, like so $content.uris.join(“separator_of_your_choice”). Then if you’re using SnapLogic to read the data from the database, in order to transform the string data into an array, you’d try stringData.split(“separator_of_your_choice”). Second, you could try and stringify the array, like so: JSON.stringify($content.uris). To transform the data from the DB, you’d go with JSON.parse($stringifiedJSONArray). BR, Dimitri3.3KViews2likes0CommentsRe: Array functions
Hi @rajendraj, You could try and put this expression in a Mapper Snap: ($content.uris.length > 1) ? $content.uris.filter((item1, pos1, a1)=>(pos1 != 0)) : $content.uris and assign it to the $content.uris Target Path. Have the Pass Through option checked. Hope this helps. BR, Dimitri3.3KViews1like2Comments