Designing and Running Pipelines

Check If Data Is Missing

I’m getting data out of a REST call and I need to check whether or not a certain entry is present or missing. My list of needed entries consists of, example: String1, String2, String3, String4. If only the the first three are present, how do I print ...

File Writer Output to GroundPlex

I am suddenly unable to write a file on my groundplex; has anyone see this before? Just a straight write, e.g., “file:///Users/rwhite/Development/test.json”. Oddly, I can read that exact file and location. The error I get follows as well some groundp...

Oracle execute with setting session variables

I would like to set date format and timestamp format for the session and run the select statement in oracle execute snap like this Begin execute immediate ‘alter session set nls_date_format=’‘MM/DD/YYYY’‘’; execute immediate ‘alter session set nls_ti...

Oracle dimension tables to Azure ADLS

We’re starting a project to move dozens of Oracle warehouse dimension tables to ADLS, and are using parent/child pipelines to pass table names. The pipelines correctly pass and resolve the table name to operate on. The child pipeline uses Oracle E...

Resolved! Oracle Table Partition Name as parameter

I have a child pipeline called from Pipeline Execute which is passing partition name as pipeline parameter to Oracle-Execute snap Oracle-Execute has a sql => “select * from obia1.sales_invoice_lines partition (” + _partName + “) where rownum < 11” th...

Downloading and writing a base64 encoded ZIP file

Hello, Has anyone had experience of downloading a base64 encoded ZIP file. It sounds relatively straight forward however the file that is created cannot be opened (m/s invalid file format error appears). The size of the file is almost the same as the...

Object mapping

I have a situation in which for one object I can have more than one node which has the same name. However, each node may be different by additional attributes "IsUpdated, “IsAdded”. It is also possible that the node doesn’t have any attentional attri...

Creating output file names dynamically for each SQL Server table data stream taken as input from configuration File

I am trying to create a pipeline which will take a configuration file as an input and it will have Table name and column names that i will need for that table. You can put any no of tables and for each table no of column selected will be different. I...

SnapLogic - Integration Nation

Forum Posts

Check If Data Is Missing

File Writer Output to GroundPlex

Oracle execute with setting session variables

Oracle dimension tables to Azure ADLS

Resolved! Oracle Table Partition Name as parameter

Downloading and writing a base64 encoded ZIP file

Object mapping

Creating output file names dynamically for each SQL Server table data stream taken as input from configuration File

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