Azure Data Factory - Data Flow - Rest API Access Token issue

Parviz Abbasov 1 Reputation point
2022-07-22T13:19:21.087+00:00

223861-linkedservice.png223823-errormessage.jpeg

Hello,

I am trying to load data from API to the Azure SQL DB. When I use copy activity it works fine when I try with data flow with same Linked Service and API it fails. Also unable to generate access_token in Web activity. Data Flow and Web activity give same issue, however in postman it works fine. Error message as below:

at Source 'MyOHSRawFile': java.lang.Exception: MIAuthenticator.toAdmsResponseToken failed, response payload is {
"access_token":"XXXXXXX",
"token_type": "Bearer",
"expires_in":"3599",
"scope": "general urn:xxxx:api-developers:token:demo_hello_api"
}: org.json4s.package$MappingException: No usable value for expires_on
Did not find value which can be converted into java.lang.String

I choose POST with empty body {}
223775-dataflow-request-body.png223740-dataflow.png223851-dataset.png

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,599 questions
{count} votes