Using Templates to drive Smartlink or JSON output

Question

Has anyone figured out how to create Templates to drive the Target Schema in a mapper snap?  This would be useful to standardize JSON output schema outputs and also reduce the time it takes to map outputs.  If not can someone explain when and how a Target Schema actually shows something in a mapper?

rgoodman · Answer

This is such an amazingly helpful tool!  If you find yourself needing to create target definition across many fields, this save SO MUCH TIME!
Thank you Ali!!!

nganapathiraju · Answer

JSON generator does not trigger introspection as we call it.
Here is something one of my colleague @asharifian  shared with us.

In the past, when faced with mapping many fields, I either had to manually input the fields to the Mapper snap or strip out the Mapper JSON from the SLP file, copy to Excel, input the fields there, then paste back to the SLP. This process was tedious, time consuming, and prone to mistakes. Because of that, I created a CSV to Mapper pipeline. This is ideal for scenarios where you’re dealing with many fields and it’d take too long to manually input into the Mapper snap.
All you need is a CSV input file containing three columns: source, target, and expression (to indicate whether the field should have the expression toggle on or off). Sample CSV input file is attached. Once you’re done inputting your fields to the CSV (you can do this via Excel), upload it to the SLDB and execute the CSV_to_Mapper pipeline (attached).

Once the pipeline is finished executing, an SLP file is outputted (called OutputtedMapper.slp). Import this SLP file to the SnapLogic platform and you’ll see your outputted Mapper is there with all of the fields. You can now copy/paste that Mapper snap to your main pipeline.

Hope this helps. Feel free to modify the pipeline as you see fit for your use case.

Here are the sample csv and pipeline.
Please rename the test.csv.txt to test.csv
test.csv.txt (234 Bytes)
CSV_to_Mapper.slp (19.3 KB)

nganapathiraju · Answer

SmartLink is only enabled when the mapper is the snap before a target snap (like a database, or rest or soap or whatever end point) and of course you have incoming document schema.
If there is anything between mapper and the target snap, then it may not work.

murphy-brian · Answer

So why can’t I use a JSON generator input on the output side of a Mapper to force a schema?  This way I can map and control the output without having to do all the manual mappings?
This also provide the ability to define reusable Schemas

nagaraju_julaka · Answer

Hi Team,
We have requirement to generate the mapper dynamically based on the input file which has huge number of columns , i have used the pipeline code mentioned above for generating the mapper dynamically but it’s generating the pipeline itself so how to import the pipeline generated by above code into the project without manual intervention through the pipeline code.
Please suggest is there any way to achieve the above requirement , if not please suggest me is there any other way to create the Target schema dynamically.

Forum Discussion

Using Templates to drive Smartlink or JSON output

5 Replies

Recent Discussions

Pagination and nextCursor in header

Javascript to promote top level lists

Google Sheets Subscribe questions

Basic string transformations not working

Can we generate XML file in pretty print format using native snapLogic snaps?