Inser Column values into API

[Galat198]

Hi,

I have API Query like this:

where 400 this id number

After Pivot I get Table :

I have Other Table with IDs:

10 / 5000

Translation results

Number of rows with ID is dynamically 

I need make API with all IDs from Table with APIs

That is, each time place a different ID from a table in the API

And to get finally table like this:

(After, the result for each ID in the API, there will be different...)

How can this be done?

Thanks

[Icey]

Hi @Galat198 ,

You can refer to this blog: Use Column as Parameter for Custom Function in Pow... - Microsoft Power BI Community.

This blog is not the same with your scenario, but the method could be used.

Best regards

Icey

If this post helps, then consider Accepting it as the solution to help other members find it faster.

[Galat198]

@mahoneypat @JW_van_Holst 
Friends,
I changed the data type of ID to text and then added a custom column an API
Json.Document(Web.Contents(" https://xxxxxx/api/v1/retailers/"&[id]&"/payment_details?month=1&year=1"))
Where [id] will be changed by value in each row id column.....
And that opened a link for me for each line...lol
It seems to me that it works .. or I was wrong somewhere?

[mahoneypat]

That looks good.  Glad you got it working.

Pat

[JW_van_Holst]

I'm not sure if I understand the problem you are facing, but combining the two table is straight forward:

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMlSK1YlWMgKTxmDSRCk2FgA=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [ID = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"ID", Int64.Type}}),
    #"Added Custom" = Table.AddColumn(#"Changed Type", "Custom", each #"API table"),
    #"Expanded Custom" = Table.ExpandTableColumn(#"Added Custom", "Custom", {"base", "extra"}, {"base", "extra"})
in
    #"Expanded Custom"

[Galat198]

Thanks, @JW_van_Holst 
I didn't quite understand the answer...🙂 The task is to replace "400" within the API and replace it with each ID from a second table

[mahoneypat]

Please see if this video helps.

Power BI - Tales From The Front - REST APIs - YouTube

Pat

[Galat198]

It's not like,
Originally I get one value for each static API and not a list as in the example
*** Maybe need to run each API individually and place a different number dynamically from column and then unify them .... something like a loop...🤔🙄