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

Help to parse Json data into csv

Updating Salesforce contact object and Account Loo...

Slicing Data from JSON

Connecting Confluent Kafka using OAuth

Hexadecimal to binary conversion

array.map if field1 meets criteria, I want field2

Filter Array data

How to create timestamps and out put them only usi...

Do JSON mapping in a single mapper

Problem with nested mappings