ContributionsMost RecentMost LikesSolutionsRe: Math.absolute on array element Assuming jsonPath($, “$[‘invoice-charges’][*].total”) returns an array: jsonPath($, “$[‘invoice-charges’][*].total”).map(x => Math.abs(x)) Re: Math.absolute on array element @manohar You can use the map Array function: $array.map(x => Math.abs(x)) Re: Why does the Account connect() method return a string? @rpatrick00 The Account#connect() method returns a Generic Type, and can be used to return an authentication String, a Session or Connection object etc. to the Snap code. An example can be found in the Account Configuration section of our Developer Documentation. For a ValidateableAccount , which simply extends Account , the connect() method is called when the “Validate” button in the Account Settings UI is clicked. Your observation is correct that the return value isn’t used for Account validation, what matters is whether or not the connect() method returns successfully. The validation is considered successful if a value was returned, and validation fails if the call throws an Exception. You can find more information in the Validating Accounts section. Re: Snaps to copy data to Google Storage @anivtk You can use the File Writer Snap with the account set to either Google Service or Google Storage. The File name field would be configured like s3:///<bucketName>/<fileName> . The Google BigQuery Bulk Load (Cloud Storage) Snap is used to load data from Google Storage into Google BigQuery and isn’t suitable for the requirement described. Re: JVM monitoring/troubleshooting tool (for Linux) VisualVM is pretty good Re: How can I convert Excel File to CSV file? Yes, that should work Re: Excel Parser : reading formatted values instead of the original value @dgupta The Excel Parser Snap now has a new property “Cell formatting” starting with Snap Pack version transform7780 and is available as latest in the UAT and production environments. Setting the property to “Unformatted” should solve your issue. Re: Send a error file using the Email sender Kullay: I am getting current file but it’s getting Empty files also. We are expecting only error time only. I don’t quite understand this, some context on what you’re trying to achieve would be helpful. An empty document will result in an empty file, are there any empty documents flowing into this pipeline? Re: Send a error file using the Email sender @Kullay There’s a race condition in this pipeline design if the File Writer Snap is writing to TestingEmail.json. Since the File Writer and Email Sender Snaps are disconnected, their relative order of execution isn’t guaranteed. I would suggest connecting the File Writer’s output view to the Email Sender’s input view as shown below. Re: Excel Parser : reading formatted values instead of the original value @dgupta Reading values unformatted is not currently possible in the Excel Parser Snap. We are working on adding support for this based on your request.