REST POST request: QVX_UNEXPECTED_END_OF_DATA: Unexpected character encountered while parsing value

[pasi_lehtinen]

Hi,

We are trying to post notifications to external application with REST connection using POST method. I guess that we are only able to retrieve status response, and therefore I am facing issues when parsing response.

Here is my script:

NotificationAPI:
SQL SELECT 
	"response_type "
FROM JSON (wrap on) "root"
WITH CONNECTION (
	URL "$(vCoZoneNotificationAPI)",
    HTTPHEADER "Content-Type" "application/json"
    ,BODY "$(vRequestBody)"
);

and when we run the code, the load script fails with the following message:

---

The following error occurred:

QVX_UNEXPECTED_END_OF_DATA: Unexpected character encountered while parsing value: <. Path '', line 0, position 0.

---

Can someone help with this? Maybe @Levi_Turner  knows how to solve this? 🙂

Thank you!

[pasi_lehtinen · Accepted solution]

Okey, I got it working. The server was responding with HTML (login page) since I did not send bearer token or any other credentials.