How to set custom header for OData linked service/data set in copy activity?

Andris Veidemanis 55 Reputation points
2023-03-27T13:19:13.8833333+00:00

Hello!

When copy data from OData service I would like to set custom header for requests.

Example:

{"additionalHeaders":"Prefer:odata.maxpagesize=50\n"}

But I can't find a way to this in linked service, data set or copy activity.

Is this possible? Then how?

If not - is this kind feature is in the new feature pipeline?

Thanks!

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,585 questions
0 comments No comments
{count} votes

Accepted answer
  1. ShaikMaheer-MSFT 38,441 Reputation points Microsoft Employee
    2023-03-29T10:17:49.19+00:00

    Hi Andris Veidemanis,

    Thank you for posting query in Microsoft Q&A Platform.

    Are you using Copy activity here with REST connector dataset? If yes, you will see additional headers filed to pass addition headers. Please check below screenshot.

    User's image

    Hope this helps. Please let me know how it goes. If not helps, kindly share more details which activity you are using and where exactly you want to define additional headers.

    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.