Passing a string reference Id from another table using the web connector

[ceesarcaceres]

Hi,

I have a table with products ids that extract from Web connector like that:

I need to extract another API from web that it's required pass the id to url. So, for not to extract id by id, i want to use this field id to pass the id for url, something like that:

First Example:

let
    Id = Product[Id],
    #"To table" = Table.FromList(Id, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
    Source = Web.Contents("url?token=&id="&Id&""),
    Custom = Json.Document(Source),
    returnTable = Custom[returnTable]
in
    returnTable

or

Second Example using Parameters:

let
    Id = #"Put Parameters",
    #"To table" = Table.FromList(Id, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
    Source = Web.Contents("url?token=&id=Id"),
    Custom = Json.Document(Source),
    returnTable = Custom[returnTable]
in
    returnTable

In second example I created an parameter that make a query on table Product.

Anyone have a idea that can help me ?

Thank you !

[ChielFaber · Accepted solution]

I believe you can tackle your problem by first creating a function with one id and then add a function column to the table with id's. I've done something similar earlier. I just the very great technique shown by Patrick LeBlanc in this Guyinacube video about importing nfl data for multiple years:

https://www.youtube.com/watch?v=Z0U9UL9ORh8

[ceesarcaceres]

It's works Chiel, thank you for help