Designing and Running Pipelines
Discuss how to use the SnapLogic platform.
cancel
Showing results for 
Search instead for 
Did you mean: 

Forum Posts

Performing an Action when there is no data

A common integration pattern is to do something when no data is received. For example, we might read a file, parse it, and find that no records meet some filter criteria. As a result, we might send an email, or insert a ticket into a ticket managemen...

ncrouch by Former Employee
  • 9174 Views
  • 14 replies
  • 8 kudos

In XML Document how to replace \\ by \

Hi,The Input data is in XML format, There are multiple array and inside that in some of field contains double slash and need to replace it with single , we tried to build json expression like below in mapper:Can anyone help with this.if anyone have a...

sshaikh_0-1699610569293.png
sshaikh by New Contributor
  • 500 Views
  • 0 replies
  • 0 kudos

Join array of Objects

Hi ,I have a requirement to join the array1 with array2 in the same document and fetch one column from array 2 into array1 if condition matches. I can do it by splitting the arrays and join them back again. I would like to to know if i can do it in m...

sravan by New Contributor II
  • 848 Views
  • 1 replies
  • 0 kudos

Resolved! Changing the key names dynamically

Hi,I have a requirement where we need to read 50 tables from oracle and put the data to postgres. there is no transformation logic in between . But issue is while loading to target the column names are slightly changing. for an instance , src_table1{...

sravan by New Contributor II
  • 1368 Views
  • 2 replies
  • 1 kudos

Date format issue.

Hi All,I have data type at input as a date fuction and expected same at output. But in mapping I need to keep as blank for the dates are invalid like 0001-01-01 or dates older than 2008-01-01. When I am trying to make an expression in mapper its not ...

sshaikh by New Contributor
  • 538 Views
  • 0 replies
  • 0 kudos

Transactions with sqlserver

Hi Community, Is there a possibility to have cross-snap transactions in snaplogic, where we manage the transactions manually (e.g. by manually issuing commit or rollback at the end of the transaction)? for a usecase, we’d need to run multiple inserts...

Matthias by New Contributor III
  • 1522 Views
  • 3 replies
  • 1 kudos