chilly_bang
Board Regular
- Joined
- Jun 17, 2016
- Messages
- 57
Hi
I'm using Power Query to read some data through a web API. The API is queried with an URL containing some paramaters and responses with data. The query URL looks like:
The workaround here is simple: Power Query → read data from web → input url → done
Now i want to populate the query url with parameters from an Excel table, so the query urls will look like:
Could somebody point me to the correct workflow and syntax, so i reach my goal?
thanks and best regards
I'm using Power Query to read some data through a web API. The API is queried with an URL containing some paramaters and responses with data. The query URL looks like:
Code:
http://api.semrush.com/?type=url_organic&key=$key&display_limit=10&export_columns=Ph,Po,Ur&url=http://example.com/&database=de&display_filter=-Ph|Co|test
Now i want to populate the query url with parameters from an Excel table, so the query urls will look like:
Code:
"http://api.semrush.com/?type=url_organic&key=$key&display_limit=10&export_columns=Ph,Po,Ur&url="&[B]A2[/B]&"&database="&[B]B2[/B]&"&display_filter=-Ph|Co|test"
thanks and best regards
Last edited: