Connecting LinkedIn API via Azure Data Factory REST API Linked Service

Question

Connecting LinkedIn API via Azure Data Factory REST API Linked Service

Lee Whieldon 6

How can I successfully use the REST API endpoint in Azure Data Factory to connect to LinkedIn API?

I am facing an issue where I try using the REST API in Azure Data Factory and try the 'OAuth2ClientCredential' (See Linked Service in ADF below):

Base URL = https://www.linkedin.com/oauth/v2/authorization

Token Endpoint = https://www.linkedin.com/oauth/v2/accessToken

Scope = r_ads,r_ads_reporting,r_basicprofile

I have disabled Server Certification Validation and I receive the below error:

Error Code: 20150

Details: Failed to get access token from your token endpoint. Error returned from your authorization server: {"error":"access_denied","error_description":"This application is not allowed to create application tokens"} Processed Http request failed.

Is there a field inside the Linked Service that I am neglecting to fill out to utilize the REST API to connect LinkedIn API to ADF?

Basel Alamroush 1 Reputation point

2022-09-27T07:40:31.673+00:00

Hello Lee,

I came across your post since I'm having the same issue. Have you found any working way to connect LinkedIn API to ADF?

Cheers, Basel

1 answer

Your answer

Basel Alamroush 1 Reputation point

2022-09-27T07:40:31.673+00:00

Hello Lee,

I came across your post since I'm having the same issue. Have you found any working way to connect LinkedIn API to ADF?

Cheers, Basel

Answer 1

KranthiPakala-MSFT 46,642 Microsoft Employee Moderator

Hello @Lee Whieldon ,

Thanks for the question and using MS Q&A platform.

As per my understanding, you are receiving the above error when you are trying to connect to Linkedin API from ADF REST connector using OAuth2ClientCredential (nothing but LinkedIn's client credentials flow). Please correct if I misunderstand the situation.

By looking at the error message, it indicates that your application didn't have the ability to use LinkedIn's client credentials flow to get the access token. Even from below highlighted statement from public document, my understanding is that Your application cannot access the APIs by default. You may have to reach out to Linkedin support to get the permissions to use client credentials flow for accessing the APIs.

Below are couple of stackoverflow threads where a similar topic has been discussed:

Also want to check if you have got a chance to test the same using other tools like POSTMAN? In case if you are facing the same issue in POSTMAN then you may have to reach out to Linkedin support to get help on OAuth2clientCredentials to access the APIs.

Hope this info helps. Please let us know how it goes.

KranthiPakala-MSFT 46,642 Reputation points Microsoft Employee Moderator

2022-01-27T23:51:20.377+00:00

Hello @Lee Whieldon ,

Thanks much for your response and clarification. So, now I understand that you are trying to connect to Linkedin APIs using Authorization Code Flow (3 - legged auth) and not Client credential flow (2-legged auth).

If this is the case, then I don't think it is possible to use 3-legged auth in Azure Data factory as 3 legged auth will require your application to direct the browser to LinkedIn's OAuth 2.0 authorization page where the member authenticates. Once after authentication, LinkedIn's authorization server passes an authorization code to your application which will be used to retrieve the access token. I don't think this is possible in Azure Data factory. But you should be able to use Client Credential flow (2-legged auth) in ADF to connect to Linkedin APIs as it is very generic approach which I have seen across other services (Please note that, I haven't tested as we need to get in touch with Linkedin support to use Client Credential flow).

I will reach out to product team to check if there is any other workaround in ADF to connect to Linkedin APIs using 3-legged auth and will keep you posted as soon as I have an update. Feel free to respond with any additional queries so that I can double check with product team on the same.

Thank you
Lee Whieldon 6 Reputation points

2022-01-31T17:31:41.573+00:00

Thank you for your assistance & verifying if it is possible to use 3-legged auth in ADF.
KranthiPakala-MSFT 46,642 Reputation points Microsoft Employee Moderator

2022-02-09T08:05:19.637+00:00
Hello @Lee Whieldon ,

As per recent conversation with internal team, we have seen lot of issues trying to get the REST API connector to work Linkedin APIs. So, the recommendation is to write you own code, may be Python script and then using an Azure Batch to automate it. You may use the Custom Activity to schedule the batch.

I would also recommend you to please share your feedback/feature request in IDEAS forum here - https://feedback.azure.com/d365community/forum/1219ec2d-6c26-ec11-b6e6-000d3a4f032c and do share the link here once it is posted so that other users with similar idea can up-vote and comment it. It will also help us share this feedback to relevant product teams.

Hope this info helps. Do let us know if any further queries.

Thank you

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

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
KranthiPakala-MSFT 46,642 Reputation points Microsoft Employee Moderator

2022-02-11T21:02:39.637+00:00

Hello there,

Just checking in to see if the above information was helpful. If this answers your query, do click Accept Answer and Up-Vote for the same. And, if you have any further query do let us know.

Thank you
Lee Whieldon 6 Reputation points

2022-02-12T00:02:03.46+00:00

Hi Thank you for your reply. I'm not fully sure if this resolves my issues, outside of my having to submit a suggestion. I will keep it open until we have a clear solution. Thx!
KranthiPakala-MSFT 46,642 Reputation points Microsoft Employee Moderator

2022-02-14T22:26:47.583+00:00

Hello @Lee Whieldon ,

Thanks for your response. Could you please share your feedback in IDEAS forum: https://feedback.azure.com/d365community/forum/1219ec2d-6c26-ec11-b6e6-000d3a4f032c and do share the link here once it is posted so that we can pass the link to relevant product owners. Sharing your feedback in IDEAS forum will also help other users with similar requirement can up-vote and comment, which would also help increase the priority of the feature request.
Lee Whieldon 6 Reputation points

2022-02-16T15:33:57.317+00:00

See ideas link here: https://feedback.azure.com/d365community/idea/55c5c4ab-3d8f-ec11-a81b-6045bd7956bb
KranthiPakala-MSFT 46,642 Reputation points Microsoft Employee Moderator

2022-02-17T06:27:44.997+00:00

Appreciate much for sharing the feedback link here @Lee Whieldon . We will share this feedback with respective product team.

Thanks

Share via

Connecting LinkedIn API via Azure Data Factory REST API Linked Service

1 answer

Your answer