Harsha3
New Contributor III
Joined 6 years ago
User Profile
User Widgets
Contributions
Re: Dynamic passing in REST API
Hi Deepti, Actually, in my case, I passed the country Id as a parameter to the child pipeline. I prepared a sheet (excel) containing the list of countries and the corresponding country Id. I loaded the sheet in the child pipeline’s file reader. In the parent pipeline, I specified all those countries in the ‘;’ separated format, so that during each run, the countries are passed into the child pipeline one by one. Then I used the mapper and specified the REST API path. According to my use case, each time we need to change the country ID in the REST API depending on the upcoming country fed by the parent pipeline and this can be achieved using the normal mapping function.1.5KViews0likes1CommentIntegrating Snaplogic with VBA
Hi, I need to take data from 3 sources and consolidate them in the sheet post that I need to activate the VBA code which completes the work. For the first half, I employ snap to complete the task and after there are some pivoting logic needs to be handled and for that I decided to take the help of macros. Please let me know is there any way using the snap to activate the VBA code in macros enabled excel?2.2KViews0likes1CommentWriting a data under a specific column header
Good day, Is there any way available that allows the data to be written under a specific column header of our choice? To put preciosuly, we have data already present under the headers say Col1, Col2, and Col3 and I need to insert the data under Col4 alone. I identified this can not be achieved using the normal file writer snap as generally it supports overwrite as an option. Any methods to merge the data into a single sheet? Thanks, Harshavardhana1.1KViews0likes0CommentsPassing the expression as parameter
Hi Good day, Would like to check how to specify an expression statement as a parameter in the mapper. I identified specifying the expression directly in the mapper which evaluates to the boolean value depending on the evaluation but the same can not be achieved if we pass the expression as a parameter. It gets read as a string, so could not achieve the exact result. Any idea how to achieve this case? Sample Pipeline where expression is written directly in the mapper: Head Snap Test_2023_05_22.slp (3.7 KB) Sample Pipeline where expression is passed as a parameter: Head Snap Test_2023_05_22 (1).slp (3.9 KB)2.4KViews0likes2CommentsReading the Merged CSV Header and Data
Is there any way to read the merged column header and its corresponding data? Please refer to the screenshot below. Do we need to unmerge the column header to read the headers? If we unmerge how to merge back to normal using the snap without directly changing in the excel/CSV.880Views0likes0CommentsExcel Merger
Hi, Whether is there any way to merge two Excel data into one using the Snaplogic? Like A,B, C and D,E, F are headers belonging to two different excel Ex1 and Ex2. And I require a combined Excel concatenated side-ways like A,B, C,D, E,F Screenshots below: Ex1: (Excel 1) Ex2: (Excel 2) Expected Output: Thanks, Harshavardhana2.6KViews0likes2CommentsIllegal character due to | symbol
Hi Team, We are facing issues in the salesforce upsert snap while using External Id for the operation. The external Id is of the format “TH10-2023|0100044213|000086|3010” So the snap interprets the ‘|’ as logical AND and throws the error. Is there any way to prevent the issue? Shall we consider it as a whole string instead? Thanks, Harshavardhana1.8KViews0likes1Comment