Content-Type application/json

Question

body of get request.jpg

web activity output.jpgI'm using a Web activity to do a GET request from a API.

In the header I have put in Content-Type and value application/json.

The json request body starts with a hard bracket and ends with a bracket ( see picture).

When I look in the output of the Web activity the Content-Type is "Content-Type": "text/plain; charset=utf-8"(see picture)

I was hoping for application/json but instead it's giving me it as a text/string

How can I get it out as a json into a variable. I'm trying to get the lastPage number

Answer 1

If you are able to use a Data Flow activity, go ahead. You can use aderived column to parse the string into a JSON object with an expression like fromJSON() or similar to parse the string into a JSON object.

Once you have the JSON object, you can extract the lastPage number by accessing the appropriate key in the JSON structure. You'll need to know the exact structure of your JSON response to do this correctly.

If the newlines (\n) and escaped characters (\) are causing issues in parsing, you might need to use string manipulation functions in your Derived Column transformation to clean up the response before parsing it as JSON.