Designing and Running Pipelines

Issue with SQL connection with groundplex running as service

Dear community and expert We have the following scenario: Snaplogic connects to a Store procedure provided by MSQL. The authentication method used by the MSQL server is “Windows authentication”. We have a groundplex running at a Windows based VMware ...

Get all paginated query results

Hi All, I have a scenario that I am hoping someone here can help with… I need to iterate through paginated results which I know is easily done when using a REST GET call. However in my case I have to use a REST POST call. Essentially I query records ...

Only Keep certains records based on higher version number

Hi everyone, I am listing database rows, and some could be duplicated with a newer version: eg: Col 1, Col 2, Col 3 124, 1, 0 124, 2, 0 124, 1, 1 124, 2, 1 I need to only keep the 2 last rows, which are the one with the Col3 being the maximum as it c...

IF statement in XML Generator

I’ve seen in some examples on how to incorporate a foreach loop in the XML generator, but I’d to do a simple IF statement. Anyone have an example of the edited XML in their XML Generator snap that contains an IF clause? Is it even possible?

How to include a doc type tag in XML

Hi Can anyone suggest a method to include a doc type tag in the already existing XML? Thanks in Advance…

Do we have ID match functionality in snapLogic?

Do we have ID match functionality in snapLogic? Do we have any snap to do id match or anything similar? If not, do we have a roadmap for this yet?

Resolved! How to merge CSV files

I have ‘n’ CSV files which have different data only in the first column separated by “|” but don’t have a header in a folder. How can I merge all of them into one single CSV file?

Can we pass input schema after the Document to Binary Snap?

Hi, I need input schema(input data) in File Writer snap which is after the Document to Binary Snap. Can we pass the schema(data) in any way? Thanks in Advance!

SnapLogic - Integration Nation

Forum Posts

Issue with SQL connection with groundplex running as service

Get all paginated query results

Only Keep certains records based on higher version number

IF statement in XML Generator

How to include a doc type tag in XML

Do we have ID match functionality in snapLogic?

Resolved! How to merge CSV files

Can we pass input schema after the Document to Binary Snap?

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