Forum Discussion
extracting values from API column in Power Query
After some steps i have a column with API link. what i want to do is create a new column with values that extracted from API column.
Lets say API column is Path. That consists API's. i need to related values for each row of API with new column.
sample Expected output:
Path Values
API1 18
API2 90
API3 37
What i tried:
I tried to use Invoked function and gives me a 4 fields.
ex:
let
LoadData = (player as text) as table=>
let
source=Record.ToTable(Json.Document(Web.Contents("https://....................."&player)))
in
source
in
LoadData
This return 4 fields.
example:
out of 4 values i only need to get total(item number 4 of above pic) values along with my API caolumn.
2 Replies
Anonymous if you wish to extract values from another column, it can be done easily in power query window. in the power query winow, right click on your api column and then select the option "add column from example" this will create a blank column for you. in the new column, type 2-3 values that you want as output. Power Query automatically fill other values basis your criteria.
