Unable to process HTTP Response as JSON

[MOVC]

I have recently begun testing in Fabric. I am attempting to convert some of our existing business processes to Pipelines. In this example, I make a standard HTTP request which has a JSON response that I then enter into SQL tables. This works fine in the existing method (Power Automate), but in the Pipeline it doesn't seem to recognise the response as being correctly formatted JSON. As attached, if I select the JSON file format I receive an error. As a quick check, if I open the file as a delimited type, the output is shown in what appears to be correctly formatted JSON. However because this is a delimited format it is read as one long string and I cannot use the Mapping step. If I use the Web method instead of Copy Data, I can get a usable output but it has many escape characters \\\ that I need to trim out before I can use the OPENJSON function in a Stored Procedure to insert into a SQL table. While this is a workaround, it isn't ideal and I would like to use the Mapping function going forward.

Is there anything I can do to make the Copy step understand the output as JSON? The header includes Content-Type: application/json if this makes a difference.

[DennesTorres]

Hi,

If I understand, you are using the delimitedText type and the preview data to confirm you are receiving JSON. Did you try to copy the content of the previewdata into an online json validator, to ensure you are receiving it correctly?

Kind Regards,

Dennes

[MOVC]

Seems fine. I have been using this in an existing solution as said in the original message, if there was a problem with the response I probably would have hit an error there. Considering I can use the output from the web response as JSON, which should be the same response, that's why I think there's some issue with the Copy Data action.