Forum Discussion
Zack92
4 years agoHelper III
How to add dynamically form ID to URL in Source API query?
Hello,
I am trying dynamically feed the form ID into the table, and it is giving me hard time. I have searched over this on the net and, I found that you can create a parameter, but did not work for me as a list of parameters is not visible to me on the manage parameter box.
Is there a way I can feed all IDs added into the custom column? So I can expand them all
Json.Document(Web.Contents("https://api.typeform.com/forms/"/"&[id]&/"", [Headers=[Authorization="Bearer ******************************"]]))
Thank you so much
2 Replies
- amitchandakSuper User
Zack92 , Are you looking for pagination in power query
https://medium.com/@marktiedemann/how-to-do-pagination-in-power-query-430460c17c78
- Zack92Helper III
amitchandak Thank you for the response. Honestly, not sure about pagination, I am trying to add URL for each column with ID (What is in the ID column).