I am trying to set up an API query profile with a POST request. This POST will not return any response payload object but just the response headers with a status code and other attributes that I need to read.
I am not able to configure query profile with this set up as matillion's query profile is expecting a response object to read.
@kanduko328 - the API Query Profile wizard expects the response to have a JSON body, so as to enable parsing and loading to a table, as the sole purpose of the API Query component is to extract and load data to a table.
One option is to to try the API Extract Profile wizard instead. And since this REST endpoint does not have a JSON body - you can fill in a static {} json body and load that to a staging table.
Another option would be to use the Python component and use python requests package to load and validate.
https://requests.readthedocs.io/en/latest/user/quickstart/
https://realpython.com/python-requests/
Hope this helps.