Mapper vs. JSON Splitter
Did you know that you can use the Mapper snap to the same effect as JSON Splitter? There are some other reasons why you may want to use JSON Splitter. First of all let’s look at how mapper can achieve similar functionality of JSON Splitter To achieve the same split, in the mapper, just drag the array into the left hand expression and map it to $ in the right hand side target path. Basically this will split the array elements into the outgoing documents. Using JSON Splitter however, you get additional benefits of including scalar parents as well as including different output paths as part of the split. Attached is an example (simple one of course). json split vs mapper_2017_08_08.slp (7.1 KB)
AWS S3 Connection failure
Hello, I am trying to connect to the AWS S3 bucket with the Access Key Id and Secret access key using the AWS S3 Account type in Snaplogic. But it fails to validate and throws an error Failed to validate account:Cause: Access Denied (Service: Amazon S3; Status Code: 403 Using the same credentials I am able to connect with AWS S3 Bucket using AWS CLI and in PostMan as well by selecting Authorization type as AWS Signature. Can someone please help to identify why it is failing to connect in Snaplogic only?
Swap keys and values
Hi, I have a use case of lookup function where I have to use the same expression library but the lookup will happen both on the basis of key and value pair. Below is the expression library that I have uploaded { “Lookup”: { “Key1”: “Value1”, “Key2”: “Value2”, “Key3”: “Value3”, “Key4”:“Value4” } } Now I will get value1 from previous snaps, I want to use value1 to retrieve data as Key1. Can you suggest how this can be achieved? Regards, Shreegeet
How to make a generic pipeline Oracle => SQL Server
Hello, I would like to build a generic pipeline to load data from an Oracle DB to a SQL Server DB. I have more than 100 queries to load, so I would like to be able to call the pipeline with the Select (from Oracle) and the destination table as parameters. I already did a pipeline which works well if I have only Varchar in the select. If I put a timestamp in the select, I get the error “The conversion from UNKNOWN to UNKNOWN is unsupported.” I there a way to do what I am tring to do ? Thanks