Designing and Running Pipelines

XML not getting populated with all Data from Source

Hi, I have run into an interesting situation where my XML generator is not populating entire CSV file I reading. Basically, I am reading CSV file and trying to send that as one batch to SAGE Intacct using XML generator. but, in turn the XML generator...

Py Script snap

I am building a pipeline which need to make recurring API call and consolidate the result. But when I call the API inside py script snap then it does not return result as the API default result. I tried to use two methods of get as get.getResponseBo...

How to Insert All Records but if there's an error then insert none

Hello, If I have 3 records that I want to insert into my database table, I use the “SQL Server - Insert” snap. However, if there’s 1 record that has an error (like let’s say one of the values has text in an int column), the 2 other records still cont...

Getting index value from an array value

Wondering if someone could answer this question for me. Given the below array, how would I get the index number of $arrayField.name ===“Alex”? I can easily get the index of true and false by respectively doing this: $arrayField.indexOf(true) and $ar...

Is there a way we can parameterize repartition snap in SnapLogic Extreme?

Hi, We’ve have Extremeplex child pipeline that runs on Iterations. Based on user inputs we want to dynamically generate the no of Output files for each iteration, rather than specifying static value in Repartition Snap. I’ve also uploaded a snapshot ...

How to Transform SQL Server Records to JSON usable format

I am querying transactions_table and batch_table using SQL Server Execute snap. The batch_table returns 1 record, and in this example the transactions_table returns 2 records. I need to be able to pull the data into a JSON-format that is compatible w...

Retrieve Filename into Mapper from Box Read

How can I catch the Filename “Box Read” Snap opened into the “Mapper” snap?

Trying to validate JMS account for IBM MQ

I’m trying to configure a JMS Producer that will communicate with a client’s WebSphere MQ, v9.1 (I think). I’ve received the jar files from the client’s lib directory, and that list of files resembles, but is not identical to, the list suggested in h...

SnapLogic - Integration Nation

Forum Posts

XML not getting populated with all Data from Source

Py Script snap

How to Insert All Records but if there's an error then insert none

Getting index value from an array value

Is there a way we can parameterize repartition snap in SnapLogic Extreme?

How to Transform SQL Server Records to JSON usable format

Retrieve Filename into Mapper from Box Read

Trying to validate JMS account for IBM MQ

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