Forum Discussion

MylenePBI's avatar
MylenePBI
Helper I
2 years ago

Ingest data form a rest API with Oauth2

Hello, I am trying to ingest data from a rest API using fabric data pipelines, but I am in trouble as oauth2 authentication isn't supported. Is it possible to know when it will be available?   I ...
General Question
Need Help
pipelines
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi MylenePBI ,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. Did your issue get resolved? Did my answer helped you?
Please let me know if you have any further queries.

MylenePBI's avatar
MylenePBI
Helper I
2 years ago

Hello, sorry for the late answer...I still have trouble with ClientId and SecretId, I am not sure where and how to put them in the process.

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi MylenePBI - Thanks for using Fabric Community,

    Inorder to understand how to use client_id and client_secret in your case, please follow below screenshot -



    1. Connection - Add your base URL here.
    2. Relative URL - Add your relative URL here.
    3. Body (Main point) - Can add your client_id and client_secret here in json format

    {
    "grant_type":"client_credentials",
    "client_id":"abcdefg",
    "client_secret":"123ghy456"
}

    4. Header: Add Content-Type : application/json

    Hope this is helpful. In case of any queries please feel free.

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Hello MylenePBI ,

      We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet .
      In case if you have any resolution please do share that same with the community as it can be helpful to others .
      Otherwise, will respond back with the more details and we will try to help .

      • MylenePBI's avatar
        MylenePBI
        Helper I
        2 years ago

        Hello, I've tried your solution, but I always have the same problem "unsupported media type".

        I am not sure what I do is ok. I have several Url:

        - 1 base Url 

        - 1 authorization URL (base+relative)

        - 1 token URL (base+relative)

        - 1 URL where I call the data.

        Currently I succeed in getting the data when I pass directly the token (that I get from postman) to the call with the last URL.

        I have tried to follow what you have said to get the token in fabric data factory: Connect to the base URL, add the token relative URL, add client id, client seret, username and password to the body, add Content-type Json-application in the header, use POST method, but I always have this answer.

        Error code
        2108
        Failure typeUser configuration issue
        Details
        {"ErrorMessage":"Unsupported Media Type"}
         
        My connexion to the base url is a web2 connexion with anonymous authentication. Could you please help?