ContributionsMost RecentMost LikesSolutionsRe: Issues Migrating from REST POST Snap to HTTP Client Snap for SharePoint Upload Hi mzagar , If you are reworking the flows, why don't you use https://docs-snaplogic.atlassian.net/wiki/spaces/SD/pages/1151729711/SharePoint+Online+-+Upload+File Re: Conditional Snap Run HI salishrodinger , You can create a child pipeline in order to write the files into the external stage. After all files are processed successfully, you can continue with the process. Re: How to fetch value from array? Hi @Manigandan , You can use the Filter snap to filter out only active objects. Please take a look at the attached pipeline. 00_Fetch_Active_2023_07_16.slp (4.6 KB) Best regards, Marjan Re: Converting UST date and time to IST date and time Hi @FatemaShakir , You can try the following expression: Date.parse(Date.now()).toLocaleDateTimeString({"timeZone":"Asia/Kolkata", "format":"yyyy-MM-dd HH:mm"}) It converts current datetime in IST timezone. Also, you can take a look at this documentation about Date Functions and Properties in SnapLogic. These are the Supported Timezones in SnapLogic. BR, Marjan Re: Filter files from directory for a certain period Hi @Igor_Bozhinovski , You can use the Directory Browser snap. After the snap, use a Filter. With that, you can filter the files that have “create date” bigger than date or between some date range. After the filter, you can use File Reader with the path provided by the Directory Browser snap. Let me know if this helps you. BR, Marjan Re: How to create new array if there are more than 100 elements in the array Hi Igor, Then maybe Group by fields snap is the one you are looking for? You can choose by which object to group by. Let me know if this helps you. BR, Marjan Re: How to create new array if there are more than 100 elements in the array Hi @Igor_Bozhinovski , You can take a look at Group By N snap, I think it will help you with this issue. You can set Group Size to 100 and you will have two groups as output. BR, Marjan Re: Writing multiple data in a single excel file sheet Hi @Harsha3 , I think that the Excel Multi Sheet Formatter can help you with this. input0 and input1 are data from different sources. Let me know if this helps you. BR, Marjan Re: Validating Child pipelines Hi @jason.steindorf , You can use the Record replay snap. You need to put that snap in the child pipeline as input snap. After that, you need to validate the parent pipeline. When it finishes, you can validate the child pipeline and see the data. BR, Marjan Re: To get sum of value present in between special character like '|' Hi @nirupama , You can try the following expression: $NEUTSUM.split('|').filter(x => x != "").reduce((accum, currentValue) => accum + currentValue, 0) Let me know if this helps you. BR, Marjan