Retrieve a REST Response in a Single Field

When working with a REST API, you may want to retrieve the entire response and not parts of it. For example, to load it at once into a target column.

To retrieve the response content in a mapping using an HTTP REST metadata, add an extra field named rawContent under the response node:

retrieve response add field

This field corresponds to the entire response, and you can map it to your target:

retrieve response map field

The rawContent extra field does not support binary data. To read binary data such as files returned by REST APIs, use the content node, defined as BINARY.

The data loaded in the target column is the entire response. In this example, JSON data:

{
    "response":
    {
        "data":
        {
            "customer":
            {
                "cus_id": "0",
                "tit_code": "M",
                "cus_first_name": "John",
                "cus_last_name": "Doe",
                "cus_company": "acme"
            }
        }
    }
}