I tried the HTTP url to pull some CSV data and sink the SQL DB table, i hope this helps with your initial query!
Source: Shows the HTTP endpoint dataset inside the Copy Activity.
HTTP connection inside the Copy Activity:
Example: the HTTP endpoint looks something like below, from which we pull the CSV data.
Please let us know if you need further help in this matter and we would be glad to help you further!
If the response is helpful, please click "Accept Answer" and upvote it. So that we can close this thread.