Designing and Running Pipelines

How do I avoid multiple select requests

I have multiple data-stores and need to hydrate data pulled from one with data from another. The issue is that if I have two independent staring snaps perform the queries, I would have to pull every item in the table (hundreds of thousands) just to j...

Resolved! Remove empty tag from XML

I’m creating an XML by providing XML Schema to the incoming data. Can anyone provide some inputs how can I remove an empty tag from an XML?

SFTP File Read from client source

Howdy All! I am trying to read SFTP files using the Directory browser snap. Can someone guide me what should be filled out in the filefilter tab. I don’t have anything to filter. Files are in .csv format If that snap is incorrect, what should be the ...

Composite (JSON) Parameter?

Is it possible to evaluate a pipeline parameter that is itself a JSON document? I am finding a number of use cases for this, especially when using sub-pipelines and you need the input parameters to be pre-defined. It would clutter up a complex sub-p...

Sort snaps takes more time

Hi All, I have four sort snaps which run parallel. Few times they are getting sorted very quickly(in seconds), especially first time when I ran the interface, but next time or second time onwards, it is taking more time almost few hours. On the next ...

SAP IDoc Write Snap

Hi, Can any one explain the function of “IDoc Read BAPI Name” property in SAP IDoc Write Snap? Thanks in Advance!

How to pass a variable along the pipeline?

I have a pipeline that looks like this: The Snaps are: List all files in a given Box directoryFilter the files according to a maskRead the matching Excel file into the pipelineConvert the first Worksheet to CSVWrite a CSV file to an archive folder i...

Converting string into date and applying transformation failing

I am passing a timestamp as a variable through pipeline parameter as ‘p_querystring_modifieddateafter’. while applying logic as below in mapper and in REST GET snap parameters, I am getting the failure : Logic in Mapper : _p_querystring_modifieddatea...

SnapLogic - Integration Nation

Forum Posts

How do I avoid multiple select requests

Resolved! Remove empty tag from XML

SFTP File Read from client source

Composite (JSON) Parameter?

Sort snaps takes more time

SAP IDoc Write Snap

How to pass a variable along the pipeline?

Converting string into date and applying transformation failing

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