Forum Discussion
Dynamic url connection
Hello, I have a list of more than 200 url to which I must connect to obtain data. Is there any way to do this quickly without having to connect again and again?
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])) ?
