Designing and Running Pipelines

Programmatically get SLPROPZ contents and write to a file

Within a pipeline, how can I programmatically access the SLPROPZ file for a snaplex, and write the contents of the file out to the local hard drive? We have over 500 snaplexes that we need to do this for, so manually downloading them all is not a goo...

Resolved! Dynamic Parameter file name in S3

I would like to pass the pipeline parameter as _clearbit_region to S3 file name. It will be dynamic. how should we pass the parameter in filename? Any help would be appreciated Thanks

Value increment for each execution

Hi In Database i have field called “Product_ID” i need to update the field with ‘P-00001’ when i execute the first time and Second time when i execute the field should be updated with ‘P-00002’ please give me an solution how to implement using which ...

Resolved! Pad field with zero

How can i take a sql result field where I am counting the number of people in the file for a trailer and left pad with zeroes? I have tried a bunch of the expressions shown in several of the answers here but nothing is working. I get

PostgreSQL - Bulk Load with schema provided

Hello - I am trying to provide a schema for the PostgreSQL - Bulk Load snap to use. I’m getting an error that “Expecting a schema document with a map of column names to their descriptions”. I have a query that returns the column names and their data ...

Resolved! Money formatting

I am multiplying a salary field by 100. Any salary with a decimal point is still showing the decimal afterwards even tho in the mapper snap, it looks correct. Here is my code in mapper snap: ($RATE_1*100). It is showing correctly in mapper snap but w...

Ultra endpoints - Response is not returned to the caller

Hello, We started to experience very strange behavior with ultra tasks. Ultra tasks are up and running, but some of the endpoints are not returning the response back, even in dashboard we can see that the requests are processes successfully. Any thou...

CSV with header, detail, and trailer records on S3

I need to create a pipe delimited text file. The file needs to have a single header type record row with two columns, infinite number of detail record rows, and a single trailer type record row with three columns. 00|File Type Description 01|Data1|Da...

SnapLogic - Integration Nation

Forum Posts

Programmatically get SLPROPZ contents and write to a file

Resolved! Dynamic Parameter file name in S3

Value increment for each execution

Resolved! Pad field with zero

PostgreSQL - Bulk Load with schema provided

Resolved! Money formatting

Ultra endpoints - Response is not returned to the caller

CSV with header, detail, and trailer records on S3

Best Approach for Handling CSV Import with Truncat...

Fetch dashboard/monitor details via a pipeline

mapValues returns null when adding certain conditi...

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?