Hi everyone
Im trying to figure out a way to change an URL based on column with different items.
What i need is the item name to be variable based on a cell information.
My programming skills are comepletly awful since i'm new to programming.
Something like this:
I know its completly wrong, but is it possible to reference some parts of an url to another sheet column and cell? Now the column will have different amounts of listings so it could be 3 cells with information or it could be 30. It depends on the amount of information written into the cell in column A. But its should be able to identify when no more information is meet and stop there.
I've searching all over the web, but i couldnt find a specific identical request which i could borrow the coding.
Thanks in advance.
Im trying to figure out a way to change an URL based on column with different items.
Power Query:
Source = Web.Page(Web.Contents("https://www.albion-online-data.com/api/v2/stats/View/T5_HEAD_GATHERER_FIBER,T5_ARMOR_GATHERER_FIBER,T5_SHOES_GATHERER_FIBER")),
Data0 = Source{0}[Data],
What i need is the item name to be variable based on a cell information.
My programming skills are comepletly awful since i'm new to programming.
Something like this:
VBA Code:
Source = Web.Page(Web.Contents("https://www.albion-online-data.com/api/v2/stats/View/"Sheet2, Colmun"A"...")),
Data0 = Source{0}[Data],
I've searching all over the web, but i couldnt find a specific identical request which i could borrow the coding.
Thanks in advance.
Last edited: