Designing and Running Pipelines

Resolved! Get Pipe Run Time ID

When I’m trying to insert data into the Teradata table, I also want to insert the pipeline run time id into a column to log as an entry. Can anyone suggest a way to get the id into a mapper when the pipeline is executing?

Cannot format date correctly to YYYY-MM-DD

Hi there, I’ve looked at other articles addressing this but non has helped me so far. Im looking to format a date in the DD/MM/YYYY to YYYY-MM-DD. The date will always be populated. I’ve tried the following expressions but they wont process correctly...

XML not getting populated with all Data from Source

Hi, I have run into an interesting situation where my XML generator is not populating entire CSV file I reading. Basically, I am reading CSV file and trying to send that as one batch to SAGE Intacct using XML generator. but, in turn the XML generator...

Py Script snap

I am building a pipeline which need to make recurring API call and consolidate the result. But when I call the API inside py script snap then it does not return result as the API default result. I tried to use two methods of get as get.getResponseBo...

How to Insert All Records but if there's an error then insert none

Hello, If I have 3 records that I want to insert into my database table, I use the “SQL Server - Insert” snap. However, if there’s 1 record that has an error (like let’s say one of the values has text in an int column), the 2 other records still cont...

Getting index value from an array value

Wondering if someone could answer this question for me. Given the below array, how would I get the index number of $arrayField.name ===“Alex”? I can easily get the index of true and false by respectively doing this: $arrayField.indexOf(true) and $ar...

Is there a way we can parameterize repartition snap in SnapLogic Extreme?

Hi, We’ve have Extremeplex child pipeline that runs on Iterations. Based on user inputs we want to dynamically generate the no of Output files for each iteration, rather than specifying static value in Repartition Snap. I’ve also uploaded a snapshot ...

How to Transform SQL Server Records to JSON usable format

I am querying transactions_table and batch_table using SQL Server Execute snap. The batch_table returns 1 record, and in this example the transactions_table returns 2 records. I need to be able to pull the data into a JSON-format that is compatible w...

SnapLogic - Integration Nation

Forum Posts

Resolved! Get Pipe Run Time ID

Cannot format date correctly to YYYY-MM-DD

XML not getting populated with all Data from Source

Py Script snap

How to Insert All Records but if there's an error then insert none

Getting index value from an array value

Is there a way we can parameterize repartition snap in SnapLogic Extreme?

How to Transform SQL Server Records to JSON usable format

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...