Can We create a Variable in Mapper
Hello Everyone, I am trying to create an incremental addition let say i have 2 columns empl_id and salary so in target i want to derive third column with cumulative salary. I can do it by using variable, have done it using Different tool but never implemented it in snaplogic Hence the question can we create Variable in mapper? any help is appreciated
Connect SFTP server to fetch multiple files
Hi All, I am trying to connect SFTP server and fetch multiple files from the source remote directory. File Reader snap has an option to get SFTP account but doesn’t find how to provide remote directory path. In the remote directory, we are getting different types of files like *.txt where I need to apply filters based on the filenames to differentiate and invoke the different process to load into SQL DB. Once I fetch the files from remote location how to delete the files. Appreciate your inputs and any relevant links to look into more details. Let me know if you need any further details. Thanks in advance, Amar
Sending CSV file from SFTP server to API (REST Post)
Hi fellows, I am trying to send a csv file from an sftp server to an api endpoint but I can’t make the REST POST to work, I keep getting error:400 from the api I have tried 3 different pipelines but all of them get the same error I tried 3 different ways to pass it the input: the fisrt one I format the file i get form the sftp and transform it to a document input: error: POST setting: then I tried just to read it and put it right away though the binary to document input: error: POST settings: then I tried to just write it(not in the pipline underneath) and read it from the local file store from snaplogic but didn’t work either error: POST settings: Hopefully someone will spot what I’ve been doing wrong because I’ve spent a lot of time triyng to get this right :c pd.I already tried guiding myself with these two posts I found with no success: REST Post Trying To Send a CSV File Designing Pipelines restful_post_example.docx (314.4 KB) Hello Everyone. I am brand new to SnapLogic as well as brand new to RESTful API’s so please bear with me and not make fun of me too much. :slight_smile: I attached a document to help visualize what I am trying to do. I am just trying to do a proof of concept for a project using the REST Post snap to upload a CSV file but I cant get it to work and I was wondering if someone might be able to help point me in the right direction. Thanks in advance for your ki… REST POST A File? Designing Pipelines Seems like a silly question, but I have a pipeline with a REST POST snap like below which posts a file pulled directly from the SLDB filesystem and posts it to a URL, specifying an Upload File and Upload File Key. This seems to work fine… [works] But my file won’t really be coming from the SLDB filesystem, so I want to pretend my file is coming in via prior snaps in the pipeline and reference that in the REST POST using the HTTP Entity. So instead I’m loading the file separately and then run… thank you in advance for reading.
