vcocco
New Contributor II
Joined 8 years ago
User Profile
User Widgets
Contributions
Re: Some json strings questions
Hi all, I’m relatively new to JSON. For the example data that Richard provides can someone tell me what the proper syntax is to use in the JSON Generator snap? From the JSON Generator snap I’ve tried to Import the json data and I’m getting errors. One of the errors I’m seeing is 'Verify that the table values and the template are correct". Thanks, Vin3.4KViews0likes0CommentsNeed to open up a date parameter
I need to temporarily modify a date parameter in a REST Get snap. The parameter ‘date_added’ uses the previous date: date_added = Date.parse(Date.now().minusDays(1)) I need to change it to include the range August 1st to previous date. So, I’m thinking of something like this: 2021-08-01 - Date.parse(Date.now().minusDays(1)). Can someone offer some examples on how I would code this? I’m not very familiar with the language in SnapLogic. Thanks!Looking for some examples to advance date parameter by x days
Hi all, I currently run an integration manually by keying in a date as a query parameter, then running it again, manually every two weeks (every 14 days). I’m looking for some example code that would enable me to automate this process. I think I would probably have to run the pipeline manually the first time on the given date, then change the code to use something like ‘current_date + 14’. Does this make sense? Here’s how date parameters is currently setup:3.1KViews0likes3CommentsRe: Multi-file read / multi-file write
Thank you very much for that expression. I’ve made a lot of progress with the pipeline and the information you’ve given me. I would like to put that entire file name 'BERKWORK.PSOURCE.HRCNFRM.*." + Date.new().toLocalDateString({“format”:“yyyMMdd”}" into a variable or some other temporary holding area. In the pipeline, I would like to (probably?) use a Boolean expression to check for the existence of the file and send out an email (via the Send Email Snap) based on the condition being true (‘1’). Thanks again for all your help.951Views0likes0CommentsRe: Multi-file read / multi-file write
Hello again, My integration is working: it’s going out to an sftp server and pulling in all unarchived files that start with this string: WORKFILE.PSOURCE.HRCNFRM.* This results in pulling in the same set of files multiple times. The complete file string looks something like this: BERKWORK.PSOURCE.HRCNFRM.2983249.20190108110621668 The file string has the date: 20190108 I’d like to be able to pull in a file whose date string, above, matches the current date in the form YYYYMMDD. That way I’d only be pulling in files whose ‘lookup string’ matches the current date. Could you provide a coding example? Thanks again for all you help. Vin942Views0likes2CommentsRe: Multi-file read / multi-file write
Hello Again, The ‘content-location’ code in File Write worked for me. Using the wild-card character in File Read I was able to narrow down to specific files I wanted and was able to do an ‘smb’ write to our network folder. Earlier, I tried to import your example Pipeline but got this error: I originally downloaded the .slb file but SnapLogic Import didn’t see it on my Mac. I compressed it (turned it into a zip file) and the Importer was able to see it but gave me the error message. Also: I’ve been testing out the Email Sender snap to send out an email notifying certain users that a file or files exists on the network folder. I just want to send out an email if and only if the File Reader finds files on the sftp site. Could you point me to some examples? Thanks again for your assistance, Vin3.7KViews0likes1CommentMulti-file read / multi-file write
Hi there, I have a need where I have to read multiple files from an sftp site and write all of those files (if they exist) to multiple file names. Would the binary reader fit the bill here? I’m familiar with the multi-file read and the directory browser. I can successfully use those snaps to read what’s on the remote sftp server. Right now I’m using the File Reader’s Folder/File box in Settings to do something like this: sftp://transmissions-uat.testsite.com/Outbound/Encrypted It reads all of the files in the Encrypted folder. Attached to this snap is the File Writer snap which seems to write the latest file to my file name. Is there a way to write all of the files to multiple file names? I’ve seen some mention of the Binary Router snap. Would this be the way to go? Thanks, Vin8.2KViews1like7CommentsRe: File Writing at multiple source
Hi there, I’m relatively new to SnapLogic. I have a similar need where I have to read multiple files from an sftp site and write all of those files (if they exist) to multiple file names. Would the binary reader fit the bill here? Thanks, Vin2.4KViews0likes0Comments
Groups
Higher Ed Users Group
This user group is for customers within higher education.0 Posts
