Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
So I need help trying to parse my json file from an API… I haven't been able to succesfully parse this into a table. I am receiving the following error:
"Expression.Error: We cannot convert a value of type Record to type Text.
Details:
Value=
379662=379662
396454=396454
396455=396455" ... etc etc
The function I am using looks like:
And the table:
In the image above you can also see my table failing. I'm trying to get this information listed in a single table with each row being a seperate purchase ID.
Any help would be greatly appreciated!
Solved! Go to Solution.
Hello @jcawley
check out this solution. It converts the json to a table with two column, using the field "purchase_ids" from your api output
let
YourJson = "{""total_found"":3, ""purchase_ids"":{""444636"":""444636"", ""444637"":""444637"", ""444638"": ""444638""}}",
ReadJson = Json.Document(YourJson),
CreateTable = Record.ToTable(ReadJson[#"purchase_ids"])
in
CreateTable
Copy paste this code to the advanced editor in a new blank query to see how the solution works.
If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too
Have fun
Jimmy
Also, here is an image from the webpage we are trying to parse the data from:
Hello @jcawley
check out this solution. It converts the json to a table with two column, using the field "purchase_ids" from your api output
let
YourJson = "{""total_found"":3, ""purchase_ids"":{""444636"":""444636"", ""444637"":""444637"", ""444638"": ""444638""}}",
ReadJson = Json.Document(YourJson),
CreateTable = Record.ToTable(ReadJson[#"purchase_ids"])
in
CreateTable
Copy paste this code to the advanced editor in a new blank query to see how the solution works.
If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too
Have fun
Jimmy
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.