The HttpStatusCode 500 indicates failure, Response payload:null

Question

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...,

Answer 1

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

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

---

• Please don't forget to click on or upvote 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