Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Copy Data Activity with REST API POST - Issue with request body and escape characters

I am trying to use a copy data activity to get data from a REST API using a POST call and copy it to a lakehouse. The problem is that the copy data activity adds escape characters to the double quote...
data engineering
Data Pipeline
  • apturlov's avatar
    apturlov
    1 year ago

    Anonymous  I agree that using a Copy activity is a better choice in this case compared to a Web activity. But something just does not add up in this picture: Web activity can execute the call, but the Copy activity fails. Both activities should be using the same REST connector with the same request settings. Can you compare settings of Web and Copy activities and make sure both are configured the same way? You could also paste a schreenshot of your Web activity settings here for a second check.

  • v-venuppu's avatar
    v-venuppu
    1 year ago

    Hi Anonymous ,

    Have you compared the settings..?Can you also please paste a schreenshot of your Web activity settings here for a second check as requested by apturlov .

    Thank you.

apturlov's avatar
apturlov
Super User
1 year ago

Anonymous Can you post a screenshot of your COPY activity configuration for the body of your POST request? It sounds from your description that something is missing or misconfigured.

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    This is my configuration, the web connection works with other API calls with GET and the same exact call I am doing here works with Postman.

    As you can see in the input screenshot, the activity adds a bunch of escape characters.