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

Forum Posts

Removing a column from JSON array

Hello. say i have the following JSON: how can i remove one of the attributes / columns? Let’s say in the top left from the image above I want to remove the OwnerEmail value from that array… how could i do that in snaplogic? i’ve tried remapping but ...

Need to open up a date parameter

I need to temporarily modify a date parameter in a REST Get snap. The parameter ‘date_added’ uses the previous date: date_added = Date.parse(Date.now().minusDays(1)) I need to change it to include the range August 1st to previous date. So, I’m think...

vcocco by New Contributor II
  • 2182 Views
  • 2 replies
  • 3 kudos

SQL Server - Update deadlock issue

Hello All, I am getting transaction deadlocked errors while Updating the records. The snap being used here is SQL Server Update. Transaction (Process ID 92) was deadlocked on lock resources with another process and has been chosen as the deadlock vic...

jomalladi by New Contributor
  • 3062 Views
  • 2 replies
  • 0 kudos

Resolved! Loading jsonb postgres data

How can I load JSONB data using Postgres snaps? I’m able to load the data as TEXT type but not as JSONB type. Below is how I’m setting up my pipeline for inserting data to postgres db: Any answers would be appreciated!

anayak by New Contributor III
  • 2824 Views
  • 4 replies
  • 0 kudos