Pipeline(Azure Synapse Analytics) - copy activity HTTP header setting

Question

Hello.
I am downloading csv data using HTTP as the data source for copy activity.
I would like to add two headers "Authorization" and "Accept" to the "Additional Header", but I don't know how to write them.
I tried to write it like this in Jason code, but it returned an error.

"source": {  
                                    "type": "DelimitedTextSource",  
                                    "storeSettings": {  
                                        "type": "HttpReadSettings",  
                                        "requestMethod": "GET",  
                                        "additionalHeaders": {  
                                            "Authorization": {  
                                                "value": "@{concat('AnaplanAuthToken ',variables('access_token'))}",  
                                                "type": "Expression"  
                                            },  
                                            "Accept": "csv"  
                                        },  
                                        "requestTimeout": ""  
                                    },  
                                    "formatSettings": {  
                                        "type": "DelimitedTextReadSettings"  
                                    }  
                                },  

Please also refer to the attached documentation of Anaplan's API.

Answer 1

Hi,

In the additional headers, why do we see [Object object] in your screenshot?

Usually, we can use the Additional headers field in the data set and give expression like this

@markus.bohland@hotmail.de ('Anaplan Auth token ',dataset().tokenparam)

where tokenparam is the token passed to the data set parameter from the activity.

In the copy activity when you use the data set, you can pass the token from the variable.