web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Using Power Automate/M...
Power Automate
Unanswered

Using Power Automate/Microsoft Flow to convert json data into SQL server

(0) ShareShare
ReportReport
Posted on by 11

Hi, I was wondering if anyone knows how to convert JSON data into a structure that can be loaded in a SQL table. 

 

My current flow looks something like this

 

Power Automate Question.png

 

AutomateBuddy

Categories:
I have the same question (0)
  • Verified answer
    yashag2255 Profile Picture
    24,769 Super User 2024 Season 1 on at

    Hey @AutomationBuddy 

     

    You can do something as shown in the image below for the SQL insert row action too: 

    kkf.PNG

     Note that you need to appropriately provide the JSON schema and if you are not sure about the schema, run the flow and copy everything from the http action output and in the parse json action select the generate schema from payload option and paste everything here and it will generate the schema for you that can be used to identify individual attributes in the dynamic selector for the consecutive actions. 

    Hope this Helps!

     

    If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

  • Verified answer
    AutomationBuddy Profile Picture
    11 on at

    Thanks @yashag2255 , I got it working now. See my flow below.

     

     

    API Flow.png

  • h44444n Profile Picture
    18 on at

    thanks for sharing your solution.

     

    How did you design the SQL table to import the json data into? 

     

    I'd like to extract the column names from the JSON and generate an create table statement but I'm unsure how to do it. 

  • JohnDuchock Profile Picture
    3 on at

    This worked brilliantly for me... however i had to set up the gateway on my laptop for proof of concept...
    would you guys suggest a dedicated virtual machine for hosting the gateway functions ?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 503 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 321 Moderator

#3
abm abm Profile Picture

abm abm 237 Most Valuable Professional

Last 30 days Overall leaderboard