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 🙂
Thanks @bhupender.singh for your input, which was still helpful to me even after a year. 🙂
I was facing the same issue in Oauth2 Account, as it wasn’t auto-refreshing the token for me, and I was reluctant on taking the whole REST POST Snap approach.
In SFDC App, I had only Selected OAuth Scopes as “Full access (full)”, now I tried selecting both:
and generated the Client ID and Client Secret which I then used in the Snaplogic Oauth2 account. It works for me now! 🙂
Will keep posted on any other observations. Thanks again!
Hi, Could you please let us know what have you given in callback url at salesforce end. We are getting the below error while clicking on “authorize” in snaplogic salesforce oauth2 account.
error=redirect_uri_mismatch&error_description=redirect_uri%20must%20match%20configuration
HI @KTsnap,
I believe you need to add the Snaplogic redirect uri:
https://elastic.snaplogic.com/api/1/rest/admin/oauth2callback/rest
