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

Forum Posts

PostgreSQL Bulk Upload

When the INSERT query getting fired from Snaplogic, the PRIMARY_KEY is going as null which is causing issue to insert the data in the destination PostgreSQL database.The primary key column is auto-increment but since from the query we are passing it ...

manojchit by New Contributor
  • 684 Views
  • 1 replies
  • 0 kudos

Resolved! Nest the document under another document

I have the data in below format{"assetguid" : "12345","sfdcid" : "02i79000003OFcKAAW","status" : "SUCCESS","updatedTime" : "2024-04-04T09:25:43.771Z"}I need to convert it to this format with out group by snap. is it possible?[{"sfdcAssetResponseSdo" ...

akarsh by New Contributor III
  • 1108 Views
  • 3 replies
  • 1 kudos

Resolved! optional field on mapper

Hello teamI am getting error "Cannot invoke a method on a null value, snap" due to optional field being absent. In some JSON the "primary_mkt_ind" field is coming as value "NULL" so I have the below check. But in some JSON that I am consuming, that f...