cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
alanhanssen Frequent Visitor
Frequent Visitor

JSON in field of the table from MySQl

 

 

I'm trying to get a single field that is hosted in a JSON type column from a table.

 

We changed part of the developer's team and the previous one, instead of creating a full table containing the information, they grab it in a JSON and put it in a single column.

 

The table-transformation to fix this issue is in the backlog but in the meanwhile, I would like to extract one field from that column.

 

Does anyone have idea? So the column is on the table "application_form" and the column containing the JSON is named "form" and the field I want to extract is named "intake"

 

I'm interested in rescuing the "intake" field for all the rows.

1 REPLY 1
Moderator v-yuezhe-msft
Moderator

Re: JSON in field of the table from MySQl

Hi @alanhanssen,

I am not sure what your JSON field looks like. You can review the following similar thread and blog to extract data from JSON.

Extract data from JSON field
Specifying JSON Query in Power Query – Example Statistics Sweden

if you fail to extract the data, please help to post JSON string for us to analyze.

Thanks,
Lydia Zhang

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.