Designing and Running Pipelines

Change OBJECT to ARRAY using Mapper

Using Mapper, we can change the Object in to array. In the below pipeline , data is generated using csv generator in plain text. Pipeline CSV generator configurations Changing the name from object to list. $Name instanceof Array?$Name :[$Name] Her...

Creating one more field in list of objects by using the fields in same objects

Hi Team, I have the below input data : [ { ID:123 “Name”:“Tony”, “Age”:24 }, { ID:124 “Name”:“Sam”, “Age”:36 }, { ID:125 “Name”:“Glenn”, “Age”:58 }] I need to add one more field ‘halfAge’ to the above and output data should be like below: [ { ID:123 ...

Task running ServiceNow Query snap - intermittent errors

When running a task with a ServiceNow Query snap against the incident table, in the error message: An error occurred while fetching the records (status code: 400). This related to the incident records or possibly a lost connection to ServiceNow.? I...

Ultra pipeline caching issue - SAP execute snap

Hello, Did anyone ever had caching issue with Ultra pipeline. I have ultra pipeline calling SAP BAPI using SAP execute snap. While executing the pipeline we are facing caching issue, where the response object of call 1 being returned for call 2. Than...

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?

SnapLogic - Integration Nation

Forum Posts

Change OBJECT to ARRAY using Mapper

Creating one more field in list of objects by using the fields in same objects

Task running ServiceNow Query snap - intermittent errors

Ultra pipeline caching issue - SAP execute snap

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

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

Converting a string to JSON doesn't work

Rest Post for Multipart form type content type wit...