peter
6 years agoNew Contributor III
Convert data from SQL select to JSON
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?
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 🙂