I am consuming a SENGRID API SENDERS trying to do a GET request (https://api.sendgrid.com/v3/marketing/senders) and the output is not returning in JSON format.
This is an example of how the data is returning on ADF:
"[{\"id\":1111111,\"nickname\":\"Marketing\",\"from\":{\"email\":\"abc@m.abc.com\",\"name\":\"Marketing\"},\"reply_to\":{\"email\":\"abc@m.abc.com\",\"name\":\"\"},\"address\":\"sometext\",\"address_2\":\"\",\"city\":\"sometext\",\"state\":\"\",\"zip\":\"00000\",\"country\":\"ABC\",\"verified\":{\"status\":false,\"reason\":null},\"updated_at\":1111111,\"created_at\":111111,\"locked\":false}]\n"
I have tried other APIs and they return JSON, but in this case it's different. I have also tried the API that I am having problems with on Postman it returns a JSON, but I don't know why it'ss not working on ADF.
As per this Documentation, currently web activity in ADF does not support JSON arrays as response.
That is why it is returning the JSON array as a string. I have tried with a sample JSON array and you can see it returned it as JSON string.
As a workaround, to get the above string as a JSON array, use @json()
on the web activity output response string.
@json(activity('Web1').output.Response)
This will convert the JSON string as JSON. For sample I am storing this in an array variable.
Result: