Designing and Running Pipelines

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?

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…

SnapLogic - Integration Nation

Forum Posts

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

How to include a doc type tag in XML

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?

Remove XML duplicate key from JSON list in XML for...