Forum Discussion
Dynamic url connection
ImkeFand MarcelBeug will be your best bets for this.
Add a new column to your table where your call the URL for each row.
Or turn all of your operations per URL into a function and apply it like described in here: https://www.youtube.com/watch?v=RXm1MoxD1UA&t=94s
How can I create the function properly?
What custom function are you trying to use? Did you confirm it works with just one instance before applying to all? Does the custom column step time out even with something simple like =Json.Document(Web.Contents([url])) ?
I second what MarkLaf has said: To help you, we need to see the exact details for your function/query.
I have tried the function with a parameter but I still get the same error.
This is my data funete, it contains all the urls in JSON:
= Excel.Workbook(Web.Contents("https://docs.google.com/spreadsheets/d/e/2PACX-1vSwdO2Z5bz5axku2XRhWtLHhkVwTC2zNCcelMFxO_d5iXFNQeiKzNsjwSq6DOSLSf4xgqbekRw9Rvyu/pub?output=xlsx"), null, true)And this is my invoked custom function with one url :
= () => let Source = Excel.Workbook(Web.Contents("https://docs.google.com/spreadsheets/d/e/2PACX-1vSwdO2Z5bz5axku2XRhWtLHhkVwTC2zNCcelMFxO_d5iXFNQeiKzNsjwSq6DOSLSf4xgqbekRw9Rvyu/pub?output=xlsx"), null, true), #"Hoja 1_Sheet" = Source{[Item="Hoja 1",Kind="Sheet"]}[Data], #"Changed Type" = Table.TransformColumnTypes(#"Hoja 1_Sheet",{{"Column1", type text}}), #"Promoted Headers" = Table.PromoteHeaders(#"Changed Type", [PromoteAllScalars=true]), #"Changed Type1" = Table.TransformColumnTypes(#"Promoted Headers",{{"links", type text}}) in #"Changed Type1"This is the content desired of each url:
