When a user makes a request to an API, the response data is flattened and converted to CSV format compatible with google sheets.
What response data format is supported in Custom API?
Currently, the response of the data should have the header with Content-Type as “application/json” or any stringified JSON.
If we receive any other data format, the error will be shown as “data type is not supported”
How to view raw response data?
When you import the data, you will see the SUCCESS message at the bottom of the addon.
You can click on the “(Response)” link in the bracket.
After clicking on the link a pop up will open which will display the following information
- Response Code
- Response Headers
- Response Body
