SnapLogic - Integration Nation

peter · ‎03-12-2020

What is the best way to take data from a SQL Select statement and convert to JSON so that it can be used in a API put commend?

Abhishek_Soni37 · ‎06-17-2023

Hi @darshthakkar,

Based on the screenshot provided, I created a dummy JSON and used extend expression in Mapper to add an extra layer.

Input JSON:

Mapper Expression:

Final Result:

Pipeline:
Test_Expression_2023_06_18.slp (3.5 KB)

I hope this helps.

Cheers 🙂

View solution in original post

darshthakkar · ‎06-18-2023

Thank you @Soni37 for sharing the documentation link as well as the solution. That worked!
I, unfortunately cannot mark that as a solution as I’m not the author of the original post.

@dmiller - can you please do the needful, I’m sure you have the rights to do that.
Thank you.

Regards,
Darsh

SnapLogic - Integration Nation

Convert data from SQL select to JSON