The HttpStatusCode 500 indicates failure, Response payload:null

Chandra 21 Reputation points

I am trying to fetch the data from Rest API for that I used web activity to generate session token and this session token is storing in set variable and this variable passing into Request body in copy data activity and inside copy activity I used Rest Connector and POST Request method and when I am trying to preview the data I am getting error like this "The HttpStatusCode 500 indicates failure.Request URL: Response payload:null"

Can anyone comment on this???.

+Attached screenshots for ref...,214801-web.png


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

Accepted answer
  1. HimanshuSinha-msft 19,376 Reputation points Microsoft Employee

    Hello @Chandra ,
    Thanks for the question and using MS Q&A platform.
    As we understand the ask here is how to make a REST API from ADF , please do let us know if its not accurate.
    After reviewing the snashots which you shared , i do not see as to how the token is passed to the actual POST call . This is what I suggest .

    1. First try to make the call using a postman/ curl to make the actaul call . This will let you know what are the short commings and then youc an fix that .
    2. I also see that the you are passing the headers which are you in XML , is that correct ? I think it should still work but just to let you know that the REST connector always accept the response in JSON only . So you need to check that out .


    Please do let me if you have any queries.

    • Please don't forget to click on 130616-image.png or upvote 130671-image.png button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how
    • Want a reminder to come back and check responses? Here is how to subscribe to a notification
      • If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators
    0 comments No comments

0 additional answers

Sort by: Most helpful