Hello @Priti Bhangale
Thanks for the using the new forum .
It appears that you have the data in SQL and you are plannig to write that to ES using the API . The copy activity cannot be used as the in our case the sink will be http or REST and they are not supported as sink but only as source .
Please read on this here :https://learn.microsoft.com/en-us/azure/data-factory/copy-activity-overview
You didn't mentioned where is ES instance is hosted , if its on the public internet you can use lookup activity and web acticvity , if its on the local network , web activity cannot be used .
Please let me know if you have any further queries .
Please do consider to click on "Accept Answer" and "Up-vote" on the post that helps you, as it can be beneficial to other community members