andrew_wait
New Contributor
Joined 4 years ago
User Profile
User Widgets
Contributions
Re: Exporting text file with CSV formatting, but with different numbers of fields
I know I’m late to the party, but I had to do this, found this posting and then solved it this way FileWriter allows you to append, so 6 columns > CSV (no headers) > FileWriter (overwrite) 33 columns > CSV (no headers) > FileWriter (append) 6 columns > CSV (no headers) > FileWriter (append) This keeps all the CSV creation so you get the “” wrapping but allows you to build up the file as required. NOTE: FileWriter is fussy about the target location for allowing append, but if you can jump that hurdle you should be fine1.6KViews0likes0CommentsREST oauth2 authentication in Scheduled/Triggered task
Summary (new/inexperienced user) How do I configure a scheduled task/pipeline that hits a secured REST endpoint such that the oauth account required is authorized without manually intervention to allow use as a scheduled task? Background I have a pipeline that retrieves information from a REST end point. This endpoint is secured using a Snap oauth2 REST account, which has been set up in the Account tab in the pipeline This requires that “Authorize” button in the “Edit Account” window is clicked before the pipeline is executed. This works fine and information is retrieved. The pipeline needs to run as a triggered/scheduled task. This fails unless the account used is pre-authorised manually before the task is run, which is not practical. What am I missing? How do I configure the scheduled task/pipeline such that the oauth account is authorized without manually intervention to allow use as a scheduled task?2KViews0likes1CommentRe: Script snap / load configuration file
Thanks If I use a FileReader to read a file I’ll end up with the config in a document… how do I get both that configuration document AND the document that needs validated into the Script snap so the document can be validated against the configuration?3.2KViews0likes0CommentsScript snap / load configuration file
In a javascript script pack is how do I load/read a file that is available in the manager? I cant find an example showing how to read in external files inside a Script snap, or how to pass both an incoming doc and a configuration to the Script snap. Background I have a generic validation script, that is going to be a child pipeline to many parents, so need to apply different criteria to validate incoming documents differently; eg. there may be a “loose” configuration, where an email just needs to contain @ and be length >1 and <1000, or a “strict” configuration, where a complex reg exp is applied, so the generic script remains the same, but reads in and applies validation via a configuration file.4.5KViews0likes5CommentsRe: This.log.info / view after validation
Thanks for the response, even if it wasnt what I was hoping… instrumenting a script with log output for dev/debugging and having to run it and then go to the dashboard to get the logs from the status and then rinse and repeat is… clunky Suggestion: as it’s browser based write to the browser console so output is available in the browser dev tools console2.2KViews0likes0CommentsRe: Mapping in mapper from file
Sorry to resurrect an old thread, but this is exactly what I want to do, have mappings in a file that is read in (or passed) and then those mappings are used… It seems from the example that this is possible but I cant work out from the posting how to go about this, if you could expand on how to do this that would be great2.9KViews0likes0CommentsThis.log.info / view after validation
I am starting out with SnapLogic and am exploring the Script snap The script snap allows writing to a log (eg. this.log.info(“WIBBLE”)😉 I have found I can view this output via the Dashboard after script has been executed but I want to be able to view the output as I develop after validation whilst remaining in the Designer, but I cant work out where in the Designer I view/do this. I’m sure I’m missing something simple…! Thanks2.7KViews0likes2Comments