Showing results for 
Search instead for 
Did you mean: 
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.

Super User
Super User

Re: JSON in field of the table from MySQl

Have a look if you can replicate these steps with your data:

Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Imke Feldmann

How to integrate M-code into your solution -- Check out more PBI- learning resources here -- Performance Tipps for M-queries