rgoerwit
New Contributor II
Joined 5 years ago
User Profile
User Widgets
Contributions
Re: REST Get delay between making calls as documents come in (not pagination or retry)
This is an ongoing point of pain, and many folks have requested the ability to loop in SL without resorting to deep recursion. There are apparently technical barriers to this. But it’s necessary. (Loop here would be: GET, examine response; if response says to wait, extract the wait time and pause, then go back to step one; otherwise, proceed.)3.4KViews1like1CommentRe: Throttle Bot or Other Loop/Delay Mechanism?
I’ve given my boss, who is our SnapLogic admin, information needed for an enhancement request. I am new to SnapLogic, so I hesitate to critique. I’d just say that every other ETL tool and every other usable scripting or coding language I’ve used implements loops. So it’s a shocker that SL doesn’t have this - or that you have to use nested pipelines. So I wholeheartedly encourage them to look into this. It’s very useful to have a visual that implements a loop and shows you, nicely, what the exit condition is and what variables/fields are getting modified as one iterates. It’s possible to use recursion (pipelines). But given that we can’t click through to child pipelines or see easily what’s getting passed to them (setup of paramaters is very clicky, on both the parent and child ends) - given all this, a loop construct is really needed. It’s also important to improve recursion and make those parameters more visible. Having to click around the parent, and the child, and having to manually ensure that everything matches, is really hard to do. And recursion is difficult for the citizen-integrators that SL targets. It’s a hard concept. If SL wants to make this easy, a simple loop will help - along with visibility improvements, as noted.826Views2likes0CommentsRe: How to implement looping logic in snaplogic?
For me SC_1_2022_01_24.slp, when supplied with a valid child pipeline and executed, results in a stack overflow - an infinite loop of some kind. It does that while prepping the pipeline. The child never actually executes as far as I can tell.2.5KViews0likes0CommentsCan Excel Formatter Insert Data at an Offset (Column or Row)?
I have a requirement, that I insert data into a series of sheets in an Excel workbook - and the sheets are not blank. Is there a way to tell the Excel formatters (would love to use the multi-sheet formatter for this) to start inserting at a particular row, or better yet, a cell? I see some folks have asked for something similar, Anyone aware on how to insert the data into excel file from a specific line number (in excel sheet)? - Designing Pipelines - SnapLogic Community If this is not possible, I am new, and I wonder: What is the best way to request this feature? It seems to come up periodically in various forms.3.4KViews0likes4Comments
Groups
Higher Ed Users Group
This user group is for customers within higher education.0 Posts
