AZURE DATA FACTORY- copy activity to sql database returning only the first row

i m making two copy activities, one from a REST API and the second from a JSON file, both of them are returning only the first row in my sql database, i tried to copy this in a JSON file instead of sql database and it worked perfectly, it returned all the rows, i m wondering why in sql database it s returning just the first row,

anyone have an idea about this issue?

thanks

How many English words
do you know?
Test your English vocabulary size, and measure
how many words do you know
Online Test
Powered by Examplum