Problems creating a POST in Data Factory

Question

Hi!
I am trying to create a POST to an REST-API but I get this output (Caught by an Logic Apps HTTP grab):

{
"headers": {
! "Connection": "Keep-Alive",
"Accept": "application/json",
"Accept-Encoding": "gzip,deflate",
! "Host": "prod-187.westeurope.logic.azure.com:443",
"User-Agent": "azure-data-factory/2.0",
"Content-Length": "55",
! "Content-Type": "application/json",
"Content-Encoding": "UTF-8"
},
"body": {
"$content-encoding": "UTF-8",
"$content-type": "application/json",
"$content": "eyJuYW1lIjoiSmVzcGVyIEIuIEhhbnNlbiIsInNhbGFyeSI6IjEyMzQ1IiwiYWdlIjoiMzQifQ=="
}
}

I would have expected this:

{
"headers": {
"Accept": "application/json",
"Accept-Encoding": "deflate,gzip",
"Host": "prod-187.westeurope.logic.azure.com",
"User-Agent": "Mozilla/5.0,(Windows NT 10.0; Win64; x64),AppleWebKit/537.36,(KHTML, like Gecko),Chrome/103.0.5060.134,Safari/537.36,Edg/103.0.1264.71",
"X-Real-IP": "212.237.135.241",
"Content-Length": "42",
"Content-Type": "application/json"
},
"body": {
"name": "Jesper B. Hansen",
"salary": "12345",
"age": "34"
}
}

Why is the output scrambled?
I tried using a REST Service on a sink, and also tried it with an externalCall no real difference...

I must say, I am new at ADF, but I hope you have some good help for me.

Answer 1

Hi @Anonymous ,

Welcome to Microsoft Q&A platform and thanks for posting your question.

As I understand your ask, you are trying to use Web activity to make an API call. However, you are receiving output with symbols that is not expected.

In order to remove those from the output, you can pass the web activity output into a set variable activity and try the following expression @replace(string(activity('web activity1').output.Response),'!','') to replace the unwanted characters.

Hope this will help. Please let us know if any further queries.

------------------------------

• 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

Answer 2

This is my test-setup so far: