Designing and Running Pipelines

Triggered task vs ultra

Does anyone in the community use triggered task and whats the performance. since I m using triggered task for a project but it takes 3-4 sec for it to return a response. On the other hand using the same project as ultra reduces the time to 1 sec. Nat...

Pipleline unable to load data size about 150 Million

Unable to load data of 150 Million spent lots of hours trying to restrict data for few months but still the issue persists . Any one had the issues of loading large volumes of data ? any other inputs is appreciated .

Ability to dynamically reduce the fields in an output document based on a comma delimited list

Topic: Looking for a best practice and/or Library Expression to provide the ability to dynamically reduce the fields in an output document based on a comma delimited list. Description: We are using snaplogic as an information provisioning layer and n...

Convert array to object

The output is of the above form. Here root element(Array) is of the form of an array. How do we make it of the form of an object? To get the idea of the json form, the above is the json view of the output. In that, you can see that “d” is an array....

REST Post JSON Payload AND Use Snap Variable

i bumped into an issue here. how would i be able to pass in a variable for the “Service URL” parameter of the REST Post snap if prior to the REST Post I did a JSON Generate Snap. With JSON Generate you lose the documents prior to that snap (there is ...

Connect SFTP server to fetch multiple files

Hi All, I am trying to connect SFTP server and fetch multiple files from the source remote directory. File Reader snap has an option to get SFTP account but doesn’t find how to provide remote directory path. In the remote directory, we are getting di...

Parsing exception

Hello All, I am having XML as an input to my pipeline. I have to map the elements from the incoming request and form a new request. I am facing a casting exception stating “Failure: java.lang.String cannot be cast to java.util.Map, Reason: Snap faile...

Getting runtime stats from Dashboard

I am looking to run analytics on the stats regarding thru put, failures, etc. to automate reporting. Is there any metadata tables I can access to get this info? Love this community and seeking to learn from a lot. Thanks.

SnapLogic - Integration Nation

Forum Posts

Triggered task vs ultra

Pipleline unable to load data size about 150 Million

Ability to dynamically reduce the fields in an output document based on a comma delimited list

Convert array to object

REST Post JSON Payload AND Use Snap Variable

Connect SFTP server to fetch multiple files

Parsing exception

Getting runtime stats from Dashboard

Transpose columns(Dynamic) into rows.

Is migrating of REST Snap to Http Client still man...

Change all Keys in JSON structure to lowercase

How to read .xlsb file

Append input data vertically

Difference between 2 dates

Find unmatched data using join

split target csv file into more smaller CSV's

How can I edit/update my community posts?

Http Client Snap vs REST Post snap