Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Fabric Data Factory - Akixi API Copy Data

Hi all,   I am relatively new to APIs and Data Factories. I am trying to extract some data from some reports using the Akixi API to append to some SQL tables on a Fabric Data Warehouse using Fabri...
pipelines
  • Anonymous's avatar
    Anonymous
    2 years ago

    Quick Update: We got it working by using the HTTP Connector instead of the REST Connector

HimanshuS-msft's avatar
HimanshuS-msft
Microsoft Employee
2 years ago

Anonymous  : I did read the docmumentation of the Akixi API and it does returns the data in JSON format , which is a requirment for API calls from copy activity . Now looking that the error which you shared it looks like it is complaining about the JSON data being in the malformed . 
I always use postman or curl to get the data from the API , to make sure that the configuration is working fine , once I cam sure then i go ahead and try to implement the same in copy activity . 

Thanks
Himanshu 

  • v-cboorla-msft's avatar
    v-cboorla-msft
    Microsoft Employee
    2 years ago

    Hi Anonymous 


    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.


    Thanks.

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Hi

       

      Unfortunately I haven't found a way forward as of now.

       

      Thanks

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        Quick Update: We got it working by using the HTTP Connector instead of the REST Connector