mtran21
New Contributor III
Joined 6 years ago
User Profile
User Widgets
Contributions
Re: Using Zip Writer snap without file structure
@j.angelevski So I did tried this and it looks like it zipped all the files together in 1 zip file. Is there a way to have each input file its own zip file? For example, my input are test1.txt and test2.txt. I like to be able to produce 2 zip files. test1.zip and test2.zip. Thanks3.3KViews0likes0CommentsUsing Zip Writer snap without file structure
I am trying to use a Zip Writer snap zip a .txt file to become .zip file. So if my txt file location is /intshare/test/watermarkout//test.txt, when I zip it, the folder structure comes with the zip. Here is my snap and when I unzip it, it has folder structure How do I not include the folder structure with the zip file? I just want file test.txt in the root of the zip. Thanks4.1KViews0likes4CommentsRe: Looking for sample API pipeline
Hi @marija.nikolovska Thank you for your help. I actually was looking for way to create my own API. My mistake was not explaining more detail from beginning. Let’s say I have a database (SQL or Oracle) with a table that has Customer data. I want to use SnapLogic to build an API pipeline so that I can hand the API URL to web developers, so that they can use my API URL to GET the data from the database, or Post to the database, etc. I hope that makes sense. Thanks again for your help.3.3KViews0likes1CommentRe: How to write an empty CSV file
I am coming back here to share my simple solution how to write an empty CSV file when there is no data in the stream source (SQL or Oracle) First, you need to do a COUNT query from your database. Then add a router, if COUNT is not equal zero, then do your thing, if COUNT is zero, then add a file Reader to read your empty CSV file that you put in your file directory, then write the file to your destination So here is my entire pipeline Then first snap is count Then Router Snap Then File Reader to read my empty CSV file with headers Then finally, write that empty CSV file to destination Hope that helps3.4KViews2likes0Comments
Groups
Higher Ed Users Group
This user group is for customers within higher education.0 Posts
