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