Pulling Data From an URL into (ADF or Azure Synapse) anyone will work?

Viewed 37

My task is to load data from two URL into azure Synapse. We have a Table in Synapse DB that have Column names Currently and we have to load data from the URL into this Table. The URL are

  1. https://nces.ed.gov/globallocator/index.asp?search=1&State=&city=&zipcode=&miles=&itemname=Evangel+university&sortby=name&College=1&Status=Search+Finished&Records=1&CS=5F80ABB1

2.https://www.usnews.com/best-colleges/evangel-university-2463

In first url we have to provide the name for the institution name and then search for it and from the form page we have to pull IPESID and from Address the last five digit we need to pull and load these values into Syanpse DB table .

From second URL we need to pick one value from the paragraph and load it into the table.

How we can achieve this?

0 Answers
Related