Hello.
This is the website
It's the table on that page (has approx 1.7 million rows)
Hello
You cant import directly. For one thing the data is paginated
You might have to use some scripting language like powershell or python, to paginate and get the data.
There is an export button to export it to csv. Here's the url you can used to download csv file
https://opendata.camden.gov.uk/api/views/77ra-mbbn/rows.csv?accessType=DOWNLOAD
also a how-to get it using ADF