ContributionsMost RecentMost LikesSolutionsRe: Extract object from array perfect! exactly what i needed. Extract object from array I’ve got an array with one object in it, similar to this: [ { “property” : “value” } ] I’d like to remove it from the array and be left with an object: { “property” : “value” } I’ve been playing with the mapper root, but I can’t find a syntax that will do this. Should I be using a different Snap? SolvedRe: Designing a pipe to prevent a commit if any record fails Thanks Rich, This seems like a reasonable approach. Without a two phase commit, a complete solution may not be feasible. There would still be some (small) chance that the validation in the pipeline doesn’t catch all the possible errors that the application could generate. I don’t think this is a limitation of the integration platform. This problem is just a tough nut to crack. Designing a pipe to prevent a commit if any record fails I’m processing a CSV file and writing the file to an application. This part is simple mapping. However, if one of the records fails (possibly from validations in the application, possibly the last record in the file), none of the records should be written to the application. Is that kind of error handling even possible? Re: Convert array to object or perhaps the structure snap? Re: Convert array to object have you tried a mapper with javascript such as outlined here: stackoverflow.com Convert Array to Object javascript, arrays, object asked by David Hellsing on 02:22PM - 18 Nov 10 UTC Re: How to get Running Totals I have not tried it, but is it possible to set a pipeline parameter to zero and then using a mapper to increment the value? Pipeline parameters are discussed here: https://docs-snaplogic.atlassian.net/wiki/spaces/SD/pages/1438254/Pipeline+Properties Re: Debugging Reltio As close as I can think is looking at the output of the mapper. once you have validated your pipeline, you see the data pretty well. This is before execution. My troubleshooting routine includes using a head snap to limit the amount of data processed. You can make this one row. That way if the pipeline doens’t do what you want, it’s very easy to correct in your reltio environment. HTH Re: Debugging Reltio Hi, My experience has been that if you use an error branch in your pipeline, and write it to a text file, you see exactly the JSON sent to Reltio. Are you not seeing that? Re: Transforming denormalized data to a single message Wow! You are quite the mapping expert! i saw the jsonPath.map method, but couldn’t really figure it out. would you indulge me with an explanation of the x=> part of the expression?