How to update the odata linked service with access token dynamically in azure data factory

Hello @Praveena Uppalapati [ELB] and welcome to Microsoft Q&A. I have another solution to suggest.

Parameterize the additional header using the 'advanced' section, so the access token can be assigned when the pipeline runs. Then, at the beginning of the pipeline, use the Web Activity to fetch new access token.

I think it could look something like:

{  
    "properties": {  
        "parameters": {  
            "PassInAuth": {  
                "type": "SecureString"  
            }  
        },  
        "annotations": [],  
        "type": "OData",  
        "typeProperties": {  
            "url": "urlgohere",  
            "authenticationType": "Anonymous",  
            "authHeaders": {  
                "Authorization": {  
                    "type": "Expression",  
                    "value": "@LinkedService().PassInAuth"  
                }  
            }  
        }  
    }  
}  

I am getting the below mentioned error while i am trying to preview data.

The parameters and expression cannot be resolved for schema operations. Error Message: { "Message": "ErrorCode=InvalidTemplate, ErrorMessage=The template function 'LinkedService' is not defined or not valid." }

Hello everyone,

2/4/2024
I had to modify my answer. Unfortunately the solution is only working in debug mode, if pipeline started manually. When I tried to schedule run it with a trigger it won't work.

Thank you @MartinJaffer-MSFT for your solution, I never thought that I had to change the JSON config file manually as Add Dynamic Content [Alt + Shift + D] is not working in Auth headers section.

However, I had to change the syntax a little bit to make it work. The value for key "value" at the end of the JSON had to be "@{linkedService().PassInAuth}". In my case, I used "@{linkedService().pBearerToken}".

Finally I was able to pass the bearer token from pipeline to Dataset level, then to the OData linked service.

{
    "name": "Dynamics 365 Business Central",
    "type": "Microsoft.DataFactory/factories/linkedservices",
    "properties": {
        "parameters": {
            "pBearerToken": {
                "type": "string"
            }
        },
        "annotations": [],
        "type": "OData",
        "typeProperties": {
            "url": "https://api.businesscentral.dynamics.com/v2.0/76c8d9c0-349c-4674-9a3d-ef2417541b4d/Production/ODataV4",
            "authenticationType": "Anonymous",
            "authHeaders": {
                "Authorization": {
                    "type": "Expression",
                    "value": "@{linkedService().pBearerToken}"
                }
            }
        }
    }
}