JSON in field of the table from MySQl

[alanhanssen]

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.

[v-yuezhe-msft]

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