Designing and Running Pipelines

Dynamic Table Loads

Trying to do ETL to move source data to target db. I don’t want to create a pipeline for every single table. There are hundreds of tables. To start I want it to do this simply and assume a truncate and reload of all the tables. I will worry about ...

Excel Parser - reading dd/mm/yyyy format

I am reading a list of Dates in excel. Excel region settings are Australian (so dd/mm/yyyy). Excel file sample is: Using the excel parser the output is all converted to American format (mm/dd/yyyy): SnapLogic clearly knows it is dealing with Dates....

How to get execution details of a pipeline using REST GET

I am trying to get the execution details of a pipeline using the REST GET snap. As I can see from the documentation it is done with calling the API: https://elastic.snaplogic.com/api/1/rest/public/runtime/<organization>/<ruuid>?level=detail in the ...

CORS Setting in Cloudplex

I have created triggered task in cloudplex which is tested & working from postman but the same is not working from javascript. Just want to know if any one done any setup for Cross Origin Request Sharing (CORS) in snaplogic cloudplex

Can we get the name of scheduled tasks

Hello Everyone, I am getting all the schedule task details in manager Here is a screenshot that shows all the task names, so I need to capture these through API in Rest get snap, and even if possible I need all the details of the task. https://docs-...

Converting local UK dates in to UTC ISO formats

Hi I am looking to take a local UK format DATETIME and convert it to an ISO UTC format Currently I am parsing the date using a substring() in to LocaleDateTime.parse($inputStrings) to create a snaplocaledate value When I try to parse the value out as...

How to cite entries in an array of JSON (position of entries is not fixed)

Hi, Below is just an example JSON: { "entity": { "entries": [ { "ID": "1", "Pipeline": "Pipeline_Completed", "Numbers": "10" }, { "ID": "3...

Design Approach for Downloading SLDB saved files using smb

Hello, looking for input regarding best approach to automate the manual download of various types of files (.csv, .xlsx, .zip) which are saved in the same project folder. We want to keep them available in Snaplogic but also download to another server...

SnapLogic - Integration Nation

Forum Posts

Dynamic Table Loads

Excel Parser - reading dd/mm/yyyy format

How to get execution details of a pipeline using REST GET

CORS Setting in Cloudplex

Can we get the name of scheduled tasks

Converting local UK dates in to UTC ISO formats

How to cite entries in an array of JSON (position of entries is not fixed)

Design Approach for Downloading SLDB saved files using smb

What account should be used for API with query par...

How to dynamically update an account?

Execute each child pipeline multiple times

Routing files from S3

Clean duplicated lines in CSV datasource

How to get all values of a key from objects in a l...

The "Pipeline execute" is changing data types?

Remove XML duplicate key from JSON list in XML for...

Generating individual files based on 'n' records f...

Convert array with objects into object with key/va...