How To Iterate Web Results Using Power Query M

[Kumshan450]

I watched the youtube link https://www.youtube.com/watch?v=LwIod7Dm46s and found that we can do web scrapping. 

In the video, user shared an url which can be made dynamic - https://ndb.nal.usda.gov/ndb/search/list?=qlookup=

For eg if you want data related to banana if you type banana after qlookup- 

https://ndb.nal.usda.gov/ndb/search/list?qlookup=banana

I want to replicate the same thing for the url: http://mis.mptransport.org/MPLogin/eSewa/VehicleSearch.aspx

Where if i change the vehicle registration automatically query result should change. 

I am stuck in the first step of automating web scrapping - making the url dynamic. 

Please help. 

Sample registation number: MP04QJ4708, MP04QJ5157 and MP09NL2414

[Kumshan450]

I wanted to  scrapping of data through web using power BI data import through web. 

Reference mtl: I watched the youtube link https://www.youtube.com/watch?v=LwIod7Dm46s 

In the video, user used an url for scrapping of data through web - https://ndb.nal.usda.gov/ndb/search/list?=qlookup=

For eg user made the url search dynamic by modifing the url:  https://ndb.nal.usda.gov/ndb/search/list?qlookup=banana

I want to replicate the same thing for the url: http://mis.mptransport.org/MPLogin/eSewa/VehicleSearch.aspx

Abover url is to get vehicle registration details. 

I want to automated the vehicle registration search through above url. Currently how to make the url dynamic - Where if i change the vehicle registration number query should search automatically. 

Please help. 

Sample registation number: data: MP04QJ4708, MP04QJ5157 and MP09NL2414

[v-jiascu-msft · Accepted solution]

Hi @Kumshan450,

That needs the support of the service server. It seems mptransport.org doesn't support such a service. Please refer to https://ndb.nal.usda.gov/ndb/doc/index. the person in the video can do that because the USDA database provides an API which gives people the REST access. 

I searched mptransport.org and didn't find anything about the API.

Best Regards,