The HttpStatusCode 500 indicates failure, Response payload:null

Chandra 21 Reputation points
2022-06-24T10:04:45.023+00:00

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: https://campaign.adobe.com/nl/jsp/soaprouter.jsp Response payload:null"

Can anyone comment on this???.

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

214747-copy.png

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

Accepted answer
  1. HimanshuSinha-msft 17,641 Reputation points Microsoft Employee
    2022-06-24T20:23:05.587+00:00

    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 .
      https://learn.microsoft.com/en-us/azure/data-factory/connector-rest?tabs=data-factory#rest-as-source

    214890-image.png

    Please do let me if you have any queries.
    Thanks
    Himanshu


    • 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
    No comments

0 additional answers

Sort by: Most helpful