Unlocking Snowflake Data Integration in Power Platform: Manipulating Snowflake REST API response in Custom Connector – Part 2
In this blog post, the author discusses how to manipulate the Snowflake API response using custom code with C# to transform the response payload. The article provides an example of the API response and explains how to update the custom connector to add the C# code for data transformation. The C# code provided in the article demonstrates how to transform the response in the required format. The article also includes PowerFX code for executing the SQL query in Power Apps and displaying the value in a gallery control. The author concludes by mentioning that while Power Automate offers data operations for such tasks, the method described in the article allows using the connector action directly within Power Apps.
Article 13m
Login now to access my digest by 365.Training
Learn how my digest works
Features
- Articles, blogs, podcasts, training, and videos
- Quick read TL;DRs for each item
- Advanced filtering to prioritize what you care about
- Quick views to isolate what you are looking for right now
- Save your favorite items
- Share your favorites
- Snooze items you want to revisit when you have more time