JPaps
New Contributor III
Joined 6 years ago
User Profile
User Widgets
Contributions
Snaplogic Service Account Unauthorized?
Hi, I have configured a pipeline to trigger another pipeline via triggered task. The first pipeline triggers the second one by calling a triggered task’s secured REST URL, using the REST GET snap. I have tested the REST authentication for this purpose by using my own credentials as basic authentication and found success. However, when I create a SnapLogic account and tick the “Provision this user as a service account.” checkbox, then use this account’s credentials to authenticate the REST call, I get an “Unauthorized” error. I can’t find helpful documentation for this, am I configuring this account wrongly?SolvedExecuting a Snaplogic Triggered Task via REST, From a SnapLogic Pipeline
Hi, I am designing a pipeline that needs to execute another pipeline upon it’s completion. My original intention was to use the “Pipeline Execute” snap, but this snap has a limitation wherein, it cannot execute pipelines that are stored inside another folder within the same project. It is only able to execute from “shared” and from within the same folder. Moving the desired pipelines to the same folder / shared is not an option for me because it would break some design principles of my project. I found the below text in the “Pipeline Execute” Snap Documentation: To execute a SnapLogic Pipeline that is exposed as a REST service, use the [REST Get] Snap instead. Therefore, I am seeking to satisfy my requirement by using REST Get to execute the pipeline, which I have exposed as a triggered task. How can I configure the “REST Get” Snap to pass-in parameters and execute the triggered task, using the Secured Snaplogic URL? Does this go against best-practices? NB: The pipeline that is being executed does not need to return any data to the parent pipeline.SolvedRe: Excel Parser - "Zip bomb detected!" Error
After being provided with a copy of the excel file, I have found that it contained 16376 empty columns. Although the file itself was relatively small, I suppose that this amount of columns is just too much to be parsed by Snapogic. The file was parsed successfully after getting rid of the extra empty columns.7KViews0likes0CommentsExcel Parser - "Zip bomb detected!" Error
Hi, I’m trying to parse an excel file with the “Excel Parser” snap and I’m getting the following error: Zip bomb detected! The file would exceed the max. ratio of compressed file size to the size of the expanded data. This may indicate that the file is used to inflate memory usage and thus could pose a security risk. You can adjust this limit via ZipSecureFile.setMinInflateRatio() if you need to work with files which exceed this limit. Uncompressed size: 670068, Raw/compressed size: 6656, ratio: 0.009933 Limits: MIN_INFLATE_RATIO: 0.010000, Entry: xl/styles.xml The documentation (https://docs-snaplogic.atlassian.net/wiki/spaces/SD/pages/1439019/Excel+Parser) states that this error is expected when the excel file is larger than 4GBs but the file that I am attempting to parse is 578KBs How can I fix this problem?Solved9.4KViews0likes3CommentsSnaplogic Snap Pack To Create, Update, Delete *Scheduled* Tasks
Hi, I would like to have the ability to create, update, delete Snaplogic scheduled tasks via REST API from a web application. I understand that the [Snaplogic Metadata] snap pack only allows the creation of triggered tasks? Can Snaplogic facilitate this functionality?Solved3.2KViews0likes2CommentsRe: CSV Parser Troubling Error (Cannot complete CSV data parsing)
Thanks for your response @bojanvelevski. I am trying to test and understand this sample pipeline. Can you kindly give me a high-level explanation of it? I don’t recognize the code in the mapper snap and its doing a lot as seen in the below pipeline statistic (CPU% and memory). The [Binary to Document] and [Mapper] snaps is a manual replacement for [CSV Parser] snap? Where can I find documentation for the syntax used?2.7KViews0likes1CommentCSV Parser Troubling Error (Cannot complete CSV data parsing)
Hi, I am trying to parse a CSV that is auto-generated by a legacy system. The CSV has no headers. The problem is, the system conditionally adds columns to individual records. So, the CSV sometimes has records with more columns than others. This causes Snaplogic’s CSV Parser to fail (it doesn’t parse the whole file). The parser will only parse up to the row number where the record with the additional columns is. Below is the error message: This sounds far-fetched but is there a way to automate a solution to this problem? Perhaps by being able to conditionally control the columns before the document hits the CSV Parser?3.3KViews0likes3CommentsRe: Doing a Lookup In SnapLogic? [Help]
Thanks everyone for your help. @bojanvelevski 's solution works. The issue I was facing was that the join was failing due to the ID’s in both files not matching. The output document’s ID’s, derived from the CSV files were encapsulated with quotes (") where as the excel didn’t have these. Data types were both text so for example, the join was looking to match ID: 001 with ID: “001”, this would fail. Once I sorted this issue out by doing a replaceAll() function in the join snap, the solution worked flawlessly. Thank you @ptaylor for pointing me in the right direction to check my data. In this case I triple checked it. I can’t believe that I missed that lol.1.4KViews1like2Comments