How to pass query parameters to rest api for sharepoint from copy activity

Question

How to pass query parameters to rest api for share point (authorization through access token) from copy activity.

https://someurl.com/filename?QueryParameter=somevalue

This kind of passing the query parameters with the relative url is not working.

Could you please suggest on how to pass the query parameter.

Answer 1

Hello @Praveena Uppalapati [ELB]

Welcome to Microsoft Q & A.

I had tried the below way and it had worked for me.

Step 1 :

I had created a Parameter 'Relative URL'

Step 2 :

I am adding the above parameter to the RelativeURL property of the dataset.

Step 3:

Now in the RelativeURL parameter (Dataset Properties) of the Source setting of the Copy Activity.

I have configured the parameter with the value : ?$filter= Title eq Test

This is to filter items with the Title 'Test'

Output :

Sharepoint List Source :

Output at the end of the Copy Activity

Hope this will help. Please let us know if any further queries.

------------------------------

• Please don't forget to click on or upvote button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how
• Want a reminder to come back and check responses? Here is how to subscribe to a notification
• If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators

Answer 2

Thank you for the answer. It worked