ContributionsMost RecentMost LikesSolutionsRe: Rest GET Snap - Issue with passing special character through Next URL Hi, Try with encapsulating whole URL string with encodeURIComponent() function or simply replace '>' with '%3E'. Thanks, Pero M. Re: Jdbc insert snap account as auto commit is enabled Hi, Only the current executing batch will be rolled back if the Snap fails. In another words in your case it will be inserted 120 records. You can always check the official documentation: https://docs-snaplogic.atlassian.net/wiki/spaces/SD/pages/2391441629/Generic+Database+Account BR, Pero M. Re: How to insert the NULL in place of no data in CSV input fields having no data? Hi @sathishmadavali, After CSV parser add mapper and with ternary operator check/map if the field is empty. If it is then add null if not pass the field. Example: $fieldName == “” ? null : $fieldName BR, Pero M. Ultra endpoints - Response is not returned to the caller Hello, We started to experience very strange behavior with ultra tasks. Ultra tasks are up and running, but some of the endpoints are not returning the response back, even in dashboard we can see that the requests are processes successfully. Any thoughts why this could be the case? Thanks, Pero M. Re: Money formatting Hi, If you already did your calculation you can try with: parseInt($RATE_1*100). Also check Math functions and properties. Check following links: Global Functions and Properties Math Functions and Properties Number Functions and Properties Thanks, Pero M. Re: Parent-child pipeline execute Hi, Thanks a lot, this is sufficient answer… Re: Parent-child pipeline execute Hi @tlikarish, Sorry for my bad explanation. Yes, when is the child pipeline loaded. When parent is initialized or on every input document on pipeline execute. Thanks, Pero M. Parent-child pipeline execute Hello all, I’m trying to understand one functionality for “pipeline execute”. Let say we need to have multiple executions in the child process and the pool size is 1. My question is does pipeline execute is scanning the project environment before initializing the instances(child processes) or the project environment is scanned only once when parent pipeline is initialized? Thanks, Pero M. SolvedRe: Fetching query from configuration file Hi @rashmi, Try to build to build snaplogic expression with double quotes. I think this will do the trick. But if you want to have something like configuration file then please/check the following logic: testQuery.expr (133 Bytes) in .expr file there is already prebuild expression and is expecting one parameter. I tested with mapper and this is the following output: More information on the following link: https://docs-snaplogic.atlassian.net/wiki/spaces/SD/pages/1438110/Expression+Libraries Thanks, Pero M. Re: How to make an API that exposes S3 data? Hi @Aisha, When you say S3 data you mean to read some files from s3 bucket and provide that data to the person who is invoking the API correct? If that is the case than this should be simple pipeline. Example: Read JSON file, parse, and provide XML response File name you can pass from pipeline parameters to S3 File Reader. Also you can modify your pipeline depending your use case (transform, filter etc.) Thanks, Pero M.