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
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?