viktor_n
Contributor II
Joined 5 years ago
User Profile
User Widgets
Contributions
Re: Splitting csv file into rows and then check if specified value has 10 elements
Hi @SL12345, In the sample expression that I was writing, I was working on the sample with input as a string. Below is the sample that I was using. [ { "content": "1;2566;28.3.2023;28.3.2023;10;10;15;11;1,2,3,4,5,6,7,8,9,10;Eur;Euro;USD\n2;2567;28.3.2023;28.3.2023;10;10;15;11;1,2,3,4,5,6,7;Eur;Euro;USD\n3;2566;28.3.2023;28.3.2023;10;10;15;11;1,2,3,4,5,6,7,8,9,10;Eur;Euro;USD" } ] For the expression to work, is expected the ‘content’ field on the input of the mapper with the CSV data inside as a string. Regards, Viktor N.3KViews0likes0CommentsRe: How to check The size of the response from Salesforce
Hi @vkandalam, There is a function called: snap.in.totalCount . For each id, it will return a number starting from 0(you need to add + 1 at the end) all the way to the last id. the last id will contain the number of the total IDs. You can get the last id with the snap Tail. Or you can also get the number with the Aggregate snap. Regards, Viktor N.2.2KViews4likes0CommentsRe: I am trying to perform a lookup and extend the object using the expression library
Hi @patan, The problem is occurring because you use brackets inside the function and try to access “comparator” with this keyword which not anymore refers to the root elements, but one scope above, which in this sample is the function scope. Below is an image of the scopes in your config: When you tried to access ‘comparator’ from the inside extend function, what happened in the background is that the compiler attempted to search for ‘comparator’ on the 2nd scope, In which didn’t found the element. If you want to extend the element with a different name from the specified you can use sl.zipObject function. Use this one: x.extend(sl.zipObject(["Demo"],[this.comparator[0]])) This will work because it is not created a new score. Regards, Viktor3.5KViews2likes1CommentRe: Asset updated at date (pipelines and tasks)
Hi @routemark, Maybe this can help you. Inside ‘SnapLogic Read’ snap specify the pipeline path. It will return pipeline metadata. Under snap_map is all snaps related data. You can extract a version of the snap, version is on ‘instance_version’. Each time when the snap is saved will be a new version. This is not what you asked but maybe can help you. Regards, Viktor.2.1KViews4likes0CommentsRe: Unique in multiple childs
Hi @manohar, Here is an updated pipeline. Community_2022_12_04.slp (1.7 MB) I’ve made two samples. First one is with the all other data included from the response and second one is only with order lines. See which will work for you more. If it’s still something as you not expect tell me I am here to help. Regards, Viktor2.9KViews3likes1CommentRe: I wanted to create multiple arrays from a single array based on specific Field
Hi @patan, If you have already array you can achieve this with group_by function in jsonPath. Like this: jsonPath($, "$array[*].group_by(value['ORGID'])") And here is the output: Regards, Viktor2.9KViews1like1Comment