This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
FAQ
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Convert data from SQL select to JSON

Go to solution
peter
New Contributor III

‎03-12-2020 06:50 AM

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?

0 Kudos
Reply
1 ACCEPTED SOLUTION

Go to solution
Abhishek_Soni37
Contributor
In response to darshthakkar

‎06-17-2023 11:30 PM

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:
image

Mapper Expression:
image

Final Result:
image

Pipeline:
Test_Expression_2023_06_18.slp (3.5 KB)

I hope this helps.

Cheers 🙂

View solution in original post

Reply
5 REPLIES 5

Go to solution
darshthakkar
Valued Contributor

‎06-18-2023 09:14 AM

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

Reply