tonyzero
New Contributor II
Joined 5 years ago
User Profile
User Widgets
Contributions
Re: Downloading a base64 zip file using SOAP
Hi @ptaylor , I followed you suggestion and it really works. I used Base64.decodeAsBinary($content) together with application/zip → $[‘content-type’] and got the txt file in a zip. However, I am still not sure why I should use Base64.decodeAsBinary() to decode something what really looks like a base64 encoded string. Thank you very much!9.6KViews0likes2CommentsRe: Downloading a base64 zip file using SOAP
Hi @ptaylor , Thank you so much for your reply. This is what I got for my pipeline. For the first SOAP snap, this is the preview results.I believe the “content” part is what I am looking for to decode. Then just as what shown above, I connect a Filter to soap. Here is the setting for filter. Then I connect it with a mapper to decode it following Bojan’s suggestion. Then the preview results still looks weird to me. Then I connect it with a File Writer (but not sure what format I should write to). This is what I got so far. I know there must be something wrong with it but could not figure it out. Thank you so much for helping me on this.4.9KViews0likes4CommentsRe: Downloading a base64 zip file using SOAP
Hi @bojanvelevski Thank you so much for your reply. I followed your instruction but still did not get the results I needed. I am kind new to this so please bear with me if I have some “silly” questions. So the WSDL service that I am using says “Downloads the ESS job output and the logs as a zip file.” So I am assuming that whatever decoded from the “$content” should be a zip file. And for the mapper, this is what I have for now. Not quite sure if this is correct. For File Writer, I tried test.zip or test.txt but neither works. If I output this file as zip, the I got the following error. If I output this as test.txt, then I got all these unknown characters with my file name in it. I am really confused on how to process with this procedure. Could you please guide me on that again. So much appreciated!4.9KViews0likes6CommentsDownloading a base64 zip file using SOAP
Hi All, I am trying to use SOAP call to download a zip file. However, I cannot download and get the file I need correctly. Here is a screenshot of my pipeline. I took out the $content, which contains a string that is (at least looks like) base64 encoded data. The “Content-Type” is null and “Content-Transfer-Encoding” is “binary”. Then no matter how I decode this string, whether by using Base64.decode() or Base64.decodeAsBinary(), I cannot get the zip file I need. If I use Base64.decode($content), I get something like I can see my file name within a bunch of words that I cannot read. And I think I should not use Base64.decodeAsBinary(). Could someone please tell me what is the correct way to download this zip? Thanks in advance!Solved11KViews0likes10CommentsWeb Services on Snaplogic to Upload file
Hi all, I am trying to upload files to my pipelines. I know I can use File Reader snap and upload my file manually over there. Is there any way or public snaplogic APIs for me to use that I can upload file with through an API call with python? Thanks!851Views0likes0CommentsRe: Dynamic DB accounts & Dynamic SQL query
@robin Another problem occurred to me while working with actual project. You mentioned in the first reply that “do note the account needs to exist already and you have the correct path to the account defined” So based on what you replied to me, whenever I run into a new account, I need to add this account to my Account References so that it is an “existing account”. Then I could connect it dynamically with parameters. Can I use the dynamic connection without “pre-setting” a new account? I mean can I create account with “Oracle Thin Dynamic Account” and parameterize Hostname, Database Name, Username and Password? If it is possible, I could call my triggered task and pass all the required info above to both creating account and execute sql at the same time? Thanks in advance759Views0likes0CommentsRe: Dynamic DB accounts & Dynamic SQL query
@robin Thank you so much! I do have a following question regarding to dynamic databases. What if I have different types of dbs (Oracle, MS-SQL etc) ? Can I use one pipeline to connect all of them? My assumption is no, because each type of snap could only work for specific type of database. Oracle snap could only work for oracle; MySQL snap could only work for MySQL etc. How about files? Can I use a pipeline to read either csv or xlsx file? I am guessing no because I tried csv parser would not work on xlsx files and vice versa.2.8KViews0likes1Comment