extracting values from API column in Power Query

[Anonymous]

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.

[negi007]

@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. 

[Anonymous]

No.  i want to get API assioited values. I tried your approach didnt give the expected result.